Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - HIVE SUB QUERY:: How to implement this case


Copy link to this message
-
HIVE SUB QUERY:: How to implement this case
yogesh dhari 2014-01-22, 17:42
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