- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
show tables not showing in beeline
Created ‎07-07-2021 11:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created ‎07-09-2021 04:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎07-11-2021 10:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎07-11-2021 06:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
