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 |