Data Types¶
DataFusion uses Arrow, and thus the Arrow type system, for query
execution. The SQL types from
sqlparser-rs
are mapped to Arrow data types according to the following table.
This mapping occurs when defining the schema in a CREATE EXTERNAL TABLE
command or when performing a SQL CAST
operation.
Character Types¶
SQL DataType |
Arrow DataType |
---|---|
|
|
|
|
|
|
Numeric Types¶
SQL DataType |
Arrow DataType |
Notes |
---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Decimal support is currently experimental (#3523) |
Date/Time Types¶
SQL DataType |
Arrow DataType |
---|---|
|
|
|
|
|
|
Boolean Types¶
SQL DataType |
Arrow DataType |
---|---|
|
|
Binary Types¶
SQL DataType |
Arrow DataType |
---|---|
|
|
Unsupported Types¶
SQL Data Type |
Arrow DataType |
---|---|
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |
|
Not yet supported |