Support Questions

Find answers, ask questions, and share your expertise

Managed & External table

New Contributor


 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
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