Re: Hive equivalent of row_number()

http://www.quora.com/Hive-computing/How-are-SQL-type-analytic-and-windowing-functions-accomplished-in-Hadoop-Hive -- Alex K On Thu, Apr 12, 2012 at 1:43 PM, Saurabh S wrote: > > I have a table with three columns, A, B, and Score,

Hive equivalent of row_number()

I have a table with three columns, A, B, and Score, where A and B are some items, and Score is some kind of affinity between A and B. There are N number of items of each A and B, so that the total number of rows in the table are N^2. Is there a way to fetch "top 5 items in B" for each item in A