Reply
Explorer
Posts: 6
Registered: ‎09-12-2017

Tables appears correctly in Impala but not in Hive

[ Edited ]

HI Guys

 

I am using sentry with hive/impala CDH version 5.10

 

Secured via AD kerberos and AD group.

 

Access to tables is done via sentry, and all users can see correct databases in impala as per grant option but some users cannot see the same tables in Hive.

Hive.

no tables-hive.png

 

 


Hue - Impala - Editor.png

Expert Contributor
Posts: 83
Registered: ‎01-08-2018

Re: Tables appears correctly in Impala but bit in Hive

The Hive screenshot you provide, does not indicate the problem, because in this screenshot wou have "default" database selected. So the "missing" info below is not regarding databases, but not tables exist in the default database.

Can you click on "default" on the top of the red box? It will move you to the upper level.

Explorer
Posts: 6
Registered: ‎09-12-2017

Re: Tables appears correctly in Impala but bit in Hive

here is impala screenshot showing the databases. no databases appears in hive. Hue - Impala - Editor.png

Explorer
Posts: 6
Registered: ‎09-12-2017

Re: Tables appears correctly in Impala but bit in Hive

also in default using impala, i can see table but can't see them in Hivedefault impala.png

Expert Contributor
Posts: 83
Registered: ‎01-08-2018

Re: Tables appears correctly in Impala but bit in Hive

Logs from HUE and Hive would help. With screenshots, we can only guess what is happening.

In any case, you can check two things:

1) Check that Hive Server is running. This is not the case in my opinion because you should get an error in HUE. Just double check it. Impala connects to Hive Metastore, so it is not affected if Hive Server id down.

2) And most likely in my opinion, the users that cannot see databases, are not defined in the server where HiveServer is running. So Hive Server is not able to retrieve users' group and match it with a sentry rule. If you use LDAP/AD probably you have configured sssd (or equivalent) on each host. Check that this service is running and user info is fetched from LDAP/AD. If you have manually created users, then check that group info is correct.

 

Highlighted
Explorer
Posts: 6
Registered: ‎09-12-2017

Re: Tables appears correctly in Impala but bit in Hive

Hi

 

Tricky part is that some users (with same permission) can see tables and some cannot like me.

 

We are using sssd, i have restarted it and did "id userid" command. Groups appear correct but still no hive tables.

 

 

Announcements