Teradata → Parquet
Datatypes conversion mapping when exporting from Teradata (--connectiontype teradata) to Parquet format.
| Source | Teradata (teradata) |
| Format | Parquet |
| FastBCP | 0.32.2.0 |
| Test Status | PASS (NotNull + Nullable) |
Parquet Schema: testdatatypes_notnull
| name | physical_type | converted_type | logical_type |
|---|---|---|---|
| col_byteint | INT32 | INT_16 | IntType(bitWidth=16, isSigned=1) |
| col_smallint | INT32 | INT_16 | IntType(bitWidth=16, isSigned=1) |
| col_integer | INT32 | INT_32 | IntType(bitWidth=32, isSigned=1) |
| col_bigint | INT64 | INT_64 | IntType(bitWidth=64, isSigned=1) |
| col_decimal18_2 | INT64 | DECIMAL | DecimalType(scale=2, precision=18) |
| col_float | DOUBLE | — | — |
| col_number | FIXED_LEN_BYTE_ARRAY | DECIMAL | DecimalType(scale=18, precision=38) |
| col_number18_2 | INT64 | DECIMAL | DecimalType(scale=2, precision=18) |
| col_date | INT32 | DATE | — |
| col_time | INT64 | TIME_MICROS | TimeType(isAdjustedToUTC=0, unit=MICROS) |
| col_timestamp | BYTE_ARRAY | UTF8 | StringType() |
| col_timestamp_tz | BYTE_ARRAY | UTF8 | StringType() |
| tdintervalyear | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalyeartomonth | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalmonth | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalday | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervaldaytohour | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervaldaytominute | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervaldaytosecond | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalhour | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalhourtominute | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalhourtosecond | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalminute | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalminutetosecond | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalsecond | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| col_real | DOUBLE | — | — |
| col_double_precision | DOUBLE | — | — |
| col_char | BYTE_ARRAY | UTF8 | StringType() |
| col_varchar | BYTE_ARRAY | UTF8 | StringType() |
| col_clob | BYTE_ARRAY | UTF8 | StringType() |
| col_byte | BYTE_ARRAY | — | — |
| col_varbyte | BYTE_ARRAY | — | — |
| col_blob | BYTE_ARRAY | — | — |
| col_period_date | BYTE_ARRAY | UTF8 | StringType() |
| col_period_timestamp | BYTE_ARRAY | UTF8 | StringType() |
| col_json | BYTE_ARRAY | UTF8 | StringType() |
| col_xml | BYTE_ARRAY | UTF8 | StringType() |
| col_st_geometry | BYTE_ARRAY | UTF8 | StringType() |
Parquet Schema: testdatatypes_nullable
| name | physical_type | converted_type | logical_type |
|---|---|---|---|
| col_byteint | INT32 | INT_16 | IntType(bitWidth=16, isSigned=1) |
| col_smallint | INT32 | INT_16 | IntType(bitWidth=16, isSigned=1) |
| col_integer | INT32 | INT_32 | IntType(bitWidth=32, isSigned=1) |
| col_bigint | INT64 | INT_64 | IntType(bitWidth=64, isSigned=1) |
| col_decimal18_2 | INT64 | DECIMAL | DecimalType(scale=2, precision=18) |
| col_float | DOUBLE | — | — |
| col_number | FIXED_LEN_BYTE_ARRAY | DECIMAL | DecimalType(scale=18, precision=38) |
| col_number18_2 | INT64 | DECIMAL | DecimalType(scale=2, precision=18) |
| col_date | INT32 | DATE | — |
| col_time | INT64 | TIME_MICROS | TimeType(isAdjustedToUTC=0, unit=MICROS) |
| col_timestamp | BYTE_ARRAY | UTF8 | StringType() |
| col_timestamp_tz | BYTE_ARRAY | UTF8 | StringType() |
| tdintervalyear | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalyeartomonth | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalmonth | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalday | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervaldaytohour | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervaldaytominute | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervaldaytosecond | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalhour | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalhourtominute | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalhourtosecond | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalminute | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalminutetosecond | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| tdintervalsecond | FIXED_LEN_BYTE_ARRAY | INTERVAL | — |
| col_real | DOUBLE | — | — |
| col_double_precision | DOUBLE | — | — |
| col_char | BYTE_ARRAY | UTF8 | StringType() |
| col_varchar | BYTE_ARRAY | UTF8 | StringType() |
| col_clob | BYTE_ARRAY | UTF8 | StringType() |
| col_byte | BYTE_ARRAY | — | — |
| col_varbyte | BYTE_ARRAY | — | — |
| col_blob | BYTE_ARRAY | — | — |
| col_period_date | BYTE_ARRAY | UTF8 | StringType() |
| col_period_timestamp | BYTE_ARRAY | UTF8 | StringType() |
| col_json | BYTE_ARRAY | UTF8 | StringType() |
| col_xml | BYTE_ARRAY | UTF8 | StringType() |
| col_st_geometry | BYTE_ARRAY | UTF8 | StringType() |