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 |