Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> SQL help


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.
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB