Hive ODBC Connect Error

to create new topics or reply. | New User Registration


This topic contains 1 reply, has 2 voices, and was last updated by  Dave 1 year, 9 months ago.

  • Creator
  • #41517

    Bruce Roff

    Hi – as a novice user of Hadoop, I have been working my way through the tutorials (which have been a great intro for me). However, I’ve reached a problem on Tutorial 11, where I get the error “[Hortinworks][Hardy] (34) Error from Hive: connect() failed: Operation timed out.”

    I am on an OSX machine, and have followed the instructions to load and configure the Hortonworks ODBC drive. I get the error when I then try to run the test via Excel ( I get the same error when I use the iODBC Data Source Administrator).

    Any suggestions would be much appreciated.

Viewing 1 replies (of 1 total)

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

  • Author
  • #41698


    Hi Bruce,

    Are you using the correct driver – 64 bit?
    The ‘Operation timed out” suggests that you cannot connect to Hive on the port specified. Can you telnet to this port?
    What does your ODBC connection setup look like?



Viewing 1 replies (of 1 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.