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 are really appreciated. Thanks in advance!