Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - SQL help


Copy link to this message
-
Re: SQL help
Ashish Thusoo 2012-05-24, 20:53
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 <[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.
>