Re: Drill query planning error

2017-07-26 Thread Aman Sinha
[Since this is Drill specific, I put dev@calcite on BCC]. If you have two aggregates: Count(distinct a), Count(distinct b), the Calcite logical plan consists of a cartesian join of 2 subqueries each of which first does a group-by on the distinct column followed by a count aggregate. By default,

Drill query planning error

2017-07-26 Thread weijie tong
HI all: I materialize the count distinct query result to a cache, then when user query the count distinct , a specific rule will translate the query to the cache. It turns out right when the query has only one count (distinct ) operator ,but when it has two count (distinct ) ,it causes error