The big wins for us were (a) using appropriate indices & star trees, we could satisfy performance requirements for ad hoc queries, (b) SQL interface made it easy for the UI layer to build dashboards, and (c) we could bulk build segments (using Flink).