Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-187

ODBC driver

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.4.0
    • Clients, ODBC
    • None
    • Reviewed
    • HIVE-187. Preliminary ODBC Support. (Eric Hwang via rmurthy)
    • ODBC

    Description

      We need to provide the a small number of functions to get basic query
      execution and retrieval of results. This is based on the tutorial provided
      here: http://www.easysoft.com/developer/languages/c/odbc_tutorial.html

      The minimum set of ODBC functions required are:
      SQLAllocHandle - for environment, connection, statement
      SQLSetEnvAttr
      SQLDriverConnect
      SQLExecDirect
      SQLNumResultCols
      SQLFetch
      SQLGetData
      SQLDisconnect
      SQLFreeHandle

      If required the plan would be to do the following:
      1. generate c++ client stubs for thrift server
      2. implement the required functions in c++ by calling the c++ client
      3. make the c++ functions in (2) extern C and then use those in the odbc
      SQL* functions
      4. provide a .so (in linux) which can be used by the ODBC clients.

      Attachments

        1. thrift_64.r790732.tgz
          6.11 MB
          Ning Zhang
        2. unixODBC-2.2.14-hive-patched.tar.gz
          2.15 MB
          Carl Steinbach
        3. unixodbc.patch
          1.11 MB
          Raghotham Murthy
        4. hive-187.4.patch
          1001 kB
          Raghotham Murthy
        5. HIVE-187.3.patch
          1001 kB
          Eric Hwang
        6. unixODBC-2.2.14-3.tgz
          2.14 MB
          Eric Hwang
        7. unixODBC-2.2.14-2.tgz
          2.14 MB
          Eric Hwang
        8. HIVE-187.2.patch
          1010 kB
          Eric Hwang
        9. unixODBC-2.2.14-1.tgz
          2.14 MB
          Eric Hwang
        10. unixODBC-2.2.14.tgz
          2.14 MB
          Eric Hwang
        11. thrift_home_linux_64.tgz
          2.85 MB
          Eric Hwang
        12. thrift_home_linux_32.tgz
          2.69 MB
          Eric Hwang
        13. HIVE-187.1.patch
          966 kB
          Eric Hwang

        Issue Links

          depends upon

          Bug - A problem which impairs or prevents the functions of the product. HIVE-671 getSchema() does not work properly with select* queries on Hive Server

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. HIVE-731 Hive Server getSchema() returns null schema properties

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. HIVE-613 Hive server fetch row incorrect NULL representation

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. HIVE-727 Hive Server getSchema() returns wrong schema for "Explain" queries

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. HIVE-736 MetaStoreUtils get_fields() does not return partition column

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. HIVE-606 Hive server should be able to return result row count for the last query executed

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-728 Hive Server Exception Messages

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-729 select expression with optional "as"

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Test - A new unit, integration or system test. HIVE-80 Add testcases for concurrent query execution

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          relates to

          New Feature - A new feature of the product, which has yet to be developed. HIVE-975 Hive ODBC driver for Windows

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. HIVE-1101 Extend Hive ODBC to support more functions

          • Major - Major loss of function.
          • Reopened

          Activity

            People

              ehwang Eric Hwang
              rsm Raghotham Murthy
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: