Apache Impala

Cloudera JDBC Driver 2.5 for Apache Impala

DataSource

Transaction Type DataSource Class
NO_TRANSACTION For ImpalaJDBC41.jar JAR file: 
com.cloudera.impala.jdbc41.DataSource

Other Properties

Specify the parameters in the Other Properties field:

Parameter Description
url Other database related properties are provided as part of the url values. 
url={jdbc:impala://<hostname>:portnumber/databasename;
AuthMech=1;SSL=SSL_value;UseSasl=UseSasl_value}
Note: The properties such as AuthMech, SSL, and UseSasl are required only for secured connections.

Kerberos Authentication

Specify the Kerberos authentication parameters in the Other Properties field in the following format: 

url={jdbc:impala://<hostname>:portnumber/databasename;
AuthMech=1;
KrbRealm=<Kerberos_Realm_Name>;
KrbHostFQDN=<Kerberos_FQDN>;
KrbServiceName=<Kerberos_Service_Name>;
KrbAuthType=1}

For example: 

url={jdbc:impala://gbs1.windmill.local:8443/default;
AuthMech=1;
KrbRealm=gbs_Realm.windmill.local;
KrbHostFQDN=gbs_FQDN.windmill.local;
KrbServiceName=impala;
KrbAuthType=1}

Required Connection Property Fields

Driver Name Server Name User Password Database Name Port Number Network Protocol
Apache Impala Cloudera JDBC Driver 2.5 No Yes Yes No No No

For more information about limitations, see Limitations.

Limitations

Driver Database/

Adapter IS Operating System/

Platform Affected

Limitation Description
Cloudera JDBC Driver for Apache Impala Apache Impala
  • Inserting and retrieving data works only on Current catalog and Current schema.
  • This driver does not support:
    1. Services: UpdateSQL, DeleteSQL, BatchInsertSQL,  BatchUpdateSQL, StoredProcedure, and StoredProcedureWithSignature
    2. Notifications: InsertNotifications, UpdateNotifications, DeleteNotifications, StoredProcedureNotifications, StoredProcedureNotificationsWithSignature, and OrderedNotifications
    3. LOCAL_TRANSACTION and XA_TRANSACTION connections