Apache Hive JDBC 6.0.1
- Last Updated: May 8, 2026
- 9 minute read
- OpenAccess SDK
- Documentation
README
Progress(R) DataDirect(R)
Progress(R) DataDirect(R) for JDBC(TM) for Apache Hive(TM) Driver
Release 6.0.1
February 2026
***********************************************************************
Copyright (C) 2026 Progress Software Corporation and/or its
subsidiaries or affiliates. All Rights Reserved.
***********************************************************************
CONTENTS
Post-GA Product Announcements
Requirements
Installation Directory
Data Source and Platform Support
Changes since 6.0.1 GA
Changes for 6.0.1 GA
Release 6.0.0 Features
Notes, Known Problems, and Restrictions
Documentation
Installed Files
Post-GA Product Announcements
The readme files will no longer be updated with product announcements and new
features after the General Availability (GA) of the product. For the latest
updates and enhancements, please refer to the release notes
(https://www.progress.com/datadirect-connectors/whats-new).
Requirements
* A supported Java Virtual Machine (JVM) must be defined on your system path.
* The installer program requires a JVM that is Java SE 11 or higher, including
Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.
* The driver requires a JVM that is Java SE 8 or higher, including Oracle JDK,
OpenJDK, and IBM SDK (Java) distributions.
Installation Directory
The default installation directory for the driver is:
* Windows:
C:\Program Files\Progress\DataDirect\JDBC
* UNIX/Linux:
/opt/Progress/DataDirect/JDBC
Note: For UNIX/Linux, if you do not have access to "/opt", your user's home
directory will take the place of this directory.
Data Source and Platform Support
For the latest data source and platform support information, refer to the
Product Compatibility Guide:
https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
datadirect-product-compatibility.pdf
Changes since 6.0.1 GA
Documentation
-------------
Any product package made available after August 7, 2020 will not include the
HTML help system or user's guide PDF. The full documentation set, including
these items, is available from the Progress Information Hub:
https://docs.progress.com/category/datadirect-apache-hive
While the product packages will not include these documentation items, the
installation Help directory will provide an HTML redirect for direct access
to the HTML help.
Note that all Progress DataDirect for JDBC documentation has been migrated to
the Progress Information Hub:
https://docs.progress.com/
Enhancements
------------
* The driver has been enhanced to comply with FIPS standards for data
encryption. As part of this enhancement, the driver was tested with
FIPS 140-3 enabled using a Red Hat OpenJDK 21 on a Red Hat Universal Base
Image 9 instance.
* The driver has been enhanced to support authenticating with Hadoop delegation
tokens. You can configure authentication with Hadoop delegation tokens using
the new DelegationToken property and enhanced AuthenticationMethod property.
* The driver has been enhanced with the new SASLQOP connection property. When
Kerberos authentication is enabled, SASQOP allows you to specify the level of
quality of protection used by the server for SASL mechanisms.
* The driver has been enhanced to support using load balancing with Apache
Zookeeper. When connecting through a Zookeeper listener configured with two
or more Hive nodes, the driver now randomly connects to one of the Hive nodes
returned, instead of always connecting to the first Hive node returned in the
list. The remaining nodes are then used for failover when establishing the
connection.
* The driver has been enhanced to include timestamp in the Spy and JDBC packet
logs by default. If required, you can disable the timestamp logging by
specifying the following at connection: For Spy logs, set
spyAttributes=(log=(file)Spy.log;timestamp=no) and for JDBC packet logs,
set ddtdbg.ProtocolTraceShowTime=false.
* Interactive SQL for JDBC (JDBCISQL) is now installed with the product.
JDBCISQL is a command-line interface that supports connecting your driver
to a data source, executing SQL statements and retrieving results in a
terminal. This tool provides a method to quickly test your drivers in an
environment that does not support GUIs.
* The driver has been enhanced to support ACID operations for Inserts, Updates,
and Deletes on servers that are configured to use them.
* The driver has been enhanced to support Kerberos authentication for
Apache ZooKeeper.
* The driver has been enhanced to support Apache ZooKeeper, which can be
configured using the updated ServerName connection property and the new
ZooKeeperDiscovery and ZooKeeperNamespace connection properties.
Changed Behavior
----------------
* The connection property SpyAttributes has been updated to exclude the
attribute load=classname, which was previously used to load the driver
specified by the given class name. If a log file name does not include the
.log extension, the driver automatically appends it.
* The installer program now requires you to install a JRE that is Java SE 11 or
higher before running the installer. In earlier versions, the JRE used by the
installer program was included in the product. However, to avoid potential
security vulnerabilities, the installer program no longer includes a JRE.
Instead, the installer program uses the JRE in your environment to allow for
the most secure version of a JRE to be used.
Note: This change does not affect the JVM requirements for the driver. For the latest
driver requirements, refer to the Product Compatibility Guide:
https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
datadirect-product-compatibility.pdf
* Java SE 7 has reached the end of its product life cycle and will no longer
receive generally available security updates. As a result, the drivers will
no longer support JVMs that are version Java SE 7 or earlier. Support for
distributed versions of Java SE 7 and earlier will also end, including
IBM SDK (Java Edition).
Changes for 6.0.1 GA
Enhancements
------------
* The driver has been enhanced to support the following complex data types:
Array, Map, Struct, and Union.
* The driver has been enhanced to support the Statement.cancel API, which
allows you to cancel running queries.
* The new InitializationString connection property allows you to specify one
or multiple SQL commands to be executed by the driver at connection. This
provides a method for specifying session settings at connection, such as
runtime server-side variables or timezones.
* The driver has been enhanced to support the Binary data type, including
the following two new connection properties:
- MaxBinarySize allows you to specify the maximum length of fields of the
Binary data type that the driver describes through result set descriptions
and metadata methods.
- BinaryDescribeType allows you to specify whether Binary columns are
described as VARBINARY or LONGVARBINARY.
* The new MaxStringSize property allows you to specify the maximum length of
fields of the String data type that the driver describes through result set
descriptions and metadata methods.
Changed Behavior
----------------
* The ServicePrincipalName property has been updated to provide a default
value. If no value is specified, the driver builds the default using hive
for the service name and the value of the ServerName property as the fully
qualified domain name.
Refer to the user's guide for additional information about these changes.
Release 6.0.0 Features
Enhancements
------------
* The driver has been enhanced to optimize the performance of fetches.
* The driver has been enhanced to support the Char, Date, Decimal, and Varchar
data types.
* The driver has been enhanced to support HTTP mode, which allows you to access
Apache Hive data stores using HTTP/HTTPS requests. HTTP mode can be
configured using the new TransportMode and HTTPPath connection properties.
* The driver has been enhanced to support cookie based authentication for HTTP
connections. Cookie based authentication can be configured using the new
EnableCookieAuthentication and CookieName connection properties.
* The driver has been enhanced to support Apache Knox.
* The driver has been enhanced to support Impersonation and Trusted
Impersonation using the new ImpersonateUser property.
* The BatchMechanism connection property has been added to the driver. When
BatchMechanism is set to multiRowInsert, the driver executes a single
insert for all the rows contained in a parameter array. MultiRowInsert is
the default setting and provides substantial performance gains when
performing batch inserts.
* The new CatalogMode connection property allows you to determine whether the
driver uses native catalog functions to retrieve information returned by
DatabaseMetaData functions. In the default setting, the driver employs a
balance of native functions and driver-discovered information for the optimal
balance of performance and accuracy when retrieving catalog information.
* The new ArrayFetchSize connection property improves performance and reduces
out of memory errors. ArrayFetchSize can be used to increase throughput or,
alternately, improve response time in Web-based applications.
* The new ArrayInsertSize connection property provides a workaround for memory
and server issues that can sometimes occur when inserting a large number of
rows that contain large values.
* For Kerberos authentication environments, the following changes have been
implemented:
- The driver no longer sets the java.security.auth.login.config system
property to force the use of the installed JDBCDriverLogin.conf file as the
JAAS login configuration file. By default, the driver now uses the default
JAAS login configuration file for Java, unless you specify a different
location and file using the java.security.auth.login.config system
property.
- The driver no longer sets the java.security.krb5.conf system property to
force the use of the krb5.conf file installed with the driver jar files in
the /lib directory of the product installation directory.
Refer to "Configuring the Driver for Kerberos Authentication" in the user's
guide for details.
* The driver has been enhanced to support SSL, incorporating the addition of
nine new connection properties.
* The driver's Kerberos functionality has been enhanced to support SASL-QOP
data integrity and confidentiality.
Changed Behavior
----------------
* The driver supports the HiveServer2 protocol and higher, and as a result:
- Support for the HiveServer1 protocol has been deprecated
- The Wire Protocol Version connection option has been deprecated
Notes, Known Problems, and Restrictions
The following are notes, known problems, and restrictions with the 6.0.0
release of the driver. These restrictions are based on using
Apache Hive 1.0; other versions of Apache Hive will have their own
restrictions. You may find a more complete listing of Apache Hive known issues
and limitations for your version of Apache Hive in the Apache Hive user
documentation here: https://cwiki.apache.org/confluence/display/Hive/Home
General Restrictions for Apache Hive
------------------------------------
The following restrictions apply to Apache Hive environments:
* No support for row-level updates or deletes
* No difference exists between "NULL" and null values
* No support for auto-commit transactions
OLTP Workloads
--------------
Note that Apache Hive is not designed for OLTP workloads and does not offer
real-time queries or row-level updates. Apache Hive is instead designed for
batch type jobs over large data sets with high latency.
HiveQL
------
Apache Hive uses HiveQL, which provides much of the functionality of SQL,
but has some limitation syntax differences. For more information, refer to
the Hive Language Manual at
https://cwiki.apache.org/confluence/display/Hive/LanguageManual.
* A single quote within a string literal must be escaped using a \ instead
of using a single quote.
* Join support is limited to equi-joins.
System.exit() method and Process Termination
--------------------------------------------
The System.exit() method ensures that all registered shutdown hooks are run.
Applications terminate faster when System.exit(0) is used. When applications
omit the System.exit() call, the termination process may linger for about 10
seconds before exiting.
Executing DataDirect Shell Script
---------------------------------
For UNIX/Linux users: If you receive an error message when executing any
DataDirect for JDBC shell script, make sure that the file has EXECUTE
permission. To do this, use the chmod command. For example, to grant EXECUTE
permission to the testforjdbc.sh file, change to the directory containing
testforjdbc.sh and enter:
chmod +x testforjdbc.sh
JDBC Methods
------------
The following notes on JDBC methods apply generally to Progress DataDirect for
JDBC drivers.
* When attempting to create an updatable, scroll-sensitive result set for a
query that contains an expression as one of the columns, the driver cannot
satisfy the scroll-sensitive request. The driver downgrades the type of the
result returned to scroll-insensitive.
* The ResultSet methods getTimestamp(), getDate(), and getTime() return
references to mutable objects. If the object reference returned from any of
these methods is modified, re-fetching the column using the same method
returns the modified value. The value is only modified in memory; the
database value is not modified.
Documentation
PROGRESS DATADIRECT FOR JDBC FOR APACHE HIVE DOCUMENTATION SET
--------------------------------------------------------------
The driver documentation set is available from the Progress Information Hub:
https://docs.progress.com/category/datadirect-apache-hive
You can access the online help system directly via the HTML redirect in the
installation Help directory.
Installed Files
When you extract the contents of the installation download package to your
installer directory, you will notice the following files that are required to
install the driver:
* Windows:
- PROGRESS_DATADIRECT_JDBC_INSTALL.exe
- DriverModules
- PROGRESS_DATADIRECT_JDBC_HIVE_6.0.1_INSTALL.iam.zip
- PROGRESS_DATADIRECT_JDBC_COMMON_6.0.0_INSTALL.iam.zip
* Non-Windows:
- PROGRESS_DATADIRECT_JDBC_INSTALL.jar
- DriverModules
- PROGRESS_DATADIRECT_JDBC_HIVE_6.0.1_INSTALL.iam.zip
- PROGRESS_DATADIRECT_JDBC_COMMON_6.0.0_INSTALL.iam.zip
When you install the driver, the installer creates the following directories and
files in the product installation directory in the default installation
directory or in an installation directory you specify, represented by
INSTALL_DIR.
INSTALL_DIR/:
-------------
LicenseTool.jar Product license file manager
ddprocinfo.exe Windows executable to start the Processor Information
Utility
ddprocinfo UNIX/Linux script to start the Processor Information
Utility
fixes.txt Information on resolved issues for Progress
DataDirect for JDBC drivers
INSTALL_DIR/Examples/Bulk/:
---------------------------
Load From File/bulkLoadFileDemo.java
Java source example for bulk loading from a CSV file
Load From File/load.txt Sample data for the example
Streaming/bulkLoadStreamingDemo.java
Java source example for bulk loading from a result
set
Threaded Streaming/bulkLoadThreadedStreamingDemo.java
Java source example for multi-threaded bulk loading
from a result set
Threaded Streaming/README.txt
Instructions on how to use the thread.properties file
Threaded Streaming/thread.properties
Properties file for the example
INSTALL_DIR/Examples/JNDI/:
---------------------------
JNDI_FILESYSTEM_Example.java
Example Java(TM) source file
JNDI_LDAP_Example.java Example Java source file
INSTALL_DIR/help/:
------------------
*.html HTML redirects to driver help systems
INSTALL_DIR/install/:
---------------------
.psc_dd_inst_reg.xml Support file for the installation logs
logs/*.* Log file generated upon installing or uninstalling
INSTALL_DIR/jdbcisql/:
----------------------
jdbcisql.bat Batch file to start JDBC iSQL
jdbcisql.ini Configuration file for JDBC iSQL
jdbcisql.jar Java program to start JDBC iSQL
jdbcisql.sh Shell script to start JDBC iSQL
INSTALL_DIR/lib:
----------------
JDBCDriverLogin.conf The JAAS login configuration file installed with the
driver
INSTALL_DIR/lib/60:
-------------------
hive.jar Apache Hive Driver and DataSource classes
INSTALL_DIR/NOTICES/:
---------------------
JDBC for Apache Hive v6.0 notices.txt
Third party agreement information
INSTALL_DIR/pool manager/:
--------------------------
pool.jar All DataDirect Connection Pool Manager classes
INSTALL_DIR/READMES/:
---------------------
JDBC for Apache Hive v6.0 readme.txt
This file
INSTALL_DIR/testforjdbc/:
-------------------------
Config.txt Configuration file for DataDirect Test
ddlogging.properties Logging properties file
testforjdbc.bat Batch file to start DataDirect Test
testforjdbc.sh Shell script to start DataDirect Test
lib/testforjdbc.jar DataDirect Test classes
INSTALL_DIR/uninstall/:
-----------------------
.com.zerog.registry.xml Support file for the uninstaller
.psc_dd_uninst_reg.xml Support file for the uninstaller
InstallScript.iap_xml Support file for the uninstaller
installvariables.properties
Support file for the Windows uninstaller
Uninstall_JDBC.exe Windows uninstaller
Uninstall_JDBC.lax Support file for the Windows uninstaller
uninstaller.jar Java uninstaller
resource/*.* Resource files for the Windows uninstaller
hive/*.* Driver-specific support files for the uninstaller
February 2026
================
End of README