Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

show tables not showing in beeline

avatar
Contributor

Hi All,

 

We have replicated hive tables from CDH TO CDP through hive replication policy(BDR).

we did not see those tables when we connect to beeline and run show tables;also in hue as well.

but we are able to run select * from table and also we can see these tables in ranger .

 

 

Can anyone help me on this issue?

 

 

Thanks

Srini Podili

3 REPLIES 3

avatar
Guru

Are you not able to connect to hiveserver2 from beelne ?

 

You are not able to view tables in the databases?

Please provide a screenshot and also the beeline trace and url.

avatar
Master Mentor

@srinivasp 

 

I am wondering whether your Ranger policies are also in place.  Please explicitly give the correct permissions to the group/user in Ranger as the beeline authorization depends now on Ranger 🙂

 

 

Happy hadooping. 

avatar
Expert Contributor

Hi @srinivasp 

 

I believe you are missing SELECT and LIST privilege for the table in ranger for the user.

Can you try to list the tables using Hive user from beeline and check whether you are seeing the same problem?