This section lists the JDBC connection properties supported by the Driver for Apache Hive and describes each property. The properties have the form:

property=value

You can use these connection properties with either the JDBC Driver Manager or the JDBC data sources unless otherwise noted.

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 1. Driver for Apache Hive Properties
Property Default
AccountingInfo empty string
ApplicationName empty string
AuthenticationMethod userIdPassword
BatchMechanism multiRowInsert
ClientHostName empty string
ClientUser empty string
ConnectionRetryCount 5
ConnectionRetryDelay 1 (second)
ConvertNull 1
CryptoProtocolVersion TLSv1
Database The default database
DatabaseName The default database
EnableCancelTimeout false
EncryptionMethod noEncryption
HostNameInCertificate empty string
ImportStatementPool empty string
InitializationString None
InsensitiveResultSetBufferSize 2048
JavaDoubleToString false
KeyPassword None
KeyStore None
KeyStorePassword None
LoginTimeout 0
MaxPooledStatements None
MaxStatements None
Password None
PortNumber 10000
ProgramID empty string
QueryTimeout 0
RegisterStatementPoolMonitorMBean false
RemoveColumnQualifiers false
ServerName None
ServicePrincipalName None
SpyAttributes None
StringDescribeType varchar
TransactionMode noTransactions
TrustStore None
TrustStorePassword None
UseCurrentSchema false (results are not restricted to the tables and views in the current schema)
User None
ValidateServerCertificate true
WireProtocolVersion auto