FAQ
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 impala-user+unsubscribe@cloudera.org.

Search Discussions

  • Jonathan Seidman at Dec 12, 2013 at 8:26 pm
    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

    On Thu, Dec 12, 2013 at 12:14 PM, Benjamin Kim 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 impala-user+unsubscribe@cloudera.org.
    To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
  • Benjamin Kim at Dec 12, 2013 at 8:31 pm
    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
    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


    On Thu, Dec 12, 2013 at 12:14 PM, Benjamin Kim <bbui...@gmail.com<javascript:>
    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 impala-user...@cloudera.org <javascript:>.
    To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
  • Jonathan Seidman at Dec 12, 2013 at 9:21 pm
    Ah, so just to clarify, you're able to connect MSTR to your production
    Impala 1.1.1 install, but when you try connecting to the dev install of
    Impala 1.2.1 from the same host it fails? And to further clarify, it sounds
    like you've verified that you can connect to the Impala 1.2.1 install
    through Impala shell from the MSTR host and run queries, etc., correct?


    On Thu, Dec 12, 2013 at 12:31 PM, Benjamin Kim 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

    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

    On Thu, Dec 12, 2013 at 12:14 PM, Benjamin Kim 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 impala-user...@cloudera.org.
    To unsubscribe from this group and stop receiving emails from it, send
    an email to impala-user+unsubscribe@cloudera.org.
    To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
  • Benjamin Kim at Dec 12, 2013 at 9:43 pm
    Jonathan,

    Yes, that is correct on both counts. We are involving the Ops folks to see
    if there are some firewalls blocking it. It might turn out to be that this
    is the problem.

    Thanks,
    Ben
    On Thursday, December 12, 2013 1:21:15 PM UTC-8, Jonathan Seidman wrote:

    Ah, so just to clarify, you're able to connect MSTR to your production
    Impala 1.1.1 install, but when you try connecting to the dev install of
    Impala 1.2.1 from the same host it fails? And to further clarify, it sounds
    like you've verified that you can connect to the Impala 1.2.1 install
    through Impala shell from the MSTR host and run queries, etc., correct?



    On Thu, Dec 12, 2013 at 12:31 PM, Benjamin Kim <bbui...@gmail.com<javascript:>
    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

    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

    On Thu, Dec 12, 2013 at 12:14 PM, Benjamin Kim 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 impala-user...@cloudera.org.
    To unsubscribe from this group and stop receiving emails from it, send
    an email to impala-user...@cloudera.org <javascript:>.
    To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedDec 12, '13 at 8:14p
activeDec 12, '13 at 9:43p
posts5
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Benjamin Kim: 3 posts Jonathan Seidman: 2 posts

People

Translate

site design / logo © 2022 Grokbase