skip to main content
Connection Option Descriptions for Apache Spark SQL
  

Try DataDirect Drivers Now

Connection Option Descriptions for Apache Spark SQL

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.
The following table lists the connection string attributes supported by the driver.
Table 4. Attribute Names for the Apache Spark SQL Wire Protocol Driver
Attribute (Short Name)
Default
1.1.1,1.0.2
20000
0 (User ID/Password)
Empty string
TLSv1.2, TLSv1.1, TLSv1
default
None
None
1024
0 (Disabled)
0 (No Encryption)
native
None
None
0 (Disabled)
None
None
None
30
None
2147483647
None. If no value is specified, the driver will not change the column size reported for SQL_LONGVARCHAR columns.
10000
PRNGSeedFile (PSF) (UNIX and Linux only)
/dev/random
PRNGSeedSource (PSS) (UNIX and Linux only)
0 (File)
None
0 (Disabled)
None
Empty string
-9 (SQL_WVARCHAR)
0 (No Transactions)
None
None
0 (Disabled)
1 (Enabled)
None. If no value is specified, the driver will not change the described type for VARCHAR columns.
* AllowedOpenSSLVersions
* Array Size
* Authentication Method
* Crypto Protocol Version
* CryptoLibName
* Data Source Name
* Database
* Default Buffer Size for Long/LOB Columns (in Kb)
* Description
* Enable SQLDescribeParam
* Encryption Method
* GSS Client Library
* Host Name
* Host Name In Certificate
* IANAAppCodePage
* Key Password
* Key Store
* Key Store Password
* Login Timeout
* Max String Size
* Min Long Varchar Size
* PortNumber
* PRNGSeedFile
* PRNGSeedSource
* Proxy User
* Remove Column Qualifiers
* Service Principal Name
* SSLLibName
* String Describe Type
* TCP Keep Alive
* Transaction Mode
* Trust Store
* Trust Store Password
* Use Current Schema for Catalog Functions
* Use Native Catalog Functions
* User Name
* Validate Server Certificate
* Varchar Threshold