all the rows in
"feed_key_temp" table will be joined with a single row from st containing the
max(feed_key) value
From: yogesh dhari [mailto:yogeshh...@gmail.com]
Sent: Wednesday, January 22, 2014 7:42 PM
To: user@hive.apache.org
Subject: HIVE SUB QUERY:: How to implement this case
He
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_f
