ODBC connect to Hive

to create new topics or reply. | New User Registration

Tagged: 

This topic contains 3 replies, has 2 voices, and was last updated by  Seth Lyubich 2 years ago.

  • Creator
    Topic
  • #19297

    Arnaud Gaillard
    Participant

    Hello,

    I have installed the latest ODBC driver from this site in 64bits. However I cannot get my windows machine to connect to the hiveserver. I always get a timeout, and this message in the log of the hiverserver:

    13/03/28 16:26:37 ERROR server.TThreadPoolServer: Error occurred during processing of message.
    java.lang.RuntimeException: org.apache.thrift.transport.TTransportException
    at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:219)
    at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:189)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:722)
    Caused by: org.apache.thrift.transport.TTransportException
    at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132)
    at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
    at org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:182)
    at org.apache.thrift.transport.TSaslServerTransport.handleSaslStartMessage(TSaslServerTransport.java:125)
    at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:253)
    at org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.java:41)
    at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216)
    … 4 more

    The parameter from the ODBC are:

    Ip address
    10000
    hiveserver 2
    default
    No authentication.

    I don’t understand the exception raised, it seems to be related to sasl, but this option is set to false in the hive-site.xml.

    Any idea on what I’m doing wrong?

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)

You must be to reply to this topic. | Create Account

  • Author
    Replies
  • #19438

    Seth Lyubich
    Keymaster

    Hi Arnaud,

    Thanks using HDP and letting us know.

    Seth

    Collapse
    #19436

    Arnaud Gaillard
    Participant

    Thanks a lot! Your message triggered the basic check I forgot to carry.

    I’m running Hortonworks 1.2.1 on Centos 6.3 and SELinux was causing the problem.

    I always forget about checking SELinux status Centos.

    Collapse
    #19433

    Seth Lyubich
    Keymaster

    Hi Arnaud,

    Can you please let us know which HDP version you are using? If you using HDP 1.1 you need to make sure that you configure driver for Hive server 1. Also, Can you please make sure that Hive is working correctly directly in the cluster? Looks like there might be an issue with Thrift server. Is your port 9083 is open? Can you run hive commands without ODBC connection and see if Hive works correctly?

    Additionally you need to make sure that Hive server is runnng on port 10000 and port 10000 is not being blocked by firewall, etc.

    Hope this helps,

    Thanks,
    Seth

    Collapse
Viewing 3 replies - 1 through 3 (of 3 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.