row_number() over (partition by col1 order by col2)

[sonia gehlot]

Hi All,

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.

Sonia