Connecting to HIve in Sandbox from Linux

to create new topics or reply. | New User Registration

This topic contains 2 replies, has 2 voices, and was last updated by  Mikel Gomez 1 year, 9 months ago.

  • Creator
  • #38611

    Mikel Gomez


    I am trying to connect to hive on my hortonworks sandbox from Suse linux
    . Connectivity is available and i have unixODBC 2.3.1 installed in my SUSE Enterprise Box. 64 bits Suse ODBC driver for Hortonworks in also installed.

    When calling my Data Source using isql hive1 i get the following error:

    ~> isql -v hive1
    [01000][unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/hive/lib/native/Linux-amd64-64/’ : file not found
    [ISQL]ERROR: Could not SQLConnect

    But the file exists and 777 permissions are granted so full access should be allowed.

    If I do an ldd i get this information: => (0x00007fff785e3000) => /lib64/ (0x00007f070f16d000) => /lib64/ (0x00007f070ef50000) => not found => not found => /usr/lib64/ (0x00007f070ed34000) => /usr/lib64/ (0x00007f070ea29000) => /lib64/ (0x00007f070e7b0000) => /lib64/ (0x00007f070e59a000) => /lib64/ (0x00007f070e222000)
    /lib64/ (0x00007f0711227000) => /lib64/ (0x00007f070e00b000)

    so 2 libraries missing, what am i doing wrong? do i have to install other packages after the driver? I installed hive-odbc-native-

    if would be great if someone can help me to solve this.

    thanks in advance,

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

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

  • Author
  • #39022

    Mikel Gomez

    HI Dave, thanks for the answer.

    No, the file after extracting the driver exists with other files within the directory and has that name. Thus, under /usr/lib/hive/lib/native/Linux-amd64-64 i can see several files:

    drwx—r-x 3 toor root 4096 Oct 1 09:31 .
    drwx—r-x 4 toor root 4096 Sep 24 11:17 ..
    -rwxr-xr-x 1 toor root 544 Feb 22 2013 SimbaHiveODBC.did
    lrwxrwxrwx 1 toor root 18 Sep 24 11:17 ->
    -rwxr-xr-x 1 toor root 1943353 Feb 22 2013
    -rwxr-xr-x 1 toor root 43755670 Feb 22 2013
    lrwxrwxrwx 1 toor root 15 Sep 24 11:17 ->
    -rwxr-xr-x 1 toor root 400543 Feb 22 2013

    and i can see the two libraries not found within the same directory: => not found => not found

    the problem now is how to make the driver used the libraries. If I put these libraries in /usr/lib64, then no ssh, sftp will work and then i will have no access to the machine (this happened to me yesterday), so how can i proceed?




    Hi Mikel,

    Should this:






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