New Contributor
Posts: 1
Registered: ‎10-16-2017

Managed & External table

[ Edited ]


 I need some help on the external table. i am using Hve in Hue editor in cloudera CDH to create the table. And after creation i can also query and validate the data is is populated in the table. But other users in the cluster cannot see the external table. Is there any setting I should enable to make the metadata available to all users?

 This happened during my certification exam where exam solution says no solution found in the schema whereas I have verified the exeternal table after creating it. Please help.




Expert Contributor
Posts: 126
Registered: ‎11-01-2013

Re: Managed & External table

Make sure other users have access to the HDFS file. Check file permissions, create a unix group and add all the users to that group and assign it to the HDFS file/directory where you laid hive table.
Em Jay