Impala Query Editor always shows AnalysisException

Question

I am running a Quickstart VM Cloudera on a Windows 7 computer, with 8Go of RAM and 4Go dedicated to the VM.

I loaded tables from a SQL database into Hive, using Sqoop (Cloudera VM tutorial exercise 1). Using the Hive Query Editor OR Impala Shell, everything works fine (i.e. "show tables" shows me the tables that were imported).

Using the Impala Query Editor, whatever I type, I get the same error message:

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

I have the same if I type "show tables;" ...

I checked that Impala-services were up and running and it was the case, and everything works fine in the Impala shell:

I googled around but could not find any answer, many thanks in advance for your answer !!

Solution 1

Need to use the Hive Query Editor. The error shows up if you use the Impala or other Query Editor because you're using a library written for Hive.

Query -> Editor -> Hive

Solution 2

Yes, try selecting a database and if one does not appear, try either clearing your browser cache and reloading the page and also verify that your user has permissions to view the default database. Although since you said that Hive query editor works fine, it sounds like permissions are not the issue.