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