I have some databases in hive. When I open hive I can see all databases but If I try to open beeline then I can not see some of them.

[#1]

Do you have hive ranger plugin enabled? If so, give yourself access to that DB.

[#2]

@Anjali Shevadkar

Adding to Sunil's reply, when using Hive Cli, the Ranger authorization is by-passed and only storage level authorization is checked for the user against the Hive warehouse locations. When accessing through Beeline, Hiveserver2 honours the Ranger authorization set at Hive policies, hence only databases with select/use access for that user are displayed.

For more details, refer below links:

https://community.hortonworks.com/articles/2497/hive-cli-security.html

https://community.hortonworks.com/articles/2497/hive-cli-security.html

[#3]

@Sindhu I have create a policy for all DB,all tables,all columns and gave access to the user, still I can't see the DB. There is DB list but that list is from another cluster. I have login on cluster2 and it shows all the DBs from cluster1 and from cluter2.

[#4]

@Anjali Shevadkar

Have you set one ranger instance for multi clusters? Did I understand you with this statement "I have login on cluster2 and it shows all the DBs from cluster1 and from cluter2."

Can you explain your setup.