Member since
12-21-2017
2
Posts
0
Kudos Received
0
Solutions
12-21-2017
02:09 PM
Thanks for your fast reply. I'm not using Ranger and Transparent Data Encryption is also not configured. Any other tips? Thanks Freddy
... View more
12-21-2017
12:01 PM
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!
... View more
Labels:
- Labels:
-
Apache Hive