Powered by Zoomin Software. For more details please contactZoomin

DataDirect JDBC ReadMe

Apache Impala JDBC 6.0.0

  • Last Updated: May 8, 2026
  • 6 minute read
    • OpenAccess SDK
    • Documentation

     README
     Progress(R) DataDirect(R)
     Progress(R) DataDirect(R) for JDBC(TM) for Apache Impala(TM) Driver
     Release 6.0.0
     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.0 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.0 GA

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.


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

    

    Release 6.0.0 Features

Driver Enhancements
-------------------
* The driver supports SQL read-write access to Apache Impala data stores.

* The driver supports JDBC core functions.

* The driver supports the Array data type through data type inference.

* The driver supports user impersonation with Kerberos authentication using the 
  new ImpersonateUser connection property.

* The driver supports LDAP authentication with user ID and password properties.

* The driver supports Kerberos authentication.

* The driver supports "No authentication," which allows you to connect without 
  any authentication credentials.
  
* The driver supports proxy server connections.

* The driver supports TLS/SSL data encryption.

* Includes Interactive SQL for JDBC (JDBCISQL). It 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.


    Notes, Known Problems, and Restrictions

The following are notes, known problems, and restrictions with release 6.0.0 of
the driver.

* Apache Impala is not designed for OLTP workloads and does not offer
  row-level updates or deletes. Apache Impala is instead designed for batch
  type jobs over large data sets with high latency.

* Apache 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.

* Apache 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

* Apache 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 Apache Impala SQL Language Reference:
  https://impala.apache.org/docs/build/html/topics/impala_langref.html

Executing DataDirect Shell Script
---------------------------------
For 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.

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.


     Documentation

PROGRESS DATADIRECT FOR JDBC FOR APACHE IMPALA DOCUMENTATION SET
-----------------------------------------------------------
The driver documentation set is available from the Progress Information Hub:

https://docs.progress.com/category/datadirect-apache-impala

You can access the online help system directly in either of the following ways.
* 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
   - PROGRESS_DATADIRECT_JDBC_IMPALA_6.0.0_INSTALL.iam.zip
   - PROGRESS_DATADIRECT_JDBC_COMMON_6.0.0_INSTALL.iam.zip
   - PROGRESS_DATADIRECT_JDBC_DOCUMENTATION_6.0.0_INSTALL.iam.zip

*  Non-Windows:
   - PROGRESS_DATADIRECT_JDBC_INSTALL.jar
   - PROGRESS_DATADIRECT_JDBC_IMPALA_6.0.0_INSTALL.iam.zip
   - PROGRESS_DATADIRECT_JDBC_COMMON_6.0.0_INSTALL.iam.zip
   - PROGRESS_DATADIRECT_JDBC_DOCUMENTATION_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 installation


INSTALL_DIR/lib/60:
------------------
impala.jar                 Apache Impala Driver and DataSource classes

JDBCDriverLogin.conf       Kerberos configuration file used to specify the JAAS
                           login module


INSTALL_DIR/NOTICES/:
---------------------
JDBC for Apache Impala 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 Impala 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_60.exe      Windows uninstaller

Uninstall_JDBC_60.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

TitleResults for “How to create a CRG?”Also Available inAlert