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 <hdarapan...@ea.com>wrote: > 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 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 <hdarapan...@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: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 PV1.dt IN (select max(dt) from > > page_view); > > > > > > --Xuefu > > > > > > On Mon, Mar 24, 2014 at 3:47 PM, Darapaneni, Hazarath > > <hdarapan...@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:xzh...@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 > > > <hdarapan...@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. > > > > > > > > > >
