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.

No databases are available. Permissions could be missing

Highlighted

No databases are available. Permissions could be missing

New Contributor

Hi, 

 

the databases are not listed on either impala or hive. I checked if the user can see the /Hive/warehouse and an error popsout. Please see image.

 

WEBEX is available for faster resolution.

 

Thanks!


1.png
1 REPLY 1

Re: No databases are available. Permissions could be missing

Champion

 

@Raffy

 

In general, your warehouse folder (/user/hive/warehouse) will have the following permission: 770 and the owner will be hive.

 

This will make sure only Hive user and group can only access, modify the data/db. it is required for your db security.