Impala Query Editor always shows AnalysisException

hadoop hive hue impala
citraL picture citraL · Jan 26, 2016 · Viewed 8.4k times · Source

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...

enter image description here

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:

enter image description here

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

Answer

Ebin Joy picture Ebin Joy · Mar 25, 2018

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

Related questions

Impala can't access all hive table

I try to query hbase data through hive (I'm using cloudera). I did a fiew hive external table pointing to hbase but the thing is Cloudera's Impala doesn't have an access to all those tables. All hive external tables appear …

Read More
Unable to instantiate HiveMetaStoreClient

I have a 3 nodes cluster running hive. When i try to run some test from outside the cluster i am getting following given below error FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.…

Read More
No partition predicate found for Alias even when the partition predicate in present in the query

I have a table pos.pos_inv in hdfs which is partitioned by yyyymm. Below is the query: select DATE_ADD(to_date(from_unixtime(unix_timestamp(Inv.actvydt, 'MM/dd/yyyy'))),5), to_date(from_unixtime(unix_timestamp(Inv.actvydt, …

Read More