All Forums Extensibility
Raja_KT 1246 posts Joined 07/09
08 Jan 2014
Hive

I have data like :

empid name salary.....

123    Joseph 1900

435     James 2000

675     Perez 6999

......

1 million records.

 

How do I achieve in query using hive to get sequence number like 

 

seqno empid name salary.....

1       123 Joseph 1900

2       435 James 2000

3       675 Perez 6999

......

1 million records. In database it is easy.

 

If this cannot be done in HIVE, can you please let me know, how to do in scoop or pig

 

Cheers

 

Raja K Thaw

My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1

Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.