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

[Stefán Baxter]

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