MySQL → Parquet

Datatypes conversion mapping when exporting from MySQL (--connectiontype mysql) to Parquet format.

Source	MySQL (mysql)
Format	Parquet
FastBCP	1.1.4.0
Test Status	PASS (Nullable)

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	—	—