interesting that you still needed to change this with 9.3. I'll follow up
with MSTR to see if this is expected behavior.
On Fri, Apr 19, 2013 at 10:40 AM, Santha Kumar wrote:
Hi Jonathan,
That was awesome. It really solved my issue which i mentioned above.
I am able to connect to Impala through microstrategy. Thank you so
much...:)
Regards,
Santhakumar
Hi Jonathan,
That was awesome. It really solved my issue which i mentioned above.
I am able to connect to Impala through microstrategy. Thank you so
much...:)
Regards,
Santhakumar
On Thu, Apr 18, 2013 at 9:39 PM, Jonathan Seidman wrote:
Yes, as far as I know you should not be seeing this with 9.3. Here's some
follow up from a MSTR resource – see if the following helps, and if not
we'll need to follow up:
If they RMC on the MicroStrategy Database Instance…VLDB Properties…Report
Pre/Post SQL…Pre SQL Statement 5, they should see this statement in there.
They can just blank that out, save and close, restart I-server and give
this a try.
Thanks.
Jonathan
Yes, as far as I know you should not be seeing this with 9.3. Here's some
follow up from a MSTR resource – see if the following helps, and if not
we'll need to follow up:
If they RMC on the MicroStrategy Database Instance…VLDB Properties…Report
Pre/Post SQL…Pre SQL Statement 5, they should see this statement in there.
They can just blank that out, save and close, restart I-server and give
this a try.
Thanks.
Jonathan
On Thu, Apr 18, 2013 at 10:35 AM, Santha Kumar wrote:
Hi Jonathan,
We are using MSTR version 9.3. So i think there won't be much issue. Can
you please clarify on " the setting ‘Report Pre statement 1’ under
pre/post statements in the MSTR VLDB settings". It would be very much
helpful if you can elaborate a little.
Regards,
San
On Wed, Apr 17, 2013 at 3:11 AM, Jonathan Seidman <[email protected]
Hi Jonathan,
We are using MSTR version 9.3. So i think there won't be much issue. Can
you please clarify on " the setting ‘Report Pre statement 1’ under
pre/post statements in the MSTR VLDB settings". It would be very much
helpful if you can elaborate a little.
Regards,
San
On Wed, Apr 17, 2013 at 3:11 AM, Jonathan Seidman <[email protected]
wrote:
Santha,
You should be able to fix this by changing the setting ‘Report Pre
statement 1’ under pre/post statements in the MSTR VLDB settings. Note that
this shouldn't be an issue with more recent versions of MSTR, but if you're
using an earlier version than you'll need to modify this setting.
Thanks.
Jonathan
Santha,
You should be able to fix this by changing the setting ‘Report Pre
statement 1’ under pre/post statements in the MSTR VLDB settings. Note that
this shouldn't be an issue with more recent versions of MSTR, but if you're
using an earlier version than you'll need to modify this setting.
Thanks.
Jonathan
On Tue, Apr 16, 2013 at 7:42 AM, Santha Kumar wrote:
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
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 MicrostrategyHI,
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,
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
