Re: Is using an aggregate value in a where clause not supported?

Yes, this works. Thank you, -Stefán On Fri, Mar 4, 2016 at 8:55 PM, Jinfeng Ni wrote: > Can you try this: > > select sold_to, count(*) as trans_count from dfs.asa.`/transactions` > group by sold_to > having count(*) > 70; > > This is because column alias in the SELECT

Re: Is using an aggregate value in a where clause not supported?

Having fails as well On Fri, Mar 4, 2016 at 8:00 PM, Bob Rumsby wrote: > Without trying it or seeing your tables/files, I would expect this to work: > > select sold_to, count(*) as trans_count from dfs.asa.`/transactions` > group by sold_to > having trans_count > 70; > >

Re: Is using an aggregate value in a where clause not supported?

Without trying it or seeing your tables/files, I would expect this to work: select sold_to, count(*) as trans_count from dfs.asa.`/transactions` group by sold_to having trans_count > 70; On Fri, Mar 4, 2016 at 11:53 AM, Stefán Baxter wrote: > Hi, > > Having adds to

Re: Is using an aggregate value in a where clause not supported?

Hi, Having adds to the trouble and claims that the field needs to be grouped and then fails the same way if it's added to group by. I ended up wrapping this in a "with <> as ()" but that is far from ideal. Regards, -Stefán On Fri, Mar 4, 2016 at 7:50 PM, Bob Rumsby

Is using an aggregate value in a where clause not supported?

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