Reply
Highlighted
Explorer
Posts: 26
Registered: ‎12-08-2016

Regarding Hue and Hive. Can't see database on Hue GUI but can on Hive CLI

Please help me to solve the issue. I am working the same issue from 2 days but unable to find the correct solution. Any help is higly appreciated. I have attached the images of hive cli and hue web ui.

hive cli.pnghue hive database.pnghue-hive database issue (1).pnghuehive database.png

Posts: 519
Topics: 14
Kudos: 92
Solutions: 45
Registered: ‎09-02-2016

Re: Regarding Hue and Hive. Can't see database on Hue GUI but can on Hive CLI

@cdhnaidu

 

Hope you have enabled sentry ...

 

I can see that you login as hive user in hue. Can you login as admin instead of hive in hue and try...

 

Note: make sure you have required user, group, roles in both Hadoop and Hue. Also check your admin configuration setting in CM -> Sentry -> Configruation.

 

Few sample commands

beeline>Create role admin;
Granted priviledges to admin role.
GRANT ALL ON SERVER server1 TO ROLE admin WITH GRANT OPTION;
Assign the role to a group.
GRANT ROLE admin TO GROUP administrators;
After these steps all users within the group administrators are allowed to manage hive priviledges

Posts: 642
Topics: 3
Kudos: 121
Solutions: 67
Registered: ‎08-16-2016

Re: Regarding Hue and Hive. Can't see database on Hue GUI but can on Hive CLI

What do you see in hive CLI or beeline? It is possible the hdfs dirs/files were created outside of hive and the metadata doesn't exist.
Explorer
Posts: 26
Registered: ‎12-08-2016

Re: Regarding Hue and Hive. Can't see database on Hue GUI but can on Hive CLI

Thank you for the response.
Explorer
Posts: 26
Registered: ‎12-08-2016

Re: Regarding Hue and Hive. Can't see database on Hue GUI but can on Hive CLI

Hi,

 

I created a user called "commonuser" and group called "commonuser" in hue and linux machine.

 

Created role called "commonuser" in sentry app to access databases and gave "select" privilege.

 

Now, I logged in as commonuser in hue. In hue-hive editor the databases are visable but not in hue-Impala editor.

In impala only the default database without any tables is visable as show in the below screenshot. 

 

Please advice me on the issue. 

 

commonuser.pngcommonuser pic3.pngcommonuser_pic2.pngcommonuser_pic3.png