skip to main content
Connection Option Descriptions
  

Try DataDirect Drivers Now

Connection Option Descriptions

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 6. Attribute Names for the Driver for Apache Hive
Attribute (Short Name)
Default
1.1.1,1.0.2
Note: ArraySize has been replaced by ArrayFetchSize.
None
150000
16384
0 (User ID/Password)
2 (MultiRowInsert)
0 (Mixed)
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)
Empty string
TLSv1.2, TLSv1.1, TLSv1
default
None
1024
None
1 (Enabled)
0 (Disabled)
0 (No Encryption)
native
None
None
cliservice
0 (Disabled)
None
None
None
30
None
Note: MaxVarcharSize has been replaced by MaxStringSize.
None
2147483647
None. If no value is specified, the driver will not change the column size reported for SQL_LONGVARCHAR columns.
10000
None
0 (Disabled)
None
Empty string
-9 (SQL_WVARCHAR)
0 (No Transactions)
0 (binary)
None
None
0 (Disabled)
Note: UseNativeCatalogFunctions has been replaced by CatalogMode.
None
1 (Enabled)
None. If no value is specified, the driver will not change the described type for SQL_VARCHAR columns.
/hiveserver2
0 (Disabled)
This section includes the following topics:
* AllowedOpenSSLVersions
* Array Size
* Array Fetch Size
* Array Insert Size
* Authentication Method
* Batch Mechanism
* Catalog Mode
* Cookie Name
* Crypto Protocol Version
* CryptoLibName
* Data Source Name
* Database Name
* Default Buffer Size for Long/LOB Columns (in Kb)
* Description
* Enable Cookie Authentication
* Enable SQLDescribeParam
* Encryption Method
* GSS Client Library
* Host Name
* Host Name In Certificate
* HTTP Path
* IANAAppCodePage
* Key Password
* Keystore
* Keystore Password
* Login Timeout
* Max String Size
* Max Varchar Size
* Min Long Varchar Size
* Port Number
* Proxy User
* Remove Column Qualifiers
* Service Principal Name
* SSLLibName
* String Describe Type
* TCP Keep Alive
* Transaction Mode
* Transport Mode
* Truststore
* Truststore Password
* Use Current Schema for Catalog Functions
* Use Native Catalog Functions
* User Name
* Validate Server Certificate
* Varchar Threshold
* Zookeeper Namespace
* Zookeeper Discovery