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:
  • In a JDBC data source, string values must be enclosed in double quotation marks, for example, setUser("abc@defcorp.com").
  • The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.
  • Connection property names are case-insensitive. For example, Password is the same as password.
  • For connection properties that support string values, use the following escape sequence to specify values containing leading or trailing spaces and curly brackets: {value}. For example: User={hello } or Password={{hello}}.

The following table provides a summary of the connection properties supported by the Driver for Apache Hive and their default values.

Table 1. Driver for Apache Hive Properties
Property Data Source Method Default
AccountingInfo setAccountingInfo empty string
ApplicationName setApplicationName empty string
ArrayFetchSize setArrayFetchSize 20000 (fields)
ArrayInsertSize setArrayInsertSize 20000 (fields)
AuthenticationMethod setAuthenticationMethod userIdPassword
BinaryDescribeType setBinaryDescribeType varbinary
BatchMechanism setBatchMechanism multiRowInsert
CatalogMode setCatalogMode mixed
ClientHostName setClientHostName empty string
ClientUser setClientUser empty string
ConnectionRetryCount setConnectionRetryCount 5
ConnectionRetryDelay setConnectionRetryDelay 1 (second)
ConvertNull setConvertNull 1
CookieName setCookieName hive.server2.auth
CryptoProtocolVersion setCryptoProtocolVersion Determined by the JRE settings
DatabaseName setDatabaseName The default database
DelegationToken

setDelegationToken

No default value
EnableCookieAuthentication setEnableCookieAuthentication true
EncryptionMethod setEncryptionMethod noEncryption
HostNameInCertificate setHostNameInCertificate empty string
HTTPPath setHTTPPath cliservice
ImpersonateUser setImpersonateUser None
ImportStatementPool setImportStatementPool empty string
InitializationString setInitializationString None
InsensitiveResultSetBufferSize setInsensitiveResultSetBufferSize 2048
JavaDoubleToString setJavaDoubleToString false
KeyPassword setKeyPassword None
KeyStore setKeyStore None
KeyStorePassword setKeyStorePassword None
LoginConfigName setLoginConfigName None
LoginTimeout setLoginTimeout 0
MaxBinarySize setMaxBinarySize 2147483647
MaxStringSize setMaxStringSize 2147483647
MaxPooledStatements setMaxPooledStatements 0
Password setPassword None
PortNumber setPortNumber 10000 (binary mode)

10001 (HTTP mode)
ProgramID setProgramID empty string
ProxyHost setProxyHost empty string
ProxyPassword setProxyPassword empty string
ProxyPort setProxyPort 0
ProxyUser setProxyUser empty string
RegisterStatementPoolMonitorMBean setRegisterStatementPoolMonitorMBean false
RemoveColumnQualifiers setRemoveColumnQualifiers false
SASLQOP

setSASLQOP

auth
ServerName setServerName None
ServicePrincipalName setServicePrincipalName The default is based on the setting of the ServerName property, using the format hive/server_name.
SpyAttributes setSpyAttributes None
StringDescribeType setStringDescribeType varchar
TransactionMode setTransactionMode noTransactions
TransportMode setTransportMode binary
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
ZooKeeperDiscovery setZooKeeperDiscovery false
ZooKeeperNamespace setZooKeeperNamespace None