Support Questions

Find answers, ask questions, and share your expertise

No database in impala in hue

avatar
Expert Contributor

 

 

 

 

 

Impala.PNG 

Hi Friends ,

I am not able to see database in impala in hue . what could be the reason ?

 

5 REPLIES 5

avatar
Super Guru
Do you use Kerberos/Sentry?
And Cloudera Manager?

avatar
Champion

Please check your hive metastore url in the

 

/etc/hue/conf/hue.ini

could you let me know are using a shared metastore for hive and impala .

if which database 

also check these parameters 

 

    [[[default]]]
      # Enter the filesystem uri
      fs_defaultfs=hdfs://localhost:8020
  name=Hive
      # The backend connection to use to communicate with the server.
interface=hiveserver2
    [[[impala]]]
      name=Impala
      interface=hiveserver2

avatar
New Contributor

same issue found all entry are in place but still not showing any database.

avatar
Master Guru

Hello @Axis_BDL ,

 

There can be several causes for no databases being found in the Hue Impala app, so it is a good idea to look for more information in the Hue log.  Usually the log file is /var/log/hue/runcpserver.log

 

Perhaps try tailing that log while you reload the Impala page in Hue.

 

We'll need some more information to help us learn what the problem is, so the Hue log is a good start.

avatar
New Contributor

Try running invalidate metadata;

At end clearing browser cache worked for me.