Mohit Anchlia 2012-05-24, 20:02
Mohit Anchlia 2012-05-24, 21:13
Edward Capriolo 2012-05-24, 21:19
Mohit Anchlia 2012-05-24, 21:57
Roberto Sanabria 2012-05-24, 22:06
Gesli, Nicole 2012-05-24, 22:10
Mohit Anchlia 2012-05-24, 22:22
Roberto Sanabria 2012-05-24, 21:17
-Re: SQL help
Ashish Thusoo 2012-05-24, 20:53
Hive does not support window functions afaik.
The following link might be useful if you can bring that in...
Not sure if this is being brought into trunk at some point...
On Thu, May 24, 2012 at 1:02 PM, Mohit Anchlia <[EMAIL PROTECTED]>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.