Managed & External table

[#1]

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

[#2]

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.