Search Result: hierarchy - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

Documentation DuckDB 1.3 ドキュメント全文検索

DuckDB 1.3 ドキュメント全文検索

Results of 1 - 3 of about 3 for hierarchy (0.002 sec.)

WITH Clause – DuckDB 11403: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... 1 3 2 4 3 5 5 6 8 7 13 8 21 9 34 Example: Tree Traversal WITH RECURSIVE can be used to traverse trees. For example, take a hierarchy of tags: CREATE TABLE tag ( id INTEGER , name VARCHAR , subclassof INTEGER ); INSERT INTO tag VALUES ( 1 , 'U2' , 5 ), ( 2 ... rt' , NULL ); The following query returns the path from the node Oasis to the root of the tree ( Art ). WITH RECURSIVE tag_hierarchy ( id , source , path ) AS ( SELECT id , name , [ name ] AS path FROM tag WHERE subclassof IS NULL UNION ALL SELECT tag.id ... , tag.name , list_prepend ( tag.name , tag_hierarchy.path ) FROM tag , tag_hierarchy WHERE tag.subclassof = tag_hierarchy.id ) SELECT path FROM tag_hierarchy WHERE source = 'O ...; https://man.mtool.work/duckdb/1.3/sql/query_syntax/with.html

Hive Partitioning – DuckDB 9598: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... the partition key has a value that is determined by the name of the folder. Below is an example of a Hive partitioned file hierarchy. The files are partitioned on two keys ( year and month ). orders ├── year=2021 │ ├── month=1 │ │ ├── file1.parquet │ │ └─ ... uet └── year=2022 ├── month=11 │ ├── file4.parquet │ └── file5.parquet └── month=12 └── file6.parquet Files stored in this hierarchy can be read using the hive_partitioning flag. SELECT * FROM read_parquet ( 'orders/*/*/*.parquet' , hive_partitioning = tr ... quet └── file5.parquet Auto-detection By default the system tries to infer if the provided files are in a hive partitioned hierarchy. And if so, the hive_partitioning flag is enabled automatically. The auto-detection will look at the names of the folders ...; https://man.mtool.work/duckdb/1.3/data/partitioning/hive_partitioning.html

Partitioned Writes – DuckDB 6882: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... ites When the PARTITION_BY clause is specified for the COPY statement , the files are written in a Hive partitioned folder hierarchy. The target is the name of the root directory (in the example above: orders ). The files are written in-order in the file ... s parquet partitioned month year Hive Write table write uuid written partitions option default existing Partitioned Writes hierarchy directory number many partition filenames replaced 関連するページ Hive Partitioning Reading and Writing Parquet Files Parq ...; https://man.mtool.work/duckdb/1.3/data/partitioning/partitioned_writes.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work