Skip to main content
Version: 1.2 (Latest)

MySQL → Parquet

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

SourceMySQL (mysql)
FormatParquet
FastBCP1.2.0.0
Test StatusPASS (Nullable)

Parquet Schema: testdatatypes_nullable​

namephysical_typeconverted_typelogical_type
col_bigintINT64INT_64IntType(bitWidth=64, isSigned=1)
col_intINT32INT_32IntType(bitWidth=32, isSigned=1)
col_mediumintINT32INT_32IntType(bitWidth=32, isSigned=1)
col_smallintINT32INT_16IntType(bitWidth=16, isSigned=1)
col_tinyintBYTE_ARRAYUTF8StringType()
col_bitBYTE_ARRAYUTF8StringType()
col_decimalINT64DECIMALDecimalType(scale=2, precision=18)
col_floatFLOAT——
col_doubleDOUBLE——
col_dateINT64TIMESTAMP_MILLIS—
col_timeBYTE_ARRAYUTF8StringType()
col_datetimeINT64TIMESTAMP_MILLIS—
col_timestampINT64TIMESTAMP_MILLIS—
col_yearINT32INT_32IntType(bitWidth=32, isSigned=1)
col_charBYTE_ARRAYUTF8StringType()
col_varcharBYTE_ARRAYUTF8StringType()
col_tinytextBYTE_ARRAYUTF8StringType()
col_textBYTE_ARRAYUTF8StringType()
col_mediumtextBYTE_ARRAYUTF8StringType()
col_longtextBYTE_ARRAYUTF8StringType()
col_binaryBYTE_ARRAY——
col_varbinaryBYTE_ARRAY——
col_tinyblobBYTE_ARRAY——
col_blobBYTE_ARRAY——
col_mediumblobBYTE_ARRAY——
col_longblobBYTE_ARRAY——
col_enumBYTE_ARRAYUTF8StringType()
col_setBYTE_ARRAYUTF8StringType()
col_jsonBYTE_ARRAYUTF8StringType()
col_geometryBYTE_ARRAY——
col_pointBYTE_ARRAY——
col_linestringBYTE_ARRAY——
col_polygonBYTE_ARRAY——
Copyright © 2026 Architecture & Performance.