Member since
12-10-2018
1
Post
0
Kudos Received
0
Solutions
01-08-2019
02:25 PM
2 Kudos
Hi Rockem, The issue you are facing is due to hdfs permission. By default with "Store in default location" checked during hive table creation through Hue, we are trying to move the data to '/user/hive/warehouse' directory. The user you logged in don't have permission to move data to '/user/hive/warehouse', so table is created successful but no data. You can either grant the user with write permission to '/user/hive/warehouse' or uncheck the "Store in default location" checkbox so it creates external table without moving the file to '/user/hive/warehouse'. Then you will be abl e to see the data. Hope this helps! Weixia
... View more