Results of 1 - 5 of about 5 for granularity (0.004 sec.)
- GROUP BY Clause 12023
- The GROUP BY clause specifies which grouping columns should be used to perform any aggregations in the SELECT clause. If the GROUP BY clause is specified, the query is always an aggregate query, even if no aggregations are present in the SE
...ies the syntax by allowing the columns list to be maintained in a single location, and prevents bugs by keeping the SELECT granularity aligned to the GROUP BY granularity (e.g., it prevents duplication). See examples below and additional examples in the “Fr... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/groupby.html
- CREATE TRIGGER Statement 10736
- New The CREATE TRIGGER feature was introduced in DuckDB 2.0. The CREATE TRIGGER statement registers a trigger: a set of SQL statements that run automatically in response to INSERT , UPDATE , or DELETE events on a table. Examples Record ever
...ORE triggers run before the triggering statement is applied. AFTER triggers run after the triggering statement is applied. Granularity FOR EACH ROW fires the trigger once for every row affected by the statement. The triggered statement can refer to the affe...cannot be combined. Multiple Triggers A table can have multiple triggers for the same event, as long as they have the same granularity (see Limitations ). They fire in the order in which they were created. Returning Rows A data modification statement on a t... - https://man.mtool.work/duckdb/2.0/sql/statements/create_trigger.html
- Reading and Writing Parquet Files 7887
- 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
...0. To split data pages below the default 100 MiB cap, use DATA_PAGE_SIZE_LIMIT (bytes). The limit is best-effort at vector granularity. E.g., to set the limit to 1 MiB, use: COPY tbl TO 'tbl.parquet' (FORMAT parquet, DATA_PAGE_SIZE_LIMIT 1_048_576); DuckDB'... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
- DuckDB_% Metadata Functions 7629
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...ELETE . VARCHAR columns For UPDATE OF ⟨column⟩, ... triggers, the list of columns. Empty otherwise. VARCHAR[] for_each The granularity of the trigger: ROW or STATEMENT . VARCHAR comment A comment created by the COMMENT ON statement . VARCHAR tags A map of s... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- COPY Statement 7629
- 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
...(empty) DATA_PAGE_SIZE_LIMIT Target uncompressed size of Parquet data pages, in bytes. Pages may still be larger at vector granularity. UBIGINT 104857600 (100 MiB) DICTIONARY_SIZE_LIMIT The maximum size of the dictionary used for dictionary encoding, in num... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work