You can use connection properties to customize the driver for your environment. This section lists the connection properties supported by the driver and describes each property. You can use these connection properties with either the JDBC Driver Manager or a JDBC data source. For a Driver Manager connection, a property is expressed as a key value pair and takes the form property=value. For a data source connection, a property is expressed as a JDBC method and takes the form setproperty(value).

Note: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such.
Note: The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.

The following table provides a summary of the connection properties supported by the Impala driver and their default values.

Table 1. Impala Driver Properties
Property Data Source Method Default
AccountingInfo setAccountingInfo empty string
ApplicationName setApplicationName empty string
AuthenticationMethod setAuthenticationMethod

userIdPassword

ClientHostName setClientHostName empty string
ClientUser setClientUser empty string
ConnectionRetryCount setConnectionRetryCount 5
ConnectionRetryDelay setConnectionRetryDelay 1 (second)
ConvertNull setConvertNull 1
CryptoProtocolVersion setCryptoProtocolVersion Determined by the JRE settings
DatabaseName setDatabaseName The default database
DefaultOrderByLimit setDefaultOrderByLimit -1
EncryptionMethod setEncryptionMethod noEncryption
HostNameInCertificate setHostNameInCertificate empty string
ImportStatementPool setImportStatementPool empty string
InitializationString setInitializationString None
InsensitiveResultSetBufferSize setInsensitiveResultSetBufferSize 2048
JavaDoubleToString setJavaDoubleToString false
KeyPassword setKeyPassword None
KeyStore setKeyStore None
KeyStorePassword setKeyStorePassword None
LoginConfigName setLoginConfigName JDBC_DRIVER_01
LoginTimeout setLoginTimeout 0
MaxPooledStatements setMaxPooledStatements None
Password setPassword None
PortNumber setPortNumber 21050
ProgramID setProgramID empty string
RegisterStatementPoolMonitorMBean setRegisterStatementPoolMonitorMBean false
RemoveColumnQualifiers setRemoveColumnQualifiers false
ServerName setServerName None
ServicePrincipalName setServicePrincipalName None
SpyAttributes setSpyAttributes None
StringDescribeType setStringDescribeType varchar
TransactionMode setTransactionMode noTransactions
TrustStore setTrustStore None
TrustStorePassword setTrustStorePassword None
UseCurrentSchema setUseCurrentSchema false (results are not restricted to the tables and views in the current schema)
User setUser None
ValidateServerCertificate setValidateServerCertificate

true