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 23:26:33 GMT
Which trunk are you in, am in 0.9.

Thanks,
Hazarath.

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

I'm on latest trunk, and the following similar query worked for me:

select * from test as X where X.d in (select max(T.d) from test as T);


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

> I have tried but no luck..
>
> FAILED: Parse Error: line 1:27 mismatched input 'as' expecting EOF near '
> page_view'  and took out as and tried and it gave me  same syntax 
> error as earlier one.
>
> FAILED: Parse Error: line 1:48 cannot recognize input near 'select' 'max'
> '(' in expression specification
>
> Thanks,
> Hazarath.
>
> -----Original Message-----
> From: Xuefu Zhang [mailto:xzhang@cloudera.com]
> Sent: Monday, March 24, 2014 5:53 PM
> To: dev@hive.apache.org
> Subject: Re: hive partition questions
>
> You may try:
>
> select * from page_view as PV1 where PV1.dt IN (select max(dt) from 
> page_view);
>
>
> --Xuefu
>
>
> On Mon, Mar 24, 2014 at 3:47 PM, Darapaneni, Hazarath 
> <hdarapaneni@ea.com
> >wrote:
>
> > 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