Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hue Impala failing for all queries

avatar

I've been working with the CDH 5.5.0 VM for a couple of weeks.

* I started Tutorial number two.

* Loaded the data.

*Created the tables (in Hive).

* Now trying to use Hue Impala to query the tables.

 

Something happened in Hue such that Impala can't seem to load the metadata. In the database frame on the left side it says "The database list cannot be loaded." All Impala queries, even invalidate metadata, return the following error message:

AnalysisException: Syntax error in line 1: USE `` ^ Encountered: EMPTY IDENTIFIER Expected: IDENTIFIER CAUSED BY: Exception: Syntax error

 

impala-shell works fine for all queries and commands. It is only Hue that is having the issue.

 

I have done the following:

Run invalidate metadata in impala-shell (works fine)

Restarted Hue

Restarte Impala

Restarted the VM several times

 

This guy is having the same issue:

http://stackoverflow.com/questions/35018518/impala-query-editor-always-shows-analysisexception

 

Any help would be appreciated as I'm working on a POC to get approval for purchasing Cloudera.

Thanks all!

2 ACCEPTED SOLUTIONS

avatar
Cloudera Employee

Hi Scott,

 

Are you able to select a database in the database list dropdown on the left?  If not, can you try clearing your browser cache and reloading the page to see if it populates the dropdown?

 

Jenny

View solution in original post

avatar

Thanks for the reply Jenny (I've been going nuts with this)!

 

The database list is not populated so there is nothing to select...

 

BUT - clearing the cache solved the issue!

 

 

 

 

View solution in original post

2 REPLIES 2

avatar
Cloudera Employee

Hi Scott,

 

Are you able to select a database in the database list dropdown on the left?  If not, can you try clearing your browser cache and reloading the page to see if it populates the dropdown?

 

Jenny

avatar

Thanks for the reply Jenny (I've been going nuts with this)!

 

The database list is not populated so there is nothing to select...

 

BUT - clearing the cache solved the issue!