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

[#1 · Accepted solution]

Use the reflect UDF to generate UUIDs.

reflect("java.util.UUID", "randomUUID")

[#2]

Thanks siva

Note : The following syntax worked and helpful

select reflect("java.util.UUID", "randomUUID") mykey, name, .. from table_name

[#3]

When I try this I get the error:

H110 Unable to submit statement. Error while compiling statement: FAILED: SemanticException UDF reflect is not allowed [ERROR_STATUS]

[#4]

How to add auto increment culumn id in hive external table where we have to read the data from hdfs, i am not going to load or insert so please give the proper solution and syntax for that.

Thanks,

Sunny kumar