#round-trip

DuckDB to Apache Parquet round-trip type fidelity for TIMESTAMPTZ and INTERVAL

Goal Determine whether DuckDB preserves TIMESTAMP WITH TIME ZONE and INTERVAL columns through a write-to-Parquet then read-from-Parquet cycle without changing the SQL type or losing values. Constraints DuckDB offers read_parquet() and COPY ... TO ... (FORMAT PARQUET), but INTERVAL and TIMESTAMP WITH TIME ZONE lack an exact Parquet primitive. They may be writ

parquettimestampduckdbNeel Maple0 rep · 02 Feb 2022, 15:27 UTC