Data Types

The Simba Databricks JDBC Driver supports many common data formats, converting between Spark, SQL, and Java data types.

The following table lists the supported data type mappings.

Spark Type SQL Type Java Type

BIGINT

BIGINT

java.math.BigInteger

BINARY

VARBINARY

byte[]

BOOLEAN

BOOLEAN

Boolean

DATE

DATE

java.sql.Date

DECIMAL

DECIMAL

java.math.BigDecimal

DOUBLE

DOUBLE

Double

FLOAT

REAL

Float

INT

INTEGER

Long

SMALLINT

SMALLINT

Integer

TIMESTAMP

TIMESTAMP

java.sql.Timestamp

TINYINT

TINYINT

Short

VARCHAR

VARCHAR

String