Reply
Highlighted
PKD
New Contributor
Posts: 1
Registered: ‎10-16-2017

Managed & External table

[ Edited ]

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

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