skip to main content
Connection property descriptions
  

Try DataDirect Drivers Now

Connection property descriptions

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 Driver for Apache Hive and their default values.
Table 19. Driver for Apache Hive Properties
Property
Data Source Method
Default
setAccountingInfo
empty string
setApplicationName
empty string
setArrayFetchSize
20000 (fields)
setArrayInsertSize
20000 (fields)
setAuthenticationMethod
userIdPassword
setBinaryDescribeType
varbinary
setBatchMechanism
multiRowInsert
setCatalogMode
mixed
setClientHostName
empty string
setClientUser
empty string
setConnectionRetryCount
5
setConnectionRetryDelay
1 (second)
setConvertNull
1
setCookieName
hive.server2.auth
setCryptoProtocolVersion
Determined by the JRE settings
setDatabaseName
The default database
setEnableCookieAuthentication
true
setEncryptionMethod
noEncryption
setHostNameInCertificate
empty string
setHTTPPath
cliservice
setImpersonateUser
None
setImportStatementPool
empty string
setInitializationString
None
setInsensitiveResultSetBufferSize
2048
setJavaDoubleToString
false
setKeyPassword
None
setKeyStore
None
setKeyStorePassword
None
setLoginConfigName
None
setLoginTimeout
0
setMaxBinarySize
2147483647
setMaxStringSize
2147483647
setMaxPooledStatements
0
setPassword
None
setPortNumber
10000 (binary mode)
10001 (HTTP mode)
setProgramID
empty string
setQueryTimeout
0
setRegisterStatementPoolMonitorMBean
false
setRemoveColumnQualifiers
false
setServerName
None
setServicePrincipalName
The default is based on the setting of the ServerName property, using the format hive/server_name.
setSpyAttributes
None
setStringDescribeType
varchar
setTransactionMode
noTransactions
setTransportMode
binary
setTrustStore
None
setTrustStorePassword
None
setUseCurrentSchema
false (results are not restricted to the tables and views in the current schema)
setUser
None
setValidateServerCertificate
true
setZooKeeperDiscovery
false
setZooKeeperNamespace
None
* AccountingInfo
* ApplicationName
* ArrayFetchSize
* ArrayInsertSize
* AuthenticationMethod
* BatchMechanism
* BinaryDescribeType
* CatalogMode
* ClientHostName
* ClientUser
* ConnectionRetryCount
* ConnectionRetryDelay
* ConvertNull
* CookieName
* CryptoProtocolVersion
* DatabaseName
* EnableCookieAuthentication
* EncryptionMethod
* HostNameInCertificate
* HTTPPath
* ImpersonateUser
* ImportStatementPool
* InitializationString
* InsensitiveResultSetBufferSize
* JavaDoubleToString
* KeyPassword
* KeyStore
* KeyStorePassword
* LoginConfigName
* LoginTimeout
* MaxBinarySize
* MaxPooledStatements
* MaxStringSize
* Password
* PortNumber
* ProgramID
* QueryTimeout
* RegisterStatementPoolMonitorMBean
* RemoveColumnQualifiers
* ServerName
* ServicePrincipalName
* SpyAttributes
* StringDescribeType
* TransactionMode
* TransportMode
* TrustStore
* TrustStorePassword
* UseCurrentSchema
* User
* ValidateServerCertificate
* ZooKeeperDiscovery
* ZooKeeperNamespace