Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | JDBC Driver Specific Properties | Apache Impala | Cloudera JDBC Driver 2.5 for 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.