skip to main content
Connection Option Descriptions for Apache Spark SQL : String Describe Type
  

Try DataDirect Drivers Now

String Describe Type

Attribute

StringDescribeType (SDT)

Purpose

Specifies whether all string columns are described as SQL_WVARCHAR. This connection option affects SQL_Columns, SQLDescribeCol, SQLColAttributes, etc.  It does not affect SQLGetTypeInfo.

Valid Values

-10 | -9

Notes

*When returning result set metadata for Varchar columns, the Spark Thrift server reports the column type as (12) STRING and the precision as 2147483647. This issue can cause the settings of the following connection options to produce unexpected results: Max String Size, Min Long Varchar Size, String Describe Type, and Varchar Threshold. For the latest information about this issue, refer to the Apache JIRA SPARK-5918 issue Web page: https://issues.apache.org/jira/browse/SPARK-5918.

Behavior

If set to -10 (SQL_WLONGVARCHAR), all strings are described as SQL_WLONGVARCHAR
If set to -9 (SQL_WVARCHAR), all string columns are described as SQL_WVARCHAR.

Default

-9 (SQL_WVARCHAR)

GUI Tab

Advanced tab