How to create auto increment key for a table in hive?

[Jone Zhang]

The hive table write by many people.
How to create auto increment key for a table in hive?

For example
create table test(id, value)
load data v1 v2 into table test
load data v3 v4 into table test

select * from test
1 v1
2 v2
3 v3
4 v4
...


Thanks