Results of 1 - 10 of about 13 for recursive (0.002 sec.)
- WITH Clause 13794
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
...er parts of the query depend on the modification having already run, so that it is not inlined or executed more than once. Recursive CTEs WITH RECURSIVE allows the definition of CTEs which can refer to themselves. Note that the query must be formulated in...a way that ensures termination, otherwise, it may run into an infinite loop. Example: Fibonacci Sequence WITH RECURSIVE can be used to make recursive calculations. For example, here is how WITH RECURSIVE could be used to calculate the first t...en Fibonacci numbers: WITH RECURSIVE FibonacciNumbers ( RecursionDepth, FibonacciNumber, NextNumber ) AS ( -- Base case SELECT 0 AS RecursionDepth, 0 AS Fibona... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
- Unnesting 11753
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...to the unnest() function. The unnest() function has a number of optional additional arguments to control the behavior for recursive unnesting . The unnest function can be called in the SELECT -clause as if it is a scalar function. The unnest function may.... Calls to unnest() in a FROM -clause or CALL -statement do not accept additional parameters, and can thus not be used for recursive unnesting . Recursive Unnesting By default, unnest() only unpacks the outermost components of the composite-type value. Ad...sed to allow the unnesting operation to be applied to the unnested member values, and to their unnested values, and so on, recursively. These additional parameters are: recursive : BOOLEAN , default: false . Pass true to recursively continue applying unne... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- Python 8498
- The DuckDB Python package has its own repository at duckdb/duckdb-python and uses nanobind 3 to create Python bindings with DuckDB. Prerequisites This guide assumes: You have a full clone of the DuckDB Python package source, including its g
...ub.com/duckdb/duckdb-python.git git fetch --all If you've already cloned without submodules: git submodule update --init --recursive git remote add upstream https://github.com/duckdb/duckdb-python.git git fetch --all Important notes: * DuckDB is vendored...use pre-commit run --all-files . You can also install a post-checkout hook that always runs git submodule update --init --recursive . When you change branches between main and a bugfix branch, this makes sure the duckdb submodule is always correctly init...build fails with RuntimeError: Duckdb submodule not initialized , initialize the submodule: git submodule update --init --recursive... - https://man.mtool.work/duckdb/2.0/dev/building/python.html
- Avro Extension 8445
- 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
...This extension automatically translates the Avro Schema to the DuckDB schema. All Avro types can be translated, except for recursive type definitions , which DuckDB does not support. The type mapping is very straightforward except for Avro's "unique" way...s with the Avro library dependency (sigh again). We plan to fix this eventually. As mentioned above, DuckDB cannot express recursive type definitions that Avro has, this is unlikely to ever change. There is no support to allow users to provide a separate... - https://man.mtool.work/duckdb/2.0/core_extensions/avro.html
- What's New in the Docs for 2.0 8357
- 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
...iguration settings Faster Queries Across the Board DuckDB 2.0 included optimizer and engine improvements, including faster recursive CTEs and better row-group pruning. Recursive CTEs and the blog post on how DuckDB runs them faster Min-max indexes (zonema... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- CREATE MACRO Statement 8076
- 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
...set at creation, it is not possible to define a macro by the same name twice without first removing the first definition. Recursive Functions Defining recursive functions is not supported. For example, the following macro – supposed to compute the n th n... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Appender 7988
- The Appender can be used to load bulk data into a DuckDB database. It is available in the C, C++, Go, Java, Julia, Node.js, Python, and Rust clients. This page describes how the Appender behaves across clients and shows a minimal example in
...into a table with an integer and a string column. C++ The AppendRow function is the easiest way of appending data. It uses recursive templates to allow you to put all the values of a single row within one function call: DuckDB db; Connection con(db); con.... - https://man.mtool.work/duckdb/2.0/data/appender.html
- Configuration 7935
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
..._operator_semantics Configures whether regex match operators use partial or full string matching. VARCHAR partial s3_allow_recursive_globbing Whether globs on S3-like storage are optimized with recursive strategy (alternative is listing) BOOLEAN true s3_e... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Keywords and Identifiers 7935
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
...⟨name⟩_⟨count⟩ , where ⟨count⟩ starts at 1. For example: SELECT * FROM (SELECT unnest({'a': 42, 'b': {'a': 88, 'b': 99}}, recursive := true)); a a_1 b 42 88 99 Identifier Resolution Identifiers can be qualified to remove ambiguity. A fully qualified colu... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- S3 API Support 7900
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...d in the configuration reference , including enable_global_s3_configuration , merge_http_secret_into_s3_request , s3_allow_recursive_globbing , httpfs_enable_credential_refresh , s3_version_id_pinning , and unsafe_disable_etag_checks .... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
DuckDB 2.0 Documentation / man.mtool.work