Is there a way to access ma partition in hive without specifying as value. Like as sub query .. select * from page_view where dt=(select max(dt) from page_view)..i tried this but its failing with syntax.
I'm on latest trunk, as named above. 0.9 might not have IN support. However, you might be able to work around using join instead. On Mon, Mar 24, 2014 at 4:26 PM, Darapaneni, Hazarath <[EMAIL PROTECTED]>wrote:
Try left semi join? It should equal to Xuefu¹s solution.
select * from jobs t left semi join (select max(dt) d from jobs) m on m.d=t.dt;
On 3/24/14, 5:41 PM, "Darapaneni, Hazarath" <[EMAIL PROTECTED]> wrote:
NEW: Monitor These Apps!
Apache Lucene, Apache Solr and all other Apache Software Foundation projects and their respective logos are trademarks of the Apache Software Foundation.
Elasticsearch, Kibana, Logstash, and Beats are trademarks of Elasticsearch BV, registered in the U.S. and in other countries. This site and Sematext Group is in no way affiliated with Elasticsearch BV.
Service operated by Sematext