外表数据类型映射
ORC/Parquet 格式映射
| ORC/Parquet 类型 | ProtonBase 类型 |
|---|---|
| BOOLEAN | BOOLEAN |
| TINYINT | SMALLINT |
| SMALLINT | SMALLINT |
| INT | INTEGER |
| BIGINT | BIGINT |
| FLOAT | REAL |
| DOUBLE | DOUBLE PRECISION |
| DECIMAL(p,s) | DECIMAL(p,s) |
| STRING | TEXT |
| VARCHAR(n) | VARCHAR(n) |
| CHAR(n) | CHAR(n) |
| BINARY | BYTEA |
| TIMESTAMP | TIMESTAMP |
| DATE | DATE |
| ARRAY | type[] |
| MAP | Not Available |
| STRUCT | Not Available |
Iceberg 格式映射
| Iceberg 类型 | ProtonBase 类型 |
|---|---|
| boolean | BOOLEAN |
| int | INTEGER |
| long | BIGINT |
| float | REAL |
| double | DOUBLE PRECISION |
| decimal(p,s) | DECIMAL(p,s) |
| string | TEXT |
| uuid | UUID |
| fixed(n) | BYTEA |
| binary | BYTEA |
| date | DATE |
| time | TIME |
| timestamp | TIMESTAMP |
| timestamptz | TIMESTAMPTZ |
| list | type[] |
| map | Not Available |
| struct | Not Available |
DeltaLake 格式映射
| DeltaLake 类型 | ProtonBase 类型 |
|---|---|
| boolean | BOOLEAN |
| short | SMALLINT |
| integer | INTEGER |
| long | BIGINT |
| float | REAL |
| double | DOUBLE PRECISION |
| decimal(p,s) | DECIMAL(p,s) |
| string | TEXT |
| varchar(n) | VARCHAR(n) |
| char(n) | CHAR(n) |
| binary | BYTEA |
| date | DATE |
| timestamp | TIMESTAMP |
| array | type[] |
| map | Not Available |
| struct | Not Available |