hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dyuti a <hadoop.hiv...@gmail.com>
Subject Help in ROW_NUMBER() OVER (PARTITION BY) in Hive
Date Tue, 02 Jul 2013 14:19:00 GMT
Hi Experts,
I'm working with Teradata query conversion to hive environment (Hive
version 0.10.0).The challenge that am facing here is in converting the
below line in query.


In SELECT clause:

ROW_NUMBER() OVER (PARTITION BY CLMST_KEY2
ORDER BY COUNTER) AS CLMST_ORDR_NBR

When searched found like instead of ROW_NUMBER()  I can go with
ROW_SEQUENCE using UDF. what to do with OVER clause and the rest.

Do I have to upgrade the version to 0.11.0 or any other way?


Any of your help is really appreciated.

Thanks in advance!

Mime
View raw message