Hive / HCatalog Forum

Issue with HIVE ODBC Drivers

  • #12599

    Hi,
    Did anyone also got a problem when trying to connect to a Hive platform with ODBC (Windows – HortonWorks Hive ODBC Driver 1.00.00.1009) ?

    Here is the msg I receive when I test my connection:
    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (22) Error from ThriftHiveClient: Invalid method name: ‘execute’

    TESTS COMPLETED WITH ERROR.

    Is there something we missed when installing our server ?

    In advance, thank you !

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #12601
    Akki Sharma
    Member

    Hi Pierre

    We are looking into this. We will get back to you soon.

    Best Regards,
    Akki

    #12608
    Akki Sharma
    Member

    Hi Pierre,

    Can you please provide more details of your cluster, setup and steps you performed to arrive at this error ?

    Thanks,
    Akki

    #12655
    Maxime Lanciaux
    Participant

    Hi Akki,

    We set up a single node installation of HDP1.1 on a CentOs 5.8 serveur 64 bit using the manual install.
    We change the hive configuration file to connect to the mysql metastore and with the hive user hive --service metastore

    #12657
    Maxime Lanciaux
    Participant

    Hi Akki,

    Since I wrote the post, I find the issue. We just have to replace in our script --service metastore by --service hiveserver.

    I will check on monday.

    Best regards.

    #12660
    Maxime Lanciaux
    Participant

    Hello Akki,

    Yes it’s working ! By the way, do you know a good free software for Hive on windows ?

    Best regards.

    #12775
    Sasha J
    Moderator

    Maxime,
    As of now, I am not aware of any free software which allows you to manage your Hive database from Windows.
    You may search for some commercial software or write your own wrappers…
    However, if you are interested in development tools, I will recommend you to consider Talend Open Studio. It is free Eclipse-based framework to visually build data-flow processes and generate executable Java code. It supports most of the Hadoop and ecosystem frameworks and has many components to process hadoop data.

    Thank you!

    Sasha

    #27922

    Hi – after downloading, installing and rebooting – the Hortonworks Hive ODBC Driver is not showing up in the list of odbc drivers.

    i am unable to complete the intsallation

    please advise

    thx
    R

    #28207
    Seth Lyubich
    Moderator

    Hi Rasheed,

    Can you please clarify if you are missing Hive driver in ODBC Data Source Administrator? Did you select System DSN tab?

    Thanks,
    Seth

    #28804
    David Marshall
    Participant

    I have the same symptoms that Rasheed posted on June 20, 2013. I’m running 32-bit excel. I downloaded and installed the 32-bit HortonworksHiveODBC32.msi on Windows 7 x64 and rebooted. When selecting System DSN and selecting the “Add…” button, the Hive ODBC driver is not listed.

    I do see the driver files listed in “C:\Program Files (x86)\Hortonworks Hive ODBC Driver\lib”

    I can run the “Hortonworks Hive ODBC Driver Configuration” program

    How can I complete the registration? Is there a way to manually register the dll to complete the registration?

    Thanks in advance,
    David

    #28805
    David Marshall
    Participant

    I find no Horton ODBC entries in the Windows Registry under

    HKEY_LOCAL_MACHINE

    SOFTWARE

    ODBC

    Odbcinst.ini

    David

    #28806
    David Marshall
    Participant

    I was able to find the hortonworkd 32-bit odbc driver by opening the 32-bit Odbc administrative tool located in “C:\Windows\SysWOW64\odbcad32.exe” and running “as administrator”.

    David

    #28809
    abdelrahman
    Moderator

    Hi David,

    Please check in control panel >> add and remove programes >> Hortonworks etc.. . It should be installed there. Hope this helps.

    Thanks
    -Abdelrahman

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.