hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dima Machlin <Dima.Mach...@pursway.com>
Subject RE: HIVE SUB QUERY:: How to implement this case
Date Thu, 23 Jan 2014 10:16:41 GMT
Use join instead :

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 join ( select max(feed_key) mfk from summ_table ) st
where max_fed_key > mfk
group by as_of_dt ;

This join is done without an "ON" clause. This way, 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:yogeshhive@gmail.com]
Sent: Wednesday, January 22, 2014 7:42 PM
To: user@hive.apache.org
Subject: HIVE SUB QUERY:: How to implement this case


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



************************************************************************************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.
************************************************************************************

Mime
View raw message