ODBC Connection to EC2

wrote:
Hi,

We are trying to test the ODBC connection from a local Microstrategy dev
server to our remote dev Impala cluster in EC2. We are using Cloudera
Connector 2.0 for Microstrategy along with CDH4.5.0, CM4.8.0, and
Impala1.2.1. Using the settings of the Microstrategy dev server, we opened
up the Impala dev cluster's Security Group for every port and updated
IPTables to accept all. But, we still can get communication established.
Telnet works on both 21000 and 21050. I installed the impala-shell client
on the Microstrategy dev server, connected to the dev Impala cluster, and
can run queries. Can someone help? Am I missing something?

[IMPALA-SERVER]
Driver=/usr/lib/libhiveodbc.so.1
Description=Hive ODBC Driver
HOST= dn1.lab.test.com
PORT=21050
Database=
FRAMED=0
Trace=Yes
TraceFile=/tmp/odbc.log
Type=HS2NoSasl

Thanks,
Ben

To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected] <javascript:>.

On Thursday, December 12, 2013 12:26:31 PM UTC-8, Jonathan Seidman wrote:

Ben – can you be more specific about the errors you're encountering, and
are these errors occurring when you try to connect from MSTR tools? Can you
try using something like UnixODBC to test the ODBC connection outside of
MSTR? There's always the possibility that you're hitting an error loading
the driver – missing dependency, etc.

Jonathan

To unsubscribe from this group and stop receiving emails from it, send

wrote:
Jonathan,

I forgot to add that the local dev MSTR box is able to connect to our
local Impala production cluster with Impala1.1.1 installed. The reason for
the testing is that we want to move to Impala1.2.1, and management wants to
verify that it works with our current MSTR setup.

Thanks,
Ben

an email to [email protected] <javascript:>.