Results of 1 - 10 of about 31 for produces (0.003 sec.)
- Profiling 13508
- 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
...tion The EXPLAIN [ANALYZE] statement allows exporting to several formats: text – default ASCII-art style output graphviz – produces a DOT output, which can be rendered with Graphviz html – produces an HTML output, which can be rendered with treeflex json...– produces a JSON output mermaid – produces a Mermaid flowchart web – opens the query graph in a web browser (command line client onl... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- GROUPING SETS 12149
- 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
...y used grouping sets. The ROLLUP clause will produce all “sub-groups” of a grouping set, e.g., ROLLUP (country, city, zip) produces the grouping sets (country, city, zip), (country, city), (country), () . This can be useful for producing different levels...of detail of a group by clause. This produces n+1 grouping sets where n is the amount of terms in the ROLLUP clause. CUBE produces grouping sets for all combinations of...zip) will produce (country, city, zip), (country, city), (country, zip), (city, zip), (country), (city), (zip), () . This produces 2^n grouping sets. Identifying Grouping Sets with GROUPING_ID() The super-aggregate rows generated by GROUPING SETS , ROLL... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/grouping_sets.html
- Pivot Internals 10499
- PIVOT Pivoting is implemented as a combination of SQL query re-writing and a dedicated PhysicalPivot operator for higher performance. Each PIVOT is implemented as set of aggregations into lists and then the dedicated PhysicalPivot operator
...on_sum) FROM ( SELECT country, name, year, sum(population) AS population_sum FROM cities GROUP BY ALL ) GROUP BY ALL; This produces the result: country name list("year") list(population_sum) NL Amsterdam [2000, 2010, 2020] [1005, 1065, 1158] US Seattle [...o build a list of text strings to populate month , and the double quotes to pull the column values for use in sales . This produces the same result as the initial example: empid dept month sales 1 electronics jan 1 1 electronics feb 2 1 electronics mar 3... - https://man.mtool.work/duckdb/2.0/internals/pivot.html
- Deploy as Native Image 10224
- Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits
...ne for your target platform explicitly. A wildcard matching all of them adds roughly 260 MB to the executable. This option produces a single self contained file, around 120 MB. The driver extracts the library to a temporary directory when the first conne...is anchored to the executable rather than the working directory, so the program runs correctly from anywhere. This option produces a small executable, under 20 MB for a simple application, with no extraction cost when connections open. The library can b... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
- What's New in the Docs for 2.0 9965
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...ng custom partition subdirectories The ORDER_BY copy option for sorting rows before writing Clients CLI agent mode , which produces compact, machine-readable output when the CLI is driven by an AI coding agent CLI command history : the .history command a...ed .schema output with --no-indent to restore the single-line form The Python appender for inserting rows that Python code produces Building A C++17 compiler is now required to build DuckDB... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Literal Types 9415
- DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEG
...as the VARCHAR strings 'b0101' and 'xCAFE' , respectively. A string literal prefixed with B is a bit string literal, which produces a BITSTRING value. It may only contain the characters 0 and 1 . A string literal prefixed with X is a hex string literal,...which produces a BLOB value. It must contain an even number of hexadecimal digits. SELECT B'0101' AS b, X'CAFE' AS x; ┌──────┬──────────┐... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Write User Defined Functions 9140
- Overview The Rust client can register user-defined functions written in Rust: scalar functions with the vscalar feature and table functions with the vtab feature. Both operate on DuckDB's columnar data chunks, so a single call processes a b
...eter() , returning read-only bind data. init runs once before execution and returns per-scan state, such as a cursor. func produces one chunk of rows per call. It fills the output vectors and sets the chunk length. A length of 0 ends the scan. DuckDB cal...n .duckdb_extension with a valid metadata footer. Start from the official extension-template-rs template, whose make debug produces a .duckdb_extension that loads with duckdb -unsigned . Further Reading Handle Results — the built-in ArrowVTab table funct... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- Agent Mode 8315
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- Map Type 8040
- MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies p
...vel, NULL nested values obey standard SQL NULL comparison rules: comparing a NULL nested value to a non- NULL nested value produces a NULL result. Comparing nested value members , however, uses the internal nested value rules for NULL s, and a NULL neste... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- Troubleshoot 7765
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
...g with DuckDB 2.0, the bundle-library Makefile target and the merged libduckdb_bundle.a archive no longer exist: the build produces libduckdb_static.a plus one static archive per extension (e.g., libparquet_extension.a ), and statically linked extensions... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
DuckDB 2.0 Documentation / man.mtool.work