hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shahab <shahab.mok...@gmail.com>
Subject Is it possible to use "count" in Where clause ?
Date Wed, 17 Dec 2014 13:27:04 GMT
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

Mime
View raw message