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