Hi Mohit, Hive does not support window functions afaik.
The following link might be useful if you can bring that in... https://github.com/hbutani/SQLWindowing/wiki Not sure if this is being brought into trunk at some point... Ashish On Thu, May 24, 2012 at 1:02 PM, Mohit Anchlia <mohitanch...@gmail.com>wrote: > I am new to Hive. I have several SQL from RDBMS database that I need to > convert to hive. What's the best reference for HIVEQL? For now I am trying > to figure out how to do this in hive: > > Select distinct A_ID, First_Value(path IGNORE NULLS) over(PARTITION BY > A_ID ORDER BY t_timestamp) From WEB_DATA > > Any help would be appreciated. >