Resources

Hive Partitioning

duckdb.org

Examples Read data from a Hive partitioned dataset: SELECT * FROM read_parquet('orders/*/*/*.parquet', hive_partitioning = true); Write a table to a Hive partitioned dataset: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, month)); Note that the PARTITION_BY options cannot use expressions. You can produce columns on the fly using the following syntax: COPY (SELECT *, year(timestamp) AS year, month(times…

Visit Site

Resources duckdb.org