You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by shahab <sh...@gmail.com> on 2014/12/17 14:27:04 UTC

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

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