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 Apache Spark SQL Wire Protocol Driver
Attribute (Short Name) Default
ArraySize (AS) 150000
AuthenticationMethod (AM) 0 (User ID/Password)
CookieName (CN) hive.server2.auth
CryptoLibName (CLN) Empty string
CryptoProtocolVersion (CPV) TLSv1.2, TLSv1.1, TLSv1
Database (DB) default
DataSourceName (DSN) None
Description (n/a) None
DefaultLongDataBuffLen (DLDBL) 1024
EnableCookieAuthentication (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
PRNGSeedFile (PSF) (UNIX and Linux only) /dev/random
PRNGSeedSource (PSS) (UNIX and Linux only) 0 (File)
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)
ValidateServerCertificate (VSC) 1 (Enabled)
VarcharThreshold (VT) None. If no value is specified, the driver will not change the described type for VARCHAR columns.