Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Managed & External table

Highlighted

Managed & External table

New Contributor

Hi,

 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.

 

Thanks

Pramit

1 REPLY 1

Re: Managed & External table

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