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. For example:

Array Size

Attribute

ArraySize (AS)

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.

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

Table 1. Attribute Names for the Driver for Impala
Attribute (Short Name) Default
ArraySize (AS) 50000
AuthenticationMethod (AM)

0 (User ID/Password)

BatchMechanism (BM) 2 (MultiRowInsert)
CryptoLibName (CLN) Empty string
CryptoProtocolVersion (CPV) TLSv1.2,TLSv1.1,TLSv1,SSLv3
Database (DB) default
DataSourceName (DSN) None
DefaultLongDataBuffLen (DLDBL) 1024
DefaultOrderByLimit (DOBL) -1 (Disabled)
Description (n/a) None
EnableDescribeParam (EDP) 0 (Disabled)
EnableFIPS (EF) Disabled
EncryptionMethod (EM) 0 (No Encryption)
GSSClient (GSSC) native
HostName (HOST) None
HostNameInCertificate (HNIC) None
KeepAlive (KA) 0 (Disabled)
KeyPassword (KP) None
Keystore (KS) None
KeystorePassword (KSP) None
LoginTimeout (LT) 30
LogonID (UID) None
MaxVarcharSize (MVS) 2147483647
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) None
ProxyUser (PU) None
RemoveColumnQualifiers (RCQ) 0 (Disabled)
ServicePrincipalName (SPN) None
SSLLibName (SLN) Empty String
StringDescribeType (SDT) -9 - SQL_WVARCHAR
TransactionMode (TM) 0 (No Transactions)
Truststore (TS) None
TruststorePassword (TSP) None
UseCurrentSchema (UCS) 0 (Disabled)
ValidateServerCertificate (VSC) 1 (Enabled)

This section includes the following topics: