Hive

Extensibility

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