Hive unable to create and upload table from csv-file

[#1]

Hello togehter,

i tried to create and upload a hive table from csv-file. I followed the same steps like here

https://community.hortonworks.com/questions/139702/create-hive-tables-from-csv-files.html

When I press "preview", i can see all collumns so that works. After clicking "create", hive creates the temporary table and the normal table but it stucks at the point Waiting for insertion of rows from temporary table to actual table. The file is only a small test file with 4 rows and columns. If I reload the UI I can query over the normal table and there are only the columns. In the temporay table there are the complete data from the file.

These are the warnings and errors from the hiveserver2.log

• WARN [HiveServer2-Handler-Pool: Thread-5328]: metrics2.CodahaleMetrics (CodahaleMetrics.java:addGauge(299)) - A Gauge with name [init_total_count_partitions] already exists. The old gauge will be overwritten, but this is not recommended

• WARN [HiveServer2-Background-Pool: Thread-5501]: conf.HiveConf (HiveConf.java:initialize(3060)) - HiveConf of name hive.internal.ss.authz.settings.applied.marker does not exist

• ERROR [HiveServer2-Handler-Pool: Thread-5689]: hdfs.KeyProviderCache (KeyProviderCache.java:createKeyProviderURI(87)) - Could not find uri with key [dfs.encryption.key.provider.uri] to create a keyProvider !!

Thanks in advance!

[#2]

Thanks for your fast reply. I'm not using Ranger and Transparent Data Encryption is also not configured. Any other tips?

Thanks

Freddy

[#3]

@Freddy, Since you're using Hive-view , I'd suggest you take a look at hive view logs to debug this further.

If you're using hive-view 1.5, logs are available : /var/log/ambari-server/hive-next-view/hive-view.log

For hive-view 2.0, the logs can be found at path : /var/log/ambari-server/hive20-view/hive20-view.log

[#4]

try looking at : https://community.hortonworks.com/questions/23674/hive-query-exection-fails-to-create-tables-sort-of...