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

Switch to Threaded View
Hive >> mail # user >> Help in ROW_NUMBER() OVER (PARTITION BY) in Hive


Copy link to this message
-
Re: Help in ROW_NUMBER() OVER (PARTITION BY) in Hive
Windowing functions (over clause) were introduced in 0.11 You need to
upgrade to 0.11 to make use of them.

Ashutosh
On Tue, Jul 2, 2013 at 7:19 AM, dyuti a <[EMAIL PROTECTED]> wrote:

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