Results of 1 - 3 of about 3 for subdirectory (0.001 sec.)
- Partitioned Writes 11886
- Examples Write a table to a Hive partitioned dataset of Parquet files: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, month)); Write a table to a Hive partitioned dataset of CSV files, allowing overwrites: COPY orders TO 'orde
...PATTERN 'file_{uuid}'); Custom Partition Paths New As of DuckDB 2.0, the PARTITION_PATH option gives full control over the subdirectory that each partition is written to, replacing the default col=value Hive layout. By default, the PARTITION_BY clause writes...each partition to a col=value subdirectory following the Hive partitioning convention. The PARTITION_PATH option replaces this with an expression over the PARTITION_...BY columns that computes the output subdirectory for each partition: COPY sales TO 'sales' (FORMAT parquet, PARTITION_BY (region), PARTITION_PATH CASE WHEN region = 'eu' T... - https://man.mtool.work/duckdb/2.0/data/partitioning/partitioned_writes.html
- Pattern Matching 8352
- There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE ex
...ename⟩ in the top-level directory. For example, with a README.md file present both in the current directory and in its sub subdirectory, the following query returns both files: SELECT * FROM glob('**/README.md'); file README.md sub/README.md Regular Expressi... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- COPY Statement 7645
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...ned writes section . VARCHAR[] (empty) PARTITION_PATH An expression over the PARTITION_BY columns that computes the output subdirectory for each partition, replacing the default col=value Hive layout. The result must be a relative path (no leading / , no ..... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work