hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravisankar Mani <rrav...@gmail.com>
Subject Row number
Date Thu, 04 Jun 2015 07:32:29 GMT
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

Mime
View raw message