Impala JDBC 5.1.4
- Last Updated: May 8, 2026
- 8 minute read
- OpenAccess SDK
- Documentation
README
Progress(R) DataDirect(R)
Progress(R) DataDirect Connect XE(R) for JDBC(TM) for Impala(TM) Driver
Release 5.1.4
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 Service Pack 4
Changes for Service Pack 4
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 Service Pack 4
Installer JRE Requirement
-------------------------
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
Installer Upgrade
-----------------
The installer program has been enhanced to use a more modern and
secure technology. As a result of this enhancement:
* The default installation location has been changed to:
- For Windows:
C:\Program Files\Progress\DataDirect\JDBC
- For UNIX/Linux:
/opt/Progress/DataDirect/JDBC
� The new installer program does not support upgrading installations
made with earlier versions of the installer. You will need to
uninstall the existing installation and reinstall with the new
installer to resume upgrades in the same directory.
* The references to the old installation location will not be
changed to the new installation location automatically. To
learn how to update them, refer to the best practices article
at https://community.progress.com/s/.
* License keys you have used for the retired 5.1 installer cannot
be used with the new installer. Request new keys by either
contacting the Progress DataDirect Technical Support team or visiting
https://www.progress.com/datadirect-connectors/request-upgrade.
Signed Installer Packages
-------------------------
Starting June 20, 2022, installer packages signed with a digital signature
will be available for download from OEM FTP. For instructions on verifying
installer package signatures, refer to
https://community.progress.com/s/article/Signed-packages-for-DataDirect-OEMs.
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-cloudera-impala
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/
Support for Kerberos Authentication
-----------------------------------
The driver has been enhanced to support Kerberos authentication.
Timestamp Logging in Spy and JDBC Packet Logs
---------------------------------------------
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
------------------------
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.
Java SE 7 Support
-----------------
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).
SSL Data Encryption
-------------------
The driver has been enhanced to support SSL data encryption.
Statement Pooling
-----------------
The driver no longer registers the Statement Pool Monitor as a JMX MBean by
default. To register the Statement Pool Monitor and manage statement pooling with
standard JMX API calls, the new RegisterStatementPoolMonitorMBean connection
property must be set to true.
Changes for Service Pack 4
Data Types
----------
The driver has been enhanced to support the Char and Vachar data type with
Cloudera Impala 2.1 and higher.
Result Set Holdability
----------------------
Support for result set holdability has been added to the driver.
Features
The driver supports standard SQL query language for read-write access to
Cloudera Impala data stores, versions 1.3 and higher. By using DataDirect's Wire
Protocol technology, the driver eliminates the need for client libraries,
improving response time and throughput.
* The driver supports all JDBC Core functions.
* The driver supports the core SQL-92 grammar.
* The driver supports the following data types:
- BIGINT maps to BIGINT
- BOOLEAN maps to BOOLEAN
- CHAR maps to CHAR
- DECIMAL maps to DECIMAL
- DOUBLE maps to DOUBLE
- FLOAT maps to REAL
- INT maps to INTEGER
- SMALLINT maps to SMALLINT
- STRING maps to VARCHAR (or LONGVARCHAR)
- TIMESTAMP maps to TIMESTAMP
- TINYINT maps to TINYINT
- VARCHAR maps to VARCHAR
* The driver package includes the following components:
- DataDirect Connection Pool Manager
- DataDirect Statement Pool Monitor
- DataDirect Test for JDBC
- DataDirect Spy for JDBC
Notes, Known Problems, and Restrictions
The following are notes, known problems, and restrictions with the driver.
Cloudera Impala Limitations
---------------------------
* Cloudera Impala is not designed for OLTP workloads and does not offer
row-level updates or deletes. Cloudera Impala is instead designed for batch
type jobs over large data sets with high latency.
* Cloudera Impala does not support transactions, and by default, the driver
reports that transactions are not supported. However, some applications will
not operate with a driver that reports transactions are not supported. The
TransactionMode connection property allows you to configure the driver to
report that it supports transactions. In this mode, the driver ignores
requests to enter manual commit mode, start a transaction, or commit a
transaction and return success. Requests to rollback a transaction return an
error regardless of the transaction mode specified.
* Cloudera Impala Functional Limitations
- No support for transactions
- No support for canceling a running query
- No support for row-level updates or deletes
- No support for stored procedures
- No support for auto-generated keys
* Cloudera Impala uses a subset of SQL and HiveQL, which provides much of the
functionality of SQL, and therefore has some differences and limitations.
- Column values and parameters are always nullable.
- No support for row-level updates or deletes
- Subqueries are supported, but they can only exist in the FROM and WHERE
clauses.
- No support for stored procedures
- No ROWID support
- No support for materialized views
- No support for synonyms
- Primary and foreign keys are not supported.
- Support for indexes is incomplete.
- A single quote within a string literal must be escaped using a \ instead
of using a single quote.
For more information, refer to the Impala SQL Language Reference:
http://www.cloudera.com/content/cloudera/en/documentation/cloudera-impala/
latest/topics/impala_langref.html
Executing JDBC Shell Scripts
----------------------------
For UNIX 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
Clob Data Type Support
----------------------
The driver allows PreparedStatement.setXXX methods and ResultSet.getXXX
methods on Clob data types, in addition to the functionality described in
the JDBC specification. The supported conversions typically are the same as
those for LONGVARCHAR, except where limited by database support.
Internet Explorer with the Google Toolbar
-----------------------------------------
Internet Explorer with the Google Toolbar installed sometimes displays the
following error when the browser is closed: "An error has occurred in the
script on this page." This is a known issue with the Google Toolbar and has
been reported to Google. When closing the driver's help system, this error may
display.
Documentation
PROGRESS DATADIRECT FOR JDBC FOR IMPALA DOCUMENTATION SET
---------------------------------------------------------
The driver documentation set is available from the Progress Information Hub:
https://docs.progress.com/category/datadirect-cloudera-impala
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_IMPALA_5.1.4_INSTALL.iam.zip
- PROGRESS_DATADIRECT_JDBC_COMMON_5.1.4_INSTALL.iam.zip
Non-Windows:
------------
* PROGRESS_DATADIRECT_JDBC_INSTALL.jar
* DriverModules
- PROGRESS_DATADIRECT_JDBC_IMPALA_5.1.4_INSTALL.iam.zip
- PROGRESS_DATADIRECT_JDBC_COMMON_5.1.4_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/51:
-----------------
impala.jar Impala Driver and DataSource classes
INSTALL_DIR/NOTICES/:
---------------------
JDBC for Impala v5.1.4 notices.txt
Third party agreement information
INSTALL_DIR/pool manager/:
--------------------------
pool.jar All DataDirect Connection Pool Manager classes
INSTALL_DIR/READMES/:
---------------------
JDBC for Impala v5.1.4 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
impala/*.* Support files for the uninstaller
resource/*.* Resource files for the Windows uninstaller
February 2026
================
End of README