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 <hadoop.hiv...@gmail.com> 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! > > >