MySQL → Parquet
Datatypes conversion mapping when exporting from MySQL (--connectiontype mysql) to Parquet format.
| Source | MySQL (mysql) |
| Format | Parquet |
| FastBCP | 0.32.2.0 |
| Test Status | PASS (NotNull + Nullable) |
Parquet Schema: testdatatypes_notnull
| name | physical_type | converted_type | logical_type |
|---|---|---|---|
| col_bigint | INT64 | INT_64 | IntType(bitWidth=64, isSigned=1) |
| col_int | INT32 | INT_32 | IntType(bitWidth=32, isSigned=1) |
| col_mediumint | INT32 | INT_32 | IntType(bitWidth=32, isSigned=1) |
| col_smallint | INT32 | INT_16 | IntType(bitWidth=16, isSigned=1) |
| col_tinyint | BYTE_ARRAY | UTF8 | StringType() |
| col_bit | BYTE_ARRAY | UTF8 | StringType() |
| col_decimal | INT64 | DECIMAL | DecimalType(scale=2, precision=18) |
| col_float | FLOAT | — | — |
| col_double | DOUBLE | — | — |
| col_date | INT64 | TIMESTAMP_MILLIS | — |
| col_time | BYTE_ARRAY | UTF8 | StringType() |
| col_datetime | INT64 | TIMESTAMP_MILLIS | — |
| col_timestamp | INT64 | TIMESTAMP_MILLIS | — |
| col_year | INT32 | INT_32 | IntType(bitWidth=32, isSigned=1) |
| col_char | BYTE_ARRAY | UTF8 | StringType() |
| col_varchar | BYTE_ARRAY | UTF8 | StringType() |
| col_tinytext | BYTE_ARRAY | UTF8 | StringType() |
| col_text | BYTE_ARRAY | UTF8 | StringType() |
| col_mediumtext | BYTE_ARRAY | UTF8 | StringType() |
| col_longtext | BYTE_ARRAY | UTF8 | StringType() |
| col_binary | BYTE_ARRAY | — | — |
| col_varbinary | BYTE_ARRAY | — | — |
| col_tinyblob | BYTE_ARRAY | — | — |
| col_blob | BYTE_ARRAY | — | — |
| col_mediumblob | BYTE_ARRAY | — | — |
| col_longblob | BYTE_ARRAY | — | — |
| col_enum | BYTE_ARRAY | UTF8 | StringType() |
| col_set | BYTE_ARRAY | UTF8 | StringType() |
| col_json | BYTE_ARRAY | UTF8 | StringType() |
| col_geometry | BYTE_ARRAY | — | — |
| col_point | BYTE_ARRAY | — | — |
| col_linestring | BYTE_ARRAY | — | — |
| col_polygon | BYTE_ARRAY | — | — |
Parquet Schema: testdatatypes_nullable
| name | physical_type | converted_type | logical_type |
|---|---|---|---|
| col_bigint | INT64 | INT_64 | IntType(bitWidth=64, isSigned=1) |
| col_int | INT32 | INT_32 | IntType(bitWidth=32, isSigned=1) |
| col_mediumint | INT32 | INT_32 | IntType(bitWidth=32, isSigned=1) |
| col_smallint | INT32 | INT_16 | IntType(bitWidth=16, isSigned=1) |
| col_tinyint | BYTE_ARRAY | UTF8 | StringType() |
| col_bit | BYTE_ARRAY | UTF8 | StringType() |
| col_decimal | INT64 | DECIMAL | DecimalType(scale=2, precision=18) |
| col_float | FLOAT | — | — |
| col_double | DOUBLE | — | — |
| col_date | INT64 | TIMESTAMP_MILLIS | — |
| col_time | BYTE_ARRAY | UTF8 | StringType() |
| col_datetime | INT64 | TIMESTAMP_MILLIS | — |
| col_timestamp | INT64 | TIMESTAMP_MILLIS | — |
| col_year | INT32 | INT_32 | IntType(bitWidth=32, isSigned=1) |
| col_char | BYTE_ARRAY | UTF8 | StringType() |
| col_varchar | BYTE_ARRAY | UTF8 | StringType() |
| col_tinytext | BYTE_ARRAY | UTF8 | StringType() |
| col_text | BYTE_ARRAY | UTF8 | StringType() |
| col_mediumtext | BYTE_ARRAY | UTF8 | StringType() |
| col_longtext | BYTE_ARRAY | UTF8 | StringType() |
| col_binary | BYTE_ARRAY | — | — |
| col_varbinary | BYTE_ARRAY | — | — |
| col_tinyblob | BYTE_ARRAY | — | — |
| col_blob | BYTE_ARRAY | — | — |
| col_mediumblob | BYTE_ARRAY | — | — |
| col_longblob | BYTE_ARRAY | — | — |
| col_enum | BYTE_ARRAY | UTF8 | StringType() |
| col_set | BYTE_ARRAY | UTF8 | StringType() |
| col_json | BYTE_ARRAY | UTF8 | StringType() |
| col_geometry | BYTE_ARRAY | — | — |
| col_point | BYTE_ARRAY | — | — |
| col_linestring | BYTE_ARRAY | — | — |
| col_polygon | BYTE_ARRAY | — | — |