rownum, row_number() or looping ability with hiveql?

[Kortni Smith]

Hi,

 

Is there a hive equivalent to Oracle's rownum, row_number() or the ability to
loop through a resultset?

 

I have been struggling to create a hive query that will give me max X
records, per something, when sorted by something.  For example, I have book
data, multiple records for any given isbn, and want the lowest 5 priced books
per isbn.

 

I can accomplish this in oracle with the following:

 

select isbn, price from

(

select isbn, price, row_number() over (partition by isbn order by price asc)
rn 

from kstest

)

where rn <= 5;

 

Any  ideas would be greatly appreciated.

Thank you,

 

Kortni Smith | Software Developer
AbeBooks.com   <http://www.abebooks.com/> Passion for books.

ksm...@abebooks.com <mailto:ksm...@abebooks.com> 
phone: 250.412.3272  |  fax: 250.475.6014

Suite 500 - 655 Tyee Rd. Victoria, BC. Canada V9A 6X5

www.abebooks.com  |  www.abebooks.co.uk  |  www.abebooks.de
www.abebooks.fr  |  www.abebooks.it  |  www.iberlibro.com