Row number

[Ravisankar Mani]

Hi everyone,

 I need to find row number using hive query.
 Could you please help any way to find row number?

It is the sample sql query

select
  row_number() over (partition by NAME order by PRICE) as RANK,
  NAME,
  PRICEfrom
  MY_TABLE;

Regards,

Ravisankar