Product Announcements
Find the latest product announcements and version updates
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

[ANNOUNCE] New Hive ODBC and Impala ODBC Drivers Released

Highlighted

[ANNOUNCE] New Hive ODBC and Impala ODBC Drivers Released

Expert Contributor

We are pleased to announce the release of Hive ODBC v2.5.19 and Impala ODBC v2.5.33 drivers. This release has the following fixes and enhancements:

 

Hive ODBC v2.5.19
Enhancements and New Features
-Support added for Red Hat Enterprise Linux (RHEL) 7 and CentOS 7
-Updated authentication support. For consistency with Microsoft Azure HDInsight updates, the Windows Azure -HDInsight Emulator Authentication mechanism (AuthMech=5) is now deprecated. The driver no longer supports connections to Hive server instances that run on Windows Azure HDInsight Emulator.

 

Resolved Issues
-When attempting to connect to the server using a non-Windows version of the driver with Service Discovery Mode enabled, the client stops working.
-When executing a parameterized INSERT statement on a DATE, DECIMAL, or TIMESTAMP column, an error occurs.
-When executing a query that contains a large number of filters using OR operators, an error occurs.
-When executing a query that uses regular expressions in the fields, an error occurs. Before, this problem occurred when querying Hive servers that are configured to not allow quoted identifiers (the hive.support.quoted.identifiers parameter is set to none), because these servers cannot parse the backquotes (`) used for regular expressions.
Driver truncates passwords that exceed the maximum character length of the Password Field in the Cloudera Hive ODBC Driver DSN Setup dialog box.
-The maximum character length of the Password field has been increased to 5000 characters.
-In some cases, the driver stops working intermittently. Before, this problem occurred due to improper timing and sequence of operations between the execution context and the fetch thread.
-In some cases, after being used in Tableau, the driver caches sessions and then tries to reuse them the next time Tableau is started.
-When executing a parameterized INSERT statement on a BINARY column, an error occurs.

Impala ODBC v2.5.33
Enhancements and New Features
-Support added for Red Hat Enterprise Linux (RHEL) 7 and CentOS 7
-Improved implementation of SQLCancel
-Optimized metadata retrieval. The driver now retrieves schemas and table names using the SHOW TABLES query instead of the GetTables Thrift API call.

Resolved Issues
-The Use Only SSPI configuration option (the User Only SSPI property) does not work correctly.
[12888] Driver does not push down restrictions for catalog functions (SQLTables SQLColumns), in some cases causing a large number of GET_TABLES requests to occur.
When connecting to Impala 1.1 and executing a query that contains a NULL literal in the SELECT list, the driver terminates unexpectedly.

Getting Started with the Cloudera Drivers
-Download the Cloudera ODBC 2.5.19 Driver for Hive, and read the Release Notes and Installation Guide.
-Download the Cloudera ODBC 2.5.33 Driver for Impala, and read the Release Notes and Installation Guide.

As always, we welcome your feedback. Please send your comments and suggestions to the user group or through our community forums. You can also file bugs through our external JIRA projects on issues.cloudera.org.