I don't think it is possible to use just a view to get that effect. If you're generating the query programmatically, it'd be possible to either use the Thrift service or process the output of 'show partitions' to get the latest partition date.
From: lei liu [mailto:liulei...@gmail.com] Sent: Wednesday, October 20, 2010 6:30 PM To: hive-u...@hadoop.apache.org Subject: Search the newest partition of one table in view There is one table, I use one timer to create one new partition for the table every day, now I want to create one view, use the view to search the newest partition of the table,how can I receive the newest partition of the table in view? Thanks, LiuLei