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. >