Hi, Does Hive have any function equivalent to Oracle's dense_rank ( http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/functions038.htm) function? Here's what I'm trying to do:
For each user, I want to sort the page views in ascending order of time, and then number each page view with it's rank. This will enable me to easily identify a particular user's first page view, second page view, and so on. Is there any other way to approach this problem? If I can ensure that a particular user's (sorted) data is guaranteed to be processed on a single Hadoop node, then probably I can write a custom script to do the ranking for me. Saurabh. -- http://nandz.blogspot.com http://foodieforlife.blogspot.com
