Results of 1 - 10 of about 20 for actual (0.001 sec.)
- Avro Extension 12507
- The avro extension enables DuckDB to read Apache Avro files. The avro extension was released as a community extension in late 2024 and became a core extension in early 2025. The read_avro Function The extension adds a single DuckDB function
...read_avro('some_file_*.avro', filename=true); This will result in an additional column in the result set that contains the actual filename of the Avro file. Schema Conversion This extension automatically translates the Avro Schema to the DuckDB schema....ems, Avro does not treat NULL as a possible value in a range of e.g. INTEGER but instead represents NULL as a union of the actual type with a special NULL type. This is different to DuckDB, where any value can be NULL . Of course DuckDB also supports U... - https://man.mtool.work/duckdb/2.0/core_extensions/avro.html
- CREATE MACRO Statement 10808
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...e, followed by parentheses. A comma-separated list of value-expressions may appear between the parentheses - these are the actual parameters. The DuckDB binder examines the data types of the actual parameters and tries to find an implementation of the...he value expression is passed; In contrast to positional parameter passing, named parameter passing explicitly assigns the actual parameter value to a specific formal parameter. This is done by mentioning the parameter name followed by the assignment o... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Profiling Queries 10808
- DuckDB supports profiling queries via the EXPLAIN and EXPLAIN ANALYZE statements. EXPLAIN To see the query plan of a query without executing it, run: EXPLAIN ⟨query⟩; The output of EXPLAIN contains the estimated cardinalities for each opera
...LAIN ANALYZE To profile a query, run: EXPLAIN ANALYZE ⟨query⟩; The EXPLAIN ANALYZE statement runs the query, and shows the actual cardinalities for each operator, as well as the cumulative wall-clock time spent in each operator.... - https://man.mtool.work/duckdb/2.0/sql/statements/profiling.html
- Blob Type 10383
- Name Aliases Description BLOB BYTEA , BINARY , VARBINARY Variable-length binary data The blob ( B inary L arge OB ject) type represents an arbitrary binary object stored in the database system. The blob type can contain any type of binary d
...ata with no restrictions. What the actual bytes represent is opaque to the database system. Create a BLOB value with a single byte (170): SELECT '\xAA'::BLOB; Creat... - https://man.mtool.work/duckdb/2.0/sql/data_types/blob.html
- GROUPING SETS 9958
- GROUPING SETS , ROLLUP and CUBE can be used in the GROUP BY clause to perform a grouping over multiple dimensions within the same query. Note that this syntax is not compatible with GROUP BY ALL . Examples Compute the average income along t
...-values returned for the respective column in the grouping. But if the columns used in the grouping can themselves contain actual NULL -values, then it can be challenging to distinguish whether the value in the resultset is a “real” NULL -value coming...ote that the number of expressions passed to GROUPING_ID() , or the order in which they are passed is independent from the actual group definitions appearing in the GROUPING SETS -clause (or the groups implied by ROLLUP and CUBE ). As long as the expre... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/grouping_sets.html
- EXPLAIN ANALYZE: Profile Queries 9533
- Prepending a query with EXPLAIN ANALYZE both pretty-prints the query plan, and executes it, providing run-time performance numbers and the actual cardinality (number of rows produced) for every operator. EXPLAIN ANALYZE SELECT * FROM tbl; N
... - https://man.mtool.work/duckdb/2.0/guides/meta/explain_analyze.html
- Overview of DuckDB Internals 9108
- Tip For a detailed explanation of DuckDB internals, see the Design and Implementation of DuckDB Internals ("DiDi") library entry. On this page is a brief description of the internals of the DuckDB engine. Parser The parser converts a query
...Expression Logical Planner The logical planner creates LogicalOperator nodes from the bound statements. In this phase, the actual logical query tree is created. Optimizer After the logical planner has created the logical query tree, the optimizers are... - https://man.mtool.work/duckdb/2.0/internals/overview.html
- HTTP(S) Support 8683
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
..., it can use a combination of the Parquet metadata and HTTP range requests to only download the parts of the file that are actually required by the query. For example, the following query will only read the Parquet metadata and the data for the column_...a column: SELECT column_a FROM 'https://domain.tld/file.parquet'; In some cases, no actual data needs to be read at all as they only require reading the metadata: SELECT count(*) FROM 'https://domain.tld/file.parq... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- Profiling 8258
- Profiling is essential to help understand why certain queries exhibit specific performance characteristics. DuckDB contains several built-in features to enable query profiling, which this page covers. For a high-level example of using EXPLA
...E statement enables obtaining these, as it pretty-prints the query plan and also executes the query. Thus, it provides the actual run-time performance numbers. The FORMAT Option The EXPLAIN [ANALYZE] statement allows exporting to several formats: text... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- Vectors 7834
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...4967295 uint32_t The duckdb_enum_internal_type can be used to obtain the internal type of the enum. In order to obtain the actual string value of the enum, the duckdb_enum_dictionary_value function must be used to obtain the enum value that corresponds...gth of the selection vector starting from index 0 src_offset : The offset in the selection vector to copy from (important: actual number of items copied = src_count - src_offset). dst_offset : The offset in the dst vector to start copying to. duckdb_ve... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
DuckDB 2.0 Documentation / man.mtool.work