SAP HANA → Parquet
Datatypes conversion mapping when exporting from SAP HANA (--connectiontype saphana) to Parquet format.
| Source | SAP HANA (saphana) |
| Format | Parquet |
| FastBCP | 0.32.2.0 |
| Test Status | PASS (NotNull + Nullable) |
Parquet Schema: testdatatypes_notnull
| name | physical_type | converted_type | logical_type |
|---|---|---|---|
| COL_TINYINT | INT32 | UINT_8 | IntType(bitWidth=8, isSigned=0) |
| 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_DECIMAL | INT64 | DECIMAL | DecimalType(scale=2, precision=18) |
| COL_SMALLDECIMAL | INT64 | DECIMAL | DecimalType(scale=0, precision=16) |
| COL_REAL | FLOAT | — | — |
| COL_DOUBLE | DOUBLE | — | — |
| COL_FLOAT | DOUBLE | — | — |
| COL_BOOLEAN | BOOLEAN | — | — |
| COL_DATE | INT64 | TIMESTAMP_MILLIS | — |
| COL_TIME | BYTE_ARRAY | UTF8 | StringType() |
| COL_TIMESTAMP | INT64 | TIMESTAMP_MILLIS | — |
| COL_SECONDDATE | INT64 | TIMESTAMP_MILLIS | — |
| COL_CHAR | BYTE_ARRAY | UTF8 | StringType() |
| COL_VARCHAR | BYTE_ARRAY | UTF8 | StringType() |
| COL_NCHAR | BYTE_ARRAY | UTF8 | StringType() |
| COL_NVARCHAR | BYTE_ARRAY | UTF8 | StringType() |
| COL_ALPHANUM | BYTE_ARRAY | UTF8 | StringType() |
| COL_CLOB | BYTE_ARRAY | UTF8 | StringType() |
| COL_NCLOB | BYTE_ARRAY | UTF8 | StringType() |
| COL_BLOB | BYTE_ARRAY | — | — |
| COL_BINARY | BYTE_ARRAY | — | — |
| COL_VARBINARY | BYTE_ARRAY | — | — |
| COL_ST_GEOMETRY | BYTE_ARRAY | — | — |
| COL_ST_POINT | BYTE_ARRAY | — | — |
| COL_SHORTTEXT | BYTE_ARRAY | UTF8 | StringType() |
Parquet Schema: testdatatypes_nullable
| name | physical_type | converted_type | logical_type |
|---|---|---|---|
| COL_TINYINT | INT32 | UINT_8 | IntType(bitWidth=8, isSigned=0) |
| 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_DECIMAL | INT64 | DECIMAL | DecimalType(scale=2, precision=18) |
| COL_SMALLDECIMAL | INT64 | DECIMAL | DecimalType(scale=0, precision=16) |
| COL_REAL | FLOAT | — | — |
| COL_DOUBLE | DOUBLE | — | — |
| COL_FLOAT | DOUBLE | — | — |
| COL_BOOLEAN | BOOLEAN | — | — |
| COL_DATE | INT64 | TIMESTAMP_MILLIS | — |
| COL_TIME | BYTE_ARRAY | UTF8 | StringType() |
| COL_TIMESTAMP | INT64 | TIMESTAMP_MILLIS | — |
| COL_SECONDDATE | INT64 | TIMESTAMP_MILLIS | — |
| COL_CHAR | BYTE_ARRAY | UTF8 | StringType() |
| COL_VARCHAR | BYTE_ARRAY | UTF8 | StringType() |
| COL_NCHAR | BYTE_ARRAY | UTF8 | StringType() |
| COL_NVARCHAR | BYTE_ARRAY | UTF8 | StringType() |
| COL_ALPHANUM | BYTE_ARRAY | UTF8 | StringType() |
| COL_CLOB | BYTE_ARRAY | UTF8 | StringType() |
| COL_NCLOB | BYTE_ARRAY | UTF8 | StringType() |
| COL_BLOB | BYTE_ARRAY | — | — |
| COL_BINARY | BYTE_ARRAY | — | — |
| COL_VARBINARY | BYTE_ARRAY | — | — |
| COL_ST_GEOMETRY | BYTE_ARRAY | — | — |
| COL_ST_POINT | BYTE_ARRAY | — | — |
| COL_SHORTTEXT | BYTE_ARRAY | UTF8 | StringType() |