HUE not showing databases or tables

[#1]

Weird anomoly on HUE

I have a instance using chrome hitting the same HUE instance on the same cluster

in 1 tab I can run Impala queries but newer tabs cannot run any queries

Chrome  Version 47.0.2526.73 (64-bit)

CDH 5.3.3 

Sentry is not enabled

[#2]

Could you type:

invalidate metadata

in the query editor?

And click on the refresh table icon in the assist

Romain

[#3]

did all of the above in the query editor
also checked firewalls (no changes)
restarted Impala and HUE
have not restarted Hive / Beeswax yet

[#4]

It may be a caching issue. So try changing the browser.
Like in my case it was working with hive but not with impala. Also i had disable the kerberos.


It may happen sometime when the kerberos is disabled from the cluster. So ensure following properties are changed on cloudera manager.

Zookeeper

enableSecurity (Enable Kerberos Authentication) FALSE

HDFS
hadoop.security.authentication: Simple
hadoop.security.authorization: FALSE
dfs.datanode.address from 1004 (for Kerberos) to 50010 (default)
dfs.datanode.http.address from 1006 (for Kerberos) to 50075 (default)
Data Directory Permissions from 700 to 755

HBASE

hbase.security.authentication: Simple
hbase.security.authorization: FALSE

Hue

Kerberos Ticket Renewer: Delete role or stop role

Kafka

kerberos.auth.enable: FALSE

Key-Value

hbaseindexer.authentication.type: FALSE

SOLR

olr Secure Authentication: Simple

Once Done. Try again same steps . else switch the browser, for eg change the browser to FireFox from chrome and try again. 

[#5]

For issue : Hue not showing hbase tables, we needs to give grant privilage to hue user in hbase shell.
take kerberos authentication using hbase keytab. then start hbase shell & use below command.
grant 'hue', 'RWXC'

Now you will find that hbase tables are showing in hue. same process is for hive also.