Reply
New Contributor
Posts: 2
Registered: ‎10-17-2018

No databases are available. Permissions could be missing

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
Posts: 518
Topics: 14
Kudos: 87
Solutions: 45
Registered: ‎09-02-2016

Re: No databases are available. Permissions could be missing

 

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

Announcements