Note : The following syntax worked and helpful
select reflect("java.util.UUID", "randomUUID") mykey, name, .. from table_name
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]
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.