The Hortonworks Community Connection is now live. A completely rebuilt Q&A forum, Knowledge Base, Code Hub and more, backed by the experts in the industry.

You will be redirected here in 10 seconds. If your are not redirected, click here to visit the new site.

The legacy Hortonworks Forum is now closed. You can view a read-only version of the former site by clicking here. The site will be taken offline on January 31,2016

Hive / HCatalog Forum

Serengeti 0.7.0 with HDP 1.1 – hive- issue

  • #11751


    I’m having an issue with using HDP 1.1 with Serengeti 0.7.0.
    I created a custom distro entry on Serengeti and it startups and configures a cluster just fine, but it doesn’t allow me to connect with the hive server running on the client instance using an 64 bit ODBC driver.
    Trying to determine what might be wrong – I’m new to Hadoop so please bear with me.

    I also posted up on Serengeti’s Google Community forum where the conf files are.!topic/serengeti-user/RAPW9wowQHs

    Thank you,


    hive-thrift is running
    /var/log/hive/ shows the following
    Starting Hive Thrift Server
    WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the files.

    error on Hortonworks 64 bit ODBC Client on Windows 7 64 bit shows –
    Driver Version: V1.0.0.1009

    Running connectivity tests…

    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (22) Error from ThriftHiveClient: Unknown: errno = 10053


  • Author
  • #11753


    Are you trying to install HDP1.1 on Windows?



    no – using serengeti from VMware – its a Vapp that allows you to deploy a Hadoop cluster – they have an option to deploy an alternative distro like Hortonworks.

    The guest vms is running centos 5 – I believe – 2.6.18-238.19.1.el5
    It deploys 3 worker node – 1 master node – 1 client node (hive server)

    from a windows 7 pc I’m trying to connect to the hive server on the client node.



    Ok, then, with that in mind I need to understand what you are trying to connect to hive with/via on the windows side. I.e., are you trying to connect to hive through Excel. Access or ? If you are just trying to bring up a hive command line on the windows box, so that you can send a hive command or two, then the best way would be to ssh (using putty or similar) to the node with the hive server on it and call up hive in that shell.



    Well I’m getting this error when setting up the ODBC connection in the ODBC manager on the Windows Client.
    I’m using the test button to check the connection.
    I’m using the ip address of the hive server and port 10000.
    I would like to determine if there is something blocking the port on the VM.
    I’ve connected to another cluster running a different distro using the MapR odbc connection, but would prefer using Hortonworks if possible due to your partnership with Microsoft.



    I noticed a couple of things here: 1, the error you are getting indicates the connection was aborted due to a timeout. Which could be due to the second thing I’ve noticed wich is that in HDP the hive thrift server usually listens on port 9083. You can verify the port number on which it is listening by ssh’ing into the box that is running the hive thrift server and running the command ‘netstat -anp | grep ‘LISTEN ‘ . Then look for either 10000 or 9083 in the output.


The forum ‘Hive / HCatalog’ is closed to new topics and replies.

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.