Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by EricHwang: http://wiki.apache.org/hadoop/Hive/HiveODBC ------------------------------------------------------------------------------ {{{ $ ant compile-cpp -Dthrift.home=<THRIFT_HOME> -Dword.size=<32 or 64> }}} - You can verify the entire Hive compilation by running the Hive test suite from HIVE_HOME. Specifying the argument '-Dthrift.home=<THRIFT_HOME>' will enable the tests for the Hive client. + You can verify the entire Hive compilation by running the Hive test suite from HIVE_HOME. Specifying the argument '-Dthrift.home=<THRIFT_HOME>' will enable the tests for the Hive client. If you do NOT specify thrift.home, the Hive client tests will not be run and will just return successful. {{{ $ ant test -Dthrift.home=<THRIFT_HOME> }}} - You can specifically execute the Hive client tests by running the following command from {{{HIVE_HOME/odbc/}}}. NOTE: Hive client tests require that a local Hive Server be operating on port 10000. + You can specifically execute the Hive client tests by running the above command from {{{HIVE_HOME/odbc/}}}. NOTE: Hive client tests require that a local Hive Server be operating on port 10000. - {{{ - $ ant test - }}} 1.#3 To install the Hive client libraries onto your machine, run the following command from {{{HIVE_HOME/odbc/}}}. NOTE: The install path defaults to {{{/usr/local}}}, but this can be changed by setting the {{{INSTALL_PATH}}} environment variable to a desired alternative. {{{ $ sudo ant install -Dthrift.home=<THRIFT_HOME> @@ -120, +117 @@ If your system does not have isql, you can obtain it by installing the entirety of unixODBC. If you encounter an error saying that the shared libraries cannot be opened by isql, use the {{{ldd}}} tool to ensure that all dynamic library dependencies are resolved and use the {{{file}}} tool to ensure that isql and all necessary libraries are compiled into the same architecture (32 or 64 bit). === Current Status === - * Comments: - Please keep in mind that this is still an initial version and is still very rough around the edges. However, it provides basic ODBC 3.51 API support for connecting, executing queries, fetching, etc. This driver has been successfully tested on 32-bit and 64-bit linux machines with iSQL. It has also been tested with partial success on enterprise applications such as MicroStrategy. Due to licensing reasons, the unixODBC API wrapper files will be uploaded as a separate JIRA attachment that will not be part of this code repository. + * Comments: Please keep in mind that this is still an initial version and is still very rough around the edges. However, it provides basic ODBC 3.51 API support for connecting, executing queries, fetching, etc. This driver has been successfully tested on 32-bit and 64-bit linux machines with iSQL. It has also been tested with partial success on enterprise applications such as MicroStrategy. Due to licensing reasons, the unixODBC API wrapper files will be uploaded as a separate JIRA attachment that will not be part of this code repository. * Limitations: * Only support for Linux operating systems * No support for Unicode * No support for asynchronous execution of queries * Does not support pattern matching for functions such as SQLColumns and SQLTables; requires exact matches. * Hive Server is currently not thread safe (see JIRA HIVE-80: https://issues.apache.org/jira/browse/HIVE-80). This will prevent the driver from safely making multiple connections to the same Hive Server. We need to resolve this issue to allow the driver to operate properly. + * Hive Server's getSchema() function seems to have trouble with certain types of queries (such as "SELECT * ..." or "EXPLAIN"), and so the Hive ODBC driver sometimes has difficulties with these queries as well. * ODBC API Function Support (does anyone know how to remove the linking from the function names?): ||{{{ SQLAllocConnect }}} || supported || ||{{{ SQLAllocEnv }}} || supported ||
