Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB