Results of 1 - 9 of about 9 for lineitem (0.002 sec.)
- COPY Statement 13858
- 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
...R '|'); Read a Parquet file into the lineitem table: COPY lineitem FROM 'lineitem.pq' (FORMAT parquet); Read a JSON file into the lineitem table, using auto-detected op...tions: COPY lineitem FROM 'lineitem.json' (FORMAT json, AUTO_DETECT true); Read a CSV file into the lineitem table, using double quotes: COPY l...ineitem FROM "lineitem.csv"; Read a CSV file into the lineitem table, omitting quotes: COPY lineitem FROM lineitem.csv; Write a table to a CSV fi... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Iceberg Functions 9490
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...reads an Iceberg table from a path, without requiring an attached catalog: SELECT count(*) FROM iceberg_scan('data/iceberg/lineitem_iceberg', allow_moved_paths = true); count_star() 51793 The path can also point directly to a metadata file, or to an obje...n use the iceberg_metadata function: Warning In DuckDB 2.0.0, iceberg_metadata and iceberg_column_stats fail on the sample lineitem_iceberg table with an Invalid Configuration Error about manifest_entry.sequence_number . SELECT * FROM iceberg_metadata('d...ata/iceberg/lineitem_iceberg', allow_moved_paths = true); manifest_path manifest_sequence_number manifest_content status content file_path file... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- Iceberg Extension 9005
- The iceberg extension implements support for the Apache Iceberg open table format . There are two ways to work with Iceberg in DuckDB: Individual tables are read directly from storage, by pointing at a table's metadata. This requires no cat
...Tables Use the iceberg_scan function to read an Iceberg table from a path: SELECT count(*) FROM iceberg_scan('data/iceberg/lineitem_iceberg', allow_moved_paths = true); count_star() 51793 The allow_moved_paths option ensures that some path resolution is...e manifest version is a UUID. To do so, navigate to the data/iceberg directory and run: SELECT count(*) FROM iceberg_scan('lineitem_iceberg/metadata/v1.metadata.json'); count_star() 60175 For the full list of parameters accepted by iceberg_scan , see the...ccess Iceberg tables in object stores such as S3 or Azure Blob Storage. SELECT count(*) FROM iceberg_scan('s3://bucketname/lineitem_iceberg/metadata/v1.metadata.json'); Metadata and Snapshots To inspect the manifest entries and snapshots of a table, use... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/overview.html
- Iceberg Options 8322
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...number via the version parameter to the functions of the iceberg extension: SELECT * FROM iceberg_snapshots( 'data/iceberg/lineitem_iceberg', version = '1' ); By default, iceberg functions will look for both v{version}.metadata.json and {version}.metadat...ugh the version parameter, it is opened and treated as a version hint file: SELECT * FROM iceberg_snapshots( 'data/iceberg/lineitem_iceberg', version = 'version-hint.txt' ); The iceberg extension will open this file and use the entire content of the file...ttempt to guess the latest version by passing ? as the version parameter: SELECT count(*) FROM iceberg_scan( 'data/iceberg/lineitem_iceberg_no_hint', version = '?', allow_moved_paths = true ); The “latest” version is assumed to be the filename that is le... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Summarize 8286
- The SUMMARIZE command can be used to easily compute a number of aggregates over a table or a query. The SUMMARIZE command launches a query that computes a number of aggregates over all columns ( min , max , approx_unique , avg , std , q25 ,
...marize a query, prepend SUMMARIZE to a query. SUMMARIZE SELECT * FROM tbl; Example Below is an example of SUMMARIZE on the lineitem table of TPC-H SF1 table, generated using the tpch extension . INSTALL tpch; LOAD tpch; CALL dbgen(sf = 1); SUMMARIZE line... - https://man.mtool.work/duckdb/2.0/guides/meta/summarize.html
- Create Synthetic Data 8070
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...opulates the benchmark's tables at a given scale factor: INSTALL tpch; LOAD tpch; CALL dbgen(sf = 0.1); SELECT count(*) AS lineitem_rows FROM lineitem; Community Extensions The fakeit community extension provides table functions that generate fake data (... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Parquet Encryption 7962
- Starting with version 0.10.0, DuckDB supports reading and writing encrypted Parquet files. DuckDB broadly follows the Parquet Modular Encryption specification with some limitations . Reading and Writing Encrypted Files Using the PRAGMA add_
...d Performance Implications Note that encryption has some performance implications. Without encryption, reading/writing the lineitem table from TPC-H at SF1, which is 6M rows and 15 columns, from/to a Parquet file takes 0.26 and 0.99 seconds, respectively... - https://man.mtool.work/duckdb/2.0/data/parquet/encryption.html
- TPC-H Extension 7909
- The tpch extension implements the data generator and queries for the TPC-H benchmark . Installing and Loading The tpch extension is shipped by default in some DuckDB builds, otherwise it will be transparently autoloaded on first use. If you
...es. To clean up existing tables, use DROP TABLE before running dbgen : DROP TABLE IF EXISTS customer; DROP TABLE IF EXISTS lineitem; DROP TABLE IF EXISTS nation; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS part; DROP TABLE IF EXISTS partsupp; DROP... - https://man.mtool.work/duckdb/2.0/core_extensions/tpch.html
- Reading and Writing Parquet Files 7909
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...the page size of Parquet file's dictionary pages, use the STRING_DICTIONARY_PAGE_SIZE_LIMIT option (default: 1 GiB): COPY lineitem TO 'lineitem-with-custom-dictionary-size.parquet' (FORMAT parquet, STRING_DICTIONARY_PAGE_SIZE_LIMIT 100_000); New The fol... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work