To emulate the RANK function you will need a custom UDF
Edward Capriolo has a nice one here
https://github.com/edwardcapriolo/hive-rank
Philip Tromans has another here https://github.com/philiptromans/hive-udf
If you're on 0.11 already there is a native version.
Hi Neelesh,
I've just upgraded our cluster from hadoop-0.20/hive-0.10 to
hadoop-1.03(mapr2.1)/hive0.10 and started running into this issue
immediately. Strangely is doesn't appear to happen all of the time or be
local to any nodes or set of nodes.
The only work around I've
