Yes, in this case it's a configuration option that's specific to the Apache
Hive execution engine. But what about other options such as fs.defaultFS?
How do we set those in Impala when using JDBC/ODBC?
Thanks,
Kirk
On Tue, Apr 16, 2013 at 9:47 AM, Alex Behm wrote:
"set hive.auto.convert.join=true" is a Hive-specific command that enables
Hive to automatically choose Map-side joins.
The command has no meaning in Impala because it's execution engine is not
based on Map-Reduce.
I'm not sure how easy/hard it would be to simply omit such Hive-specific
commands.
Cheers,
Alex
"set hive.auto.convert.join=true" is a Hive-specific command that enables
Hive to automatically choose Map-side joins.
The command has no meaning in Impala because it's execution engine is not
based on Map-Reduce.
I'm not sure how easy/hard it would be to simply omit such Hive-specific
commands.
Cheers,
Alex
On Tue, Apr 16, 2013 at 9:09 AM, Kirk True wrote:
I'm running into the same basic issue but from JDBC.
CMIIW, but it looks like you can specify the configuration as parameters
in the connection string to JDBC. Perhaps you can try including the Hive
parameter as part of the connection string to your ODBC source?
I'm running into the same basic issue but from JDBC.
CMIIW, but it looks like you can specify the configuration as parameters
in the connection string to JDBC. Perhaps you can try including the Hive
parameter as part of the connection string to your ODBC source?
On Tue, Apr 16, 2013 at 5:42 AM, Santha Kumar wrote:
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
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<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 <http://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 whichHI,
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<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 <http://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,
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
