FAQ
I am connecting HADOOP Impala using CLOUDERA connector from MicroStrategy.
It worked once before but the after I get the following message.

Error: SQL Generation Complete
QueryEngine encountered error: Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42000:0:
on HSTMT] com.cloudera.impala.common.AnalysisException: Syntax error at:
*set hive.auto.convert.join=true*
^
Encountered: IDENTIFIER
Expected: DESCRIBE, SELECT, SHOW, USE, INSERT
at
com.cloudera.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:135)
at
com.cloudera.impala.service.Frontend.createExecRequest(Frontend.java:221)
at
com.cloudera.impala.service.JniFrontend.createExecRequest(JniFrontend.java:91)
Caused by: java.lang.Exception: Syntax error
at com.cloudera.impala.analysis.SqlParser.unrecovere Connection String:
DSN=Cloudera Impala;DATABASE=;. SQL Statement: set
hive.auto.convert.join=true..
Error in Process method of Component: QueryEngineServer, Project Hadoop
POC, Job 2606, Error Code= -2147212544.

Is there anyway I can remove "*set hive.auto.convert.join=true" *condition
that is coming up before the query in microstartegy? Without this
statement, the query runs fine.

Can somebody please shed some light on this and how I can fix it?

Thanks,
Bhagath.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedApr 8, '13 at 5:53p
activeApr 8, '13 at 5:53p
posts1
users1
websitecloudera.com
irc#hadoop

1 user in discussion

Bhagath Yarlagadda: 1 post

People

Translate

site design / logo © 2022 Grokbase