The following table provides getTypeInfo results for all sources supported by the driver.

Table 1. getTypeInfo()
TYPE_NAME = bigint
  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -5 (BIGINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = L
  • LOCAL_TYPE_NAME = bigint
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 19
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false
TYPE_NAME = boolean
  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 16 (BOOLEAN)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = boolean
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 1
  • SEARCHABLE = 2
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL
TYPE_NAME = date
  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 91 (DATE)
  • FIXED_PREC_SCALE = true
  • LITERAL_PREFIX = {d'
  • LITERAL_SUFFIX = '}
  • LOCAL_TYPE_NAME = date
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 10
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL

TYPE_NAME = decimal

  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 3 (DECIMAL)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = decimal
  • MAXIMUM_SCALE = 38
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 38
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false
TYPE_NAME = double
  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 8 (DOUBLE)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = double
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 15
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false
TYPE_NAME = float
  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 7 (REAL)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = float
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 7
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false
TYPE_NAME = int
  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 4 (INTEGER)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = NULL
  • LOCAL_TYPE_NAME = int
  • MAXIMUM_SCALE = 0
 
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 10
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false
TYPE_NAME = smallint
  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 5 (SMALLINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = S
  • LOCAL_TYPE_NAME = smallint
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 5
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false
TYPE_NAME = string1, 2
  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = true
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR) or -1 (LONGVARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = string
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 2147483647
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL
TYPE_NAME = timestamp
  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 93 (TIMESTAMP)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = {ts'
  • LITERAL_SUFFIX = '}
  • LOCAL_TYPE_NAME = timestamp
  • MAXIMUM_SCALE = 9
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 29
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL
TYPE_NAME = tinyint
  • AUTO_INCREMENT = false
  • CASE_SENSITIVE = false
  • CREATE_PARAMS = NULL
  • DATA_TYPE = -6 (TINYINT)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = NULL
  • LITERAL_SUFFIX = Y
  • LOCAL_TYPE_NAME = tinyint
  • MAXIMUM_SCALE = 0
  
  • MINIMUM_SCALE = 0
  • NULLABLE = 1
  • NUM_PREC_RADIX = 10
  • PRECISION = 3
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = false
TYPE_NAME = varchar3
  • AUTO_INCREMENT = NULL
  • CASE_SENSITIVE = true
  • CREATE_PARAMS = NULL
  • DATA_TYPE = 12 (VARCHAR)
  • FIXED_PREC_SCALE = false
  • LITERAL_PREFIX = '
  • LITERAL_SUFFIX = '
  • LOCAL_TYPE_NAME = varchar
  • MAXIMUM_SCALE = NULL
  
  • MINIMUM_SCALE = NULL
  • NULLABLE = 1
  • NUM_PREC_RADIX = NULL
  • PRECISION = 65355
  • SEARCHABLE = 3
  • SQL_DATA_TYPE = NULL
  • SQL_DATETIME_SUB = NULL
  • UNSIGNED_ATTRIBUTE = NULL
1 Maximum of 2 GB
2 If the StringDescribeType connection property is set to varchar (the default), the String data type maps to VARCHAR. If StringDescribeType is set to longvarchar, String maps to LONGVARCHAR. StringDescribeType affects all columns reported as String, even columns that were originally cast as Varchar. This is important to note because the Spark Thrift server, when returning result metadata for Varchar columns, reports column type as (12) STRING and precision as 2147483647.
3

When returning result set metadata for Varchar columns, the Spark Thrift server reports the column type as (12) STRING and the precision as 2147483647. For the latest information about this issue, refer to the Apache JIRA SPARK-5918 issue Web page.