You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Ravisankar Mani <rr...@gmail.com> on 2015/06/04 09:32:29 UTC

Row number

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