question Re: How to create auto increment key for a table in hive? in Archives of Support Questions (Read Only)

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

aravind_amirtha — Thu, 17 Dec 2015 15:25:26 GMT

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

hadoopsmi — Thu, 17 Dec 2015 15:27:54 GMT

Use the reflect UDF to generate UUIDs.

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

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

aravind_amirtha — Thu, 17 Dec 2015 16:23:22 GMT

Thanks siva

Note : The following syntax worked and helpful

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

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

lprisock — Fri, 12 Feb 2016 03:25:45 GMT

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]

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

kumarsunny949 — Mon, 29 Oct 2018 11:56:59 GMT

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