When you write data to Teradata through an Arrow Flight SQL client (for example, through CommandStatementUpdate or CommandPreparedStatementUpdate), the connector maps arrow data types to JDBC data types before inserting the data. See the arrow to JDBC mapping below.
| Arrow Data Type | JDBC Data Type |
|---|---|
| Int, BitWidth 8 – Signed | INTEGER |
| Int, BitWidth 16 – Signed | INTEGER |
| Int, BitWidth 32 – Signed | INTEGER |
| Int, BitWidth 64 – Signed | BIGINT |
| Int, BitWidth 8 – Unsigned | INTEGER |
| Int, BitWidth 16 – Unsigned | INTEGER |
| Int, BitWidth 32 – Unsigned | BIGINT |
| Int, BitWidth 64 – Unsigned | DECIMAL |
| Binary | VARBINARY |
| FixedSizeBinary | BINARY |
| LargeBinary | LONGVARBINARY |
| Utf8 | VARCHAR |
| LargeUtf8 | LONGVARCHAR |
| Date | DATE |
| Time | TIME |
| Timestamp | TIMESTAMP |
| Bool | BOOLEAN |
| Decimal | DECIMAL |
| FloatingPoint, Precision DOUBLE | DOUBLE |
| FloatingPoint, Precision SINGLE | FLOAT |
| Struct | STRUCT |
| List / FixedSizeList / LargeList | ARRAY |
| Duration | Not supported |
| Interval, YEAR_MONTH | VARCHAR (Teradata column: INTERVAL YEAR(4) TO MONTH) |
| Interval, DAY_TIME | VARCHAR (Teradata column: INTERVAL DAY(4) TO SECOND(6)) |
| Interval, MONTH_DAY_NANO | Not supported |
| Map | JAVA_OBJECT |
| Union / NONE / Null | Not supported |
| RunEndEncoded | Not supported |