Results of 1 - 10 of about 35 for produce (0.001 sec.)
- Non-Deterministic Behavior 12348
- Several operators in DuckDB exhibit non-deterministic behavior. Most notably, SQL uses set semantics, which allows results to be returned in a different order. DuckDB exploits this to improve performance, particularly when performing multi-
...B] and [B, A] are valid results. Floating-Point Aggregate Operations with Multi-Threading Floating-point inaccuracies may produce different results when run in multi-threaded configurations: For example, stddev and corr may produce non-deterministic re... - https://man.mtool.work/duckdb/2.0/operations_manual/non-deterministic_behavior.h...
- Release Cycle 11966
- This document outlines the DuckDB and core extension release cycle framework. It is intended for developers working on DuckDB extensions to better understand the underlying processes. Overview DuckDB follows Semantic Versioning ( v<MAJOR>.<
...ranches. We briefly go over them here. vx.y.z : The latest stable release vx.y-codename : The name of the branch that will produce vx.y.<n> releases vx.<y+1>-codename : The branch name that is used for the branch that will produce the next minor release...nch can mean various things, but can generally be considered the catch-all branch vx.y-codename branch: the branch used to produce all vx.y.z releases vx.y.z tag: a stable release of DuckDB. These tags are write-only and will always be tied to the same...vx.<y+1>.0 minor release. At the start of this phase, the vx.<y+1>-codename branch is created. This branch will be used to produce the upcoming minor release and is the branch from which all subsequent vx.<y+1>.<n> patch releases are released. PRs into... - https://man.mtool.work/duckdb/2.0/dev/release_cycle.html
- GROUPING SETS 11568
- 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
...oup by nothing: SELECT NULL AS course, NULL AS type, count(*) FROM students; CUBE and ROLLUP are syntactic sugar to easily produce commonly used grouping sets. The ROLLUP clause will produce all “sub-groups” of a grouping set, e.g., ROLLUP (country, cit...y, zip) produces the grouping sets (country, city, zip), (country, city), (country), () . This can be useful for producing different level...s 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 o... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/grouping_sets.html
- Python Function API 11186
- You can create a DuckDB user-defined function (UDF) from a Python function so it can be used in SQL queries. Similarly to regular functions , they need to have a name, a return type and parameter types. Creating Functions To register a Pyth
...return NULL , by setting this parameter to 'return_null' . side_effects (optional): By default, functions are expected to produce the same result for the same input. If the result of a function is impacted by any type of randomness, side_effects must b...as KeyboardInterrupt . Side Effects By default DuckDB will assume the created function is a pure function, meaning it will produce the same output when given the same input. If your function does not follow that rule, for example when your function make...s use of randomness, then you will need to mark this function as having side_effects . For example, this function will produce a new count for every invocation. def count() -> int: old = count.counter; count.counter += 1 return old count.counter = 0... - https://man.mtool.work/duckdb/2.0/clients/python/function.html
- TPC-DS Extension 8847
- New In DuckDB 2.0, the dsdgen data generator was updated to match the TPC-DS version 4 tools. As a result, the generated data differs slightly from the data generated by DuckDB v1.x. See the related PR for more details. The tpcds extension
...es, run: FROM tpcds_queries(); This function returns a table with columns query_nr and query . Listing Expected Answers To produce the expected results for all queries on scale factors 1 and 10, run the following (note that in DuckDB 2.0.0 this fails wi... - https://man.mtool.work/duckdb/2.0/core_extensions/tpcds.html
- Reading Faulty CSV Files 8847
- CSV files can come in all shapes and forms, with some presenting many errors that make the process of cleanly reading them inherently difficult. To help users read these files, DuckDB supports detailed error messages, the ability to skip fa
...lt is set to 2,000,000 bytes. Assuming our scanner is set to max_line_size = 25 , the line Pedro Holanda, 01-01-1992 would produce an error, as it exceeds 25 bytes. INVALID ENCODING : DuckDB supports UTF-8 strings, UTF-16 and Latin-1 encodings. Lines co...ntaining other characters will produce an error. For example, the line pedro\xff\xff, 01-01-1992 would be problematic. Anatomy of a CSV Error By default, when pe...M csv_line The original CSV line, truncated to rejects_line_size_limit characters. VARCHAR error_message The error message produced by DuckDB. VARCHAR Parameters The parameters listed below are used in the read_csv function to configure the CSV Rejects... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- EXPLAIN: Inspect Query Plans 8847
- EXPLAIN SELECT * FROM tbl; The EXPLAIN statement displays the physical plan, i.e., the query plan that will get executed, and is enabled by prepending the query with EXPLAIN . The physical plan is a tree of operators that are executed in a
...specific order to produce the result of the query. To generate an efficient physical plan, the query optimizer transforms the existing physical plan... - https://man.mtool.work/duckdb/2.0/guides/meta/explain.html
- TPC-H Extension 8465
- 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
...ies, run: FROM tpch_queries(); This function returns a table with columns query_nr and query . Listing Expected Answers To produce the expected results for all queries on scale factors 0.01, 0.1 and 1, run: FROM tpch_answers(); This function returns a t... - https://man.mtool.work/duckdb/2.0/core_extensions/tpch.html
- Hive Partitioning 8465
- Examples Read data from a Hive partitioned dataset: SELECT * FROM read_parquet('orders/*/*/*.parquet', hive_partitioning = true); Write a table to a Hive partitioned dataset: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, mont
...h)); Note that the PARTITION_BY options cannot use expressions. You can produce columns on the fly using the following syntax: COPY (SELECT *, year(timestamp) AS year, month(timestamp) AS month FROM ser... - https://man.mtool.work/duckdb/2.0/data/partitioning/hive_partitioning.html
- Android 8465
- DuckDB has experimental support for Android. Please use the latest main branch of DuckDB instead of the stable versions. Building the DuckDB Library Using the Android NDK We provide build instructions for setups using macOS and Android Stud
...lchain.cmake \ -DCMAKE_BUILD_TYPE=Release ../.. cmake \ --build . \ --config Release For the arm64-v8a ABI, the build will produce the build/android_arm64-v8a/duckdb and build/android_arm64-v8a/src/libduckdb.so binaries. Building the CLI in Termux To bu... - https://man.mtool.work/duckdb/2.0/dev/building/android.html
DuckDB 2.0 Documentation / man.mtool.work