You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ning Zhang (JIRA)" <ji...@apache.org> on 2010/01/26 01:20:34 UTC
[jira] Created: (HIVE-1101) Extend Hive ODBC to support more
funcitons
Extend Hive ODBC to support more funcitons
------------------------------------------
Key: HIVE-1101
URL: https://issues.apache.org/jira/browse/HIVE-1101
Project: Hadoop Hive
Issue Type: New Feature
Reporter: Ning Zhang
Currently Hive ODBC driver only support a a minimum list of functions to ensure some application work. Some other applications require more function support. These functions include:
*SQLCancel
*SQLFetchScroll
*SQLGetData
*SQLGetInfo
*SQLMoreResults
*SQLRowCount
*SQLSetConnectAtt
*SQLSetStmtAttr
*SQLEndTran
*SQLPrepare
*SQLNumParams
*SQLDescribeParam
*SQLBindParameter
*SQLGetConnectAttr
*SQLSetEnvAttr
*SQLPrimaryKeys (not ODBC API? Hive does not support primary keys yet)
*SQLForeignKeys (not ODBC API? Hive does not support foreign keys yet)
We should support as many of them as possible.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1101) Extend Hive ODBC to support more
funcitons
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-1101:
---------------------------------
Attachment: unixODBC-2.2.14-p2-HIVE-1101.tar.gz
unixODBC-2.2.14-p2.tar.gz with HIVE-1101.patch pre-applied.
This supercedes the patched version of unixODBC attached to HIVE-187.
> Extend Hive ODBC to support more funcitons
> ------------------------------------------
>
> Key: HIVE-1101
> URL: https://issues.apache.org/jira/browse/HIVE-1101
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Ning Zhang
> Assignee: Ning Zhang
> Attachments: HIVE-1101.patch, unixODBC-2.2.14-p2-HIVE-1101.tar.gz
>
>
> Currently Hive ODBC driver only support a a minimum list of functions to ensure some application work. Some other applications require more function support. These functions include:
> *SQLCancel
> *SQLFetchScroll
> *SQLGetData
> *SQLGetInfo
> *SQLMoreResults
> *SQLRowCount
> *SQLSetConnectAtt
> *SQLSetStmtAttr
> *SQLEndTran
> *SQLPrepare
> *SQLNumParams
> *SQLDescribeParam
> *SQLBindParameter
> *SQLGetConnectAttr
> *SQLSetEnvAttr
> *SQLPrimaryKeys (not ODBC API? Hive does not support primary keys yet)
> *SQLForeignKeys (not ODBC API? Hive does not support foreign keys yet)
> We should support as many of them as possible.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1101) Extend Hive ODBC to support more
funcitons
Posted by "Ning Zhang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ning Zhang updated HIVE-1101:
-----------------------------
Attachment: HIVE-1101.patch
Uploading patch HIVE-1101.patch. Since unixODBC is not compatible to Apache license, you need to apply this patch to unixODBC 2.2.14 and build yourself. This patch is based on the patch in HIVE-187 and can be applied directly to unixODBC 2.2.14. The major change is to implement a simple SQLGetInfo to support MSTR v.9. Other changes are to the connection and disconnection code (SQLDriverConnect.c, SQLConnect.c, SQLFreeConnect.c etc.) to get the configuration info from odbc.ini.
Note:
1) unixODBC and MSTR both have DriverManager (libodbc.so, libodbcinst.so). You need to set LD_LIBRARY_PATH correspondingly when you run configuration and make this driver.
2) Since MSTR v9 support 32-bit driver only, you need to compile all dynamic libraries to 32-bit binaries. These include unixODBC, hiveclient, and thrift. Please refer to HIVE-187 and http://wiki.apache.org/hadoop/Hive/HiveODBC for more information.
> Extend Hive ODBC to support more funcitons
> ------------------------------------------
>
> Key: HIVE-1101
> URL: https://issues.apache.org/jira/browse/HIVE-1101
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Ning Zhang
> Assignee: Ning Zhang
> Attachments: HIVE-1101.patch
>
>
> Currently Hive ODBC driver only support a a minimum list of functions to ensure some application work. Some other applications require more function support. These functions include:
> *SQLCancel
> *SQLFetchScroll
> *SQLGetData
> *SQLGetInfo
> *SQLMoreResults
> *SQLRowCount
> *SQLSetConnectAtt
> *SQLSetStmtAttr
> *SQLEndTran
> *SQLPrepare
> *SQLNumParams
> *SQLDescribeParam
> *SQLBindParameter
> *SQLGetConnectAttr
> *SQLSetEnvAttr
> *SQLPrimaryKeys (not ODBC API? Hive does not support primary keys yet)
> *SQLForeignKeys (not ODBC API? Hive does not support foreign keys yet)
> We should support as many of them as possible.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (HIVE-1101) Extend Hive ODBC to support more
funcitons
Posted by "Ning Zhang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ning Zhang reassigned HIVE-1101:
--------------------------------
Assignee: Ning Zhang
> Extend Hive ODBC to support more funcitons
> ------------------------------------------
>
> Key: HIVE-1101
> URL: https://issues.apache.org/jira/browse/HIVE-1101
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Ning Zhang
> Assignee: Ning Zhang
>
> Currently Hive ODBC driver only support a a minimum list of functions to ensure some application work. Some other applications require more function support. These functions include:
> *SQLCancel
> *SQLFetchScroll
> *SQLGetData
> *SQLGetInfo
> *SQLMoreResults
> *SQLRowCount
> *SQLSetConnectAtt
> *SQLSetStmtAttr
> *SQLEndTran
> *SQLPrepare
> *SQLNumParams
> *SQLDescribeParam
> *SQLBindParameter
> *SQLGetConnectAttr
> *SQLSetEnvAttr
> *SQLPrimaryKeys (not ODBC API? Hive does not support primary keys yet)
> *SQLForeignKeys (not ODBC API? Hive does not support foreign keys yet)
> We should support as many of them as possible.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.