Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major 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.

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

        Issue Links

          Activity

          Raghotham Murthy created issue -
          Johan Oskarsson made changes -
          Field Original Value New Value
          Fix Version/s 0.4.0 [ 12313714 ]
          Fix Version/s 0.2.0 [ 12313565 ]
          Ashish Thusoo made changes -
          Assignee Ashish Thusoo [ athusoo ]
          Ashish Thusoo made changes -
          Assignee Ashish Thusoo [ athusoo ] Eric Hwang [ ehwang ]
          Eric Hwang made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Eric Hwang made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Eric Hwang made changes -
          Attachment HIVE-187.1.patch [ 12415232 ]
          Eric Hwang made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Tags ODBC
          Eric Hwang made changes -
          Attachment thrift_home_linux_32.tgz [ 12415234 ]
          Attachment thrift_home_linux_64.tgz [ 12415235 ]
          Attachment unixODBC-2.2.14.tgz [ 12415236 ]
          Eric Hwang made changes -
          Attachment unixODBC-2.2.14.tgz [ 12415236 ]
          Eric Hwang made changes -
          Attachment unixODBC-2.2.14.tgz [ 12415431 ]
          Eric Hwang made changes -
          Attachment unixODBC-2.2.14.tgz [ 12415668 ]
          Eric Hwang made changes -
          Attachment unixODBC-2.2.14.tgz [ 12415431 ]
          Eric Hwang made changes -
          Link This issue depends upon HIVE-727 [ HIVE-727 ]
          Eric Hwang made changes -
          Link This issue depends on HIVE-671 [ HIVE-671 ]
          Eric Hwang made changes -
          Link This issue depends on HIVE-671 [ HIVE-671 ]
          Eric Hwang made changes -
          Link This issue depends upon HIVE-671 [ HIVE-671 ]
          Eric Hwang made changes -
          Link This issue depends upon HIVE-613 [ HIVE-613 ]
          Eric Hwang made changes -
          Link This issue depends upon HIVE-606 [ HIVE-606 ]
          Eric Hwang made changes -
          Link This issue blocks HIVE-728 [ HIVE-728 ]
          Eric Hwang made changes -
          Link This issue blocks HIVE-728 [ HIVE-728 ]
          Eric Hwang made changes -
          Link This issue depends upon HIVE-728 [ HIVE-728 ]
          Eric Hwang made changes -
          Link This issue depends upon HIVE-729 [ HIVE-729 ]
          Eric Hwang made changes -
          Link This issue depends upon HIVE-80 [ HIVE-80 ]
          Eric Hwang made changes -
          Link This issue depends upon HIVE-731 [ HIVE-731 ]
          Eric Hwang made changes -
          Link This issue depends upon HIVE-736 [ HIVE-736 ]
          Eric Hwang made changes -
          Attachment unixODBC-2.2.14-1.tgz [ 12416368 ]
          Eric Hwang made changes -
          Attachment HIVE-187.2.patch [ 12416369 ]
          Eric Hwang made changes -
          Attachment unixODBC-2.2.14-2.tgz [ 12416533 ]
          Eric Hwang made changes -
          Attachment unixODBC-2.2.14-3.tgz [ 12416690 ]
          Eric Hwang made changes -
          Attachment HIVE-187.3.patch [ 12416691 ]
          Raghotham Murthy made changes -
          Attachment hive-187.4.patch [ 12417256 ]
          Raghotham Murthy made changes -
          Attachment unixodbc.patch [ 12417258 ]
          Raghotham Murthy made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Hadoop Flags [Reviewed]
          Release Note HIVE-187. Preliminary ODBC Support. (Eric Hwang via rmurthy)
          Resolution Fixed [ 1 ]
          Carl Steinbach made changes -
          Attachment unixODBC-2.2.14-hive-patched.tar.gz [ 12429224 ]
          Zheng Shao made changes -
          Affects Version/s 0.6.0 [ 12314524 ]
          Affects Version/s 0.2.0 [ 12313565 ]
          Jeff Hammerbacher made changes -
          Link This issue relates to HIVE-1101 [ HIVE-1101 ]
          Ning Zhang made changes -
          Attachment thrift_64.r790732.tgz [ 12447927 ]
          Carl Steinbach made changes -
          Component/s Drivers [ 12313584 ]
          Carl Steinbach made changes -
          Affects Version/s 0.6.0 [ 12314524 ]
          Carl Steinbach made changes -
          Component/s ODBC [ 12314179 ]
          Component/s Drivers [ 12313584 ]
          Carl Steinbach made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Jeff Hammerbacher made changes -
          Link This issue relates to HIVE-975 [ HIVE-975 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development