hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Thusoo <athu...@qubole.com>
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...

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

Mime
View raw message