hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yogesh dhari <yogeshh...@gmail.com>
Subject HIVE SUB QUERY:: How to implement this case
Date Wed, 22 Jan 2014 17:42:28 GMT
Hello all,

I have a case statement where I need to work like this logic.

select as_of_dt as as_of_dt, max_feed_key as max_feed_key, min_feed_key as
min_feed_key from table feed_key_temp where max_fed_key > ( select
max(feed_key) from summ_table ) group by as_of_dt ;


Here, max_feed_key and min_feed_key are the fields in table  feed_key_temp.


As Hive does not provide (0.9 version)  sub query in where clause, Pls
suggest the work around it, and how to implement it


Thanks & Regards

Yogesh Kumar

Mime
View raw message