The following connection option descriptions are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name.

In most cases, the GUI name and the attribute name are the same; however, some exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.

Note: The driver does not support specifying values for the same connection option multiple times in a connection string or DSN. If a value is specified using the same attribute multiple times or using both long and short attributes, the connection may fail or the driver may not behave as intended.

The following table lists the connection string attributes supported by the driver.

Table 1. Attribute Names for the Driver for Apache Hive
Attribute (Short Name) Default
ArraySize (AS)
Note: ArraySize has been replaced by ArrayFetchSize.
None
ArrayFetchSize (AFS) 150000
ArrayInsertSize (AIS) 16384
AuthenticationMethod (AM) 0 (User ID/Password)
BatchMechanism (BM) 2 (MultiRowInsert)
CatalogMode (CM) 0 (Mixed)
CookieName (CN) If no value is specified, the driver attempts to use the following cookie names by default:
  • hive.server2.auth (Hive connections)
  • hadoop.auth (Apache Knox connections)
  • JSESSIONID (Apache Knox connections)
CryptoLibName (CLN) Empty string
CryptoProtocolVersion (CPV) TLSv1.2, TLSv1.1, TLSv1
Database (DB) default
DataSourceName (DSN) None
DefaultLongDataBuffLen (DLDBL) 1024
Description (n/a) None
Enable Cookie Authentication (ECA) 1 (Enabled)
EnableDescribeParam (EDP) 0 (Disabled)
EnableFIPS (EF) 0 (Default provider)
EncryptionMethod (EM) 0 (No Encryption)
GSSClient (GSSC) native
HostName (HOST) None
HostNameInCertificate (HNIC) None
HTTPPath (HP) cliservice
KeepAlive (KA) 0 (Disabled)
KeyPassword (KP) None
Keystore (KS) None
KeystorePassword (KSP) None
LoginTimeout (LT) 30
LogonID (UID) None
MaxStringSize (MSS) 2147483647
MinLongVarcharSize (MINLVS) None. If no value is specified, the driver will not change the column size reported for SQL_LONGVARCHAR columns.
OpenSSLConfigFile (OSSLCNF)

install_dir\drivers\openssl.cnf (Windows)

install_dir/lib/openssl.cnf (UNIX/Linux)
OpenSSLProviderPath (OSSLPP)

install_dir\drivers (Windows)

install_dir/lib (UNIX/Linux)
Password (PWD) None
PortNumber (PORT) 10000
ProxyUser (PU) None
RemoveColumnQualifiers (RCQ) 0 (Disabled)
ServicePrincipalName (SPN) None
SSLLibName (SLN) Empty string
StringDescribeType (SDT) -9 (SQL_WVARCHAR)
TransactionMode (TM) 0 (No Transactions)
TransportMode (TRM) 0 (binary)
Truststore (TS) None
TruststorePassword (TSP) None
UseCurrentSchema (UCS) 0 (Disabled)
UseNativeCatalogFunctions (UNCF)
Note: UseNativeCatalogFunctions has been replaced by CatalogMode.
None
UseUnicodeCharTypes (UUCT) 1
ValidateServerCertificate (VSC) 1 (Enabled)
VarcharThreshold (VT) None. If no value is specified, the driver will not change the described type for SQL_VARCHAR columns.
ZookeeperDiscovery (ZKD) 0 (Disabled)
ZookeeperNamespace (ZKN) /hiveserver2

This section includes the following topics: