Is it possible to use "count" in Where clause ?

[shahab]

Hi,

I am quite new to Hive. I just wonder if a query like this is possible in
hive?

select * from events where events.pid = '123' having count(events.id) > 2

or more precisely is it possible to use " having count(events.id) > 2" in
Hive SQL ?

best,
/Shahab