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

On Tue, Apr 16, 2013 at 7:42 AM, Santha Kumar wrote:

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

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 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