Results of 1 - 8 of about 8 for Recursive (0.016 sec.)
- WITH Clause – DuckDB 13013
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Query Syntax Copy Markdown WITH Clause 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-o...ther and can be nested. Recursive CTEs can reference themselves. Basic CTE Examples Create a CTE called cte and use it in the main query: WITH cte AS ( SELE...ion, use NOT MATERIALIZED : WITH t ( x ) AS NOT MATERIALIZED ( complex_query ) SELECT * FROM t AS t1 , t AS t2 , t AS t3 ; Recursive CTEs WITH RECURSIVE allows the definition of CTEs which can refer to themselves. Note that the query must be formulated in... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/with.html
- Unnesting – DuckDB 11061
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...SELECT unnest ([ 1 , 2 , 3 ]); Unnesting a struct, generating two columns (a, b): SELECT unnest ({ 'a' : 42 , 'b' : 84 }); Recursive unnest of a list of structs: SELECT unnest ([{ 'a' : 42 , 'b' : 84 }, { 'a' : 100 , 'b' : NULL }], recursive : = true ); L...imit depth of recursive unnest using max_depth : SELECT unnest ([[[ 1 , 2 ], [ 3 , 4 ]], [[ 5 , 6 ], [ 7 , 8 , 9 ], []], [[ 10 , 11 ]]], max_depth...one level. The function can be used as a regular scalar function, but only in the SELECT clause. Invoking unnest with the recursive parameter will unnest lists and structs of multiple levels. The depth of unnesting can be limited using the max_depth para... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/unnest.html
- CREATE MACRO Statement – DuckDB 8296
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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...Examples Scalar Macros Table Macros Overloading Syntax Limitations Using Named Parameters Using Subquery Macros Overloads Recursive Functions... - https://man.mtool.work/duckdb/1.3/sql/statements/create_macro.html
- Avro Extension – DuckDB 8187
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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/1.3/core_extensions/avro.html
- Appender – DuckDB 7970
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ze the appender Appender appender ( con , "people" ); 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, as follows: appender . AppendRow (... - https://man.mtool.work/duckdb/1.3/data/appender.html
- Keywords and Identifiers – DuckDB 7934
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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 Database Names Database names are subject to the rules for identifiers . Additionally, it is... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- Spatial Functions – DuckDB 7880
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...e dimension will be ignored. If the input geometry contains nested GeometryCollections, their geometries will be extracted recursively and included into the final multi geometry as well. If the input geometry is not a GeometryCollection, the function will...tion Dumps a geometry into a list of sub-geometries and their "path" in the original geometry. You can use the UNNEST(res, recursive := true) function to explode resulting list of structs into multiple rows. Example select st_dump ( 'MULTIPOINT(1 2,3 4)'...'path' : [ 0 ]}, { 'geom' : 'POINT(3 4)' , 'path' : [ 1 ]}] select unnest ( st_dump ( 'MULTIPOINT(1 2,3 4)' :: geometry ), recursive : = true ); -- ┌─────────────┬─────────┐ -- │ geom │ path │ -- │ geometry │ int32[] │ -- ├─────────────┼─────────┤ -- │ PO... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- R-Tree Indexes – DuckDB 7880
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...r, when the R-tree index is created on an already populated table, a special bottom up "bulk loading algorithm" (Sort-Tile-Recursive) is used, which divides all entries into an already balanced tree as the total number of required nodes can be computed fr... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work