Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: Clients, ODBC
    • Labels:
      None
    • Hadoop Flags:
      Reviewed
    • Release Note:
      HIVE-187. Preliminary ODBC Support. (Eric Hwang via rmurthy)
    • Tags:
      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. unixODBC-2.2.14-hive-patched.tar.gz
          2.15 MB
          Carl Steinbach
        2. unixODBC-2.2.14-3.tgz
          2.14 MB
          Eric Hwang
        3. unixODBC-2.2.14-2.tgz
          2.14 MB
          Eric Hwang
        4. unixODBC-2.2.14-1.tgz
          2.14 MB
          Eric Hwang
        5. unixODBC-2.2.14.tgz
          2.14 MB
          Eric Hwang
        6. unixodbc.patch
          1.11 MB
          Raghotham Murthy
        7. thrift_home_linux_64.tgz
          2.85 MB
          Eric Hwang
        8. thrift_home_linux_32.tgz
          2.69 MB
          Eric Hwang
        9. thrift_64.r790732.tgz
          6.11 MB
          Ning Zhang
        10. hive-187.4.patch
          1001 kB
          Raghotham Murthy
        11. HIVE-187.3.patch
          1001 kB
          Eric Hwang
        12. HIVE-187.2.patch
          1010 kB
          Eric Hwang
        13. HIVE-187.1.patch
          966 kB
          Eric Hwang

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: