FAQ

On Monday, December 3, 2012 3:28:54 PM UTC+5:30, Suresh K wrote:
HI,

I have one cluster with 2 nodes running on Amazon EC2 with impala
configured and working.

On my windows PC, i installed MSTR ODBC driver and configured as outlined
here,


https://ccp.cloudera.com/display/IMPALA10BETADOC/Configuring+Impala+to+Work+with+ODBC

but when i try to connect from php script, i get following error,

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Thrift: Mon Dec 03 15:19:03 2012 TSocket::open() connect() <Host:
ec2-*.*.*.*.compute-1.amazonaws.com Port: 21000>errno = 0
DBOpenConnection: connect() failed: errno = 0

Warning: odbc_connect(): SQL error: Communication link failure, SQL state
08S01 in SQLConnect in TestImpala.php on line 4

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

What am i missing?

Thanks in Advance.
Regards,
Suresh

Hi Jonathan,
I am getting the below error when running the report Microstrategy which is
connected to IMPALA Server. I am able to connect to warehouse catalog and
also able to import the required table and create facts and attribute. But
when i run the report i am getting the below error, can u please help me
out to resolve this issue...


""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=DSN_POC_IMP;DATABASE=aham;HOST=10.155.100.140;PORT=21000;FRAMED=;. SQL
Statement: set hive.auto.convert.join=true.""



Regards,

Santhakumar

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 19 | next ›
Discussion Overview
groupimpala-user @
categorieshadoop
postedApr 16, '13 at 12:42p
activeJun 28, '13 at 6:35p
posts19
users6
websitecloudera.com
irc#hadoop

People

Translate

site design / logo © 2022 Grokbase