Hive / HCatalog Forum

ODBC connect to Hive

  • #19297
    Arnaud Gaillard


    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(
    at org.apache.thrift.server.TThreadPoolServer$
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
    at java.util.concurrent.ThreadPoolExecutor$
    Caused by: org.apache.thrift.transport.TTransportException
    at org.apache.thrift.transport.TTransport.readAll(
    at org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(
    at org.apache.thrift.transport.TSaslServerTransport.handleSaslStartMessage(
    at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(
    … 4 more

    The parameter from the ODBC are:

    Ip address
    hiveserver 2
    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?


to create new topics or reply. | New User Registration

  • Author
  • #19433
    Seth Lyubich

    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,


    Arnaud Gaillard

    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.

    Seth Lyubich

    Hi Arnaud,

    Thanks using HDP and letting us know.


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

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

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.