Re: hive partition questions

2014-03-24 Thread Selina Zhang
>inputs. > >Thanks, >Hazarath. > >-Original Message- >From: Xuefu Zhang [mailto:xzh...@cloudera.com] >Sent: Monday, March 24, 2014 7:36 PM >To: dev@hive.apache.org >Subject: Re: hive partition questions > >I'm on latest trunk, as named above. 0.9 mig

RE: hive partition questions

2014-03-24 Thread Darapaneni, Hazarath
I have tried Join but it's taking too much time. Thanks Zhang for your inputs. Thanks, Hazarath. -Original Message- From: Xuefu Zhang [mailto:xzh...@cloudera.com] Sent: Monday, March 24, 2014 7:36 PM To: dev@hive.apache.org Subject: Re: hive partition questions I'm on latest

Re: hive partition questions

2014-03-24 Thread Xuefu Zhang
nal Message- > From: Xuefu Zhang [mailto:xzh...@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 whe

RE: hive partition questions

2014-03-24 Thread Darapaneni, Hazarath
Which trunk are you in, am in 0.9. Thanks, Hazarath. -Original Message- From: Xuefu Zhang [mailto:xzh...@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 f

Re: hive partition questions

2014-03-24 Thread Xuefu Zhang
tion > > Thanks, > Hazarath. > > -Original Message- > From: Xuefu Zhang [mailto:xzh...@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

RE: hive partition questions

2014-03-24 Thread Darapaneni, Hazarath
#x27; 'max' '(' in expression specification Thanks, Hazarath. -Original Message- From: Xuefu Zhang [mailto:xzh...@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 PV

Re: hive partition questions

2014-03-24 Thread Xuefu Zhang
ry .. 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:xzh...@cloudera.com] > Sent: Monday, March 24, 2014 3:21 PM > To: dev@hive.a

RE: hive partition questions

2014-03-24 Thread Darapaneni, Hazarath
...@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. -

Re: hive partition questions

2014-03-24 Thread Xuefu Zhang
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 wrote: > Hi Team, > > > I have a scenario that I need help from you g