Try using the HAVING clause. The WHERE clause cannot constrain the results of aggregate functions. http://drill.apache.org/docs/having-clause/
On Fri, Mar 4, 2016 at 11:34 AM, Stefán Baxter <[email protected]> wrote: > Hi, > > I'm using parquet+drill and the following statement works just fine: > > select sold_to, count(*) as trans_count from > dfs.asa.`/processed/venuepoint/transactions` where group by sold_to; > > When addin this where clause nothing is returned: > > select sold_to, count(*) as trans_count from dfs.asa.`/transactions` where > trans_count > 70 group by sold_to; > > > Is this a known limitation or a bug? > > Regards, > -Stefán >
