I want to do this in Pig.
"row_number() over (partition by col1 order by col2)"
Any suggestions how I can do this? I know I can do group by instead of
partition by and order by in Pig. But is there is any function with which I
can generate row number() or rank() as we can do in SQL?
Thanks for any help and suggestions.