hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Darapaneni, Hazarath" <hdarapan...@ea.com>
Subject RE: hive partition questions
Date Mon, 24 Mar 2014 22:47:03 GMT
Thanks Zhang,

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.

Thanks,
Hazarath.

-----Original Message-----
From: Xuefu Zhang [mailto:xzhang@cloudera.com] 
Sent: Monday, March 24, 2014 3:21 PM
To: dev@hive.apache.org
Subject: Re: hive partition questions

As far as I know, select * from table gives you all data across all partitions, and I don't
think there is a config option to ask Hive to read "latest" partition.

--Xuefu


On Mon, Mar 24, 2014 at 12:34 PM, Darapaneni, Hazarath
<hdarapaneni@ea.com>wrote:

> Hi Team,
>
>
> I have a scenario that I need help from you guys, please check and let 
> me know, if it's feasible or not.
>
> Scenario:
>
> I have a table called page_view and it has 10 partitions with date
> (2013-12-20 to 2013-12-30) and I need to select latest partition 
> without giving date as where condition.
>
> If I do  select * from page_view then it should got to latest 
> partition as default (in this case its 2013-12-30) , is there a way to 
> do this in hive configuration.
>
> Thanks,
> Hazarath.
>

Mime
View raw message