hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Thusoo <>
Subject Re: SQL help
Date Thu, 24 May 2012 20:53:38 GMT
Hi Mohit,

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

View raw message