Results of 1 - 10 of about 15 for composite (0.002 sec.)
- Run Queries 13201
- Overview Because the Go client implements database/sql , queries run through the standard methods: Exec and ExecContext send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. Query , QueryCon
...f any reads each column into a driver.Value . Remember that a scanned value can be nil for a SQL NULL . Reading Nested and Composite Types DuckDB's nested types , such as LIST , STRUCT , and MAP , and its JSON type, are scanned through the generic duckdb....match the SQL shape, then read the decoded value with Get() : // A JSON (or LIST) value read into a slice. var arr duckdb.Composite[[]any] row := db.QueryRow(`SELECT json_array('foo', 'bar')`) if err := row.Scan(&arr); err != nil { log.Fatal(err) } log.P...rintf("first element: %s", arr.Get()[0]) // A JSON object (or STRUCT) value read into a map. var obj duckdb.Composite[map[string]any] row = db.QueryRow(`SELECT '{"family": "anatidae", "coolness": 42.42}'::JSON`) if err := row.Scan(&obj); er... - https://man.mtool.work/duckdb/2.0/clients/go/querying.html
- Run Queries 11668
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...ents to insert large amounts of data into DuckDB. See the data import documentation for better options. Reading Nested and Composite Types DuckDB supports nested and composite column types such as LIST , STRUCT , MAP , UNION , and ENUM . The JDBC driver m...ode json = (JsonNode) rs.getObject(1); if (json.isArray()) { System.out.println(json); // [1, 2, 3] } } Binding Nested and Composite Parameters To bind a LIST / ARRAY , STRUCT , or MAP value as a prepared-statement parameter, build it from the Connection... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- WHERE Clause 10136
- The WHERE clause specifies any filters to apply to the data. This allows you to select only a subset of the data in which you are interested. Logically the WHERE clause is applied immediately after the FROM clause. Examples Select all rows
...sion formulated with the ILIKE operator: SELECT * FROM tbl WHERE name ILIKE '%mark%'; Select all rows that match the given composite expression: SELECT * FROM tbl WHERE id = 3 OR id = 7; Syntax... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/where.html
- Run Queries 9526
- Overview A Connection runs SQL through two families of methods: The execute_* methods ( execute() and execute_batch() ) send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. The query_* meth
..._from(row) })?; query_row_and_then() is the counterpart for a closure that returns a custom error type. Reading Nested and Composite Types DuckDB's nested and composite types are read through the Value enum, which row.get() returns when the target type is... - https://man.mtool.work/duckdb/2.0/clients/rust/querying.html
- Unnesting 8917
- 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
...ot be used for recursive unnesting . Recursive Unnesting By default, unnest() only unpacks the outermost components of the composite-type value. Additional parameters may be passed to allow the unnesting operation to be applied to the unnested member valu... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- CREATE TABLE Statement 8917
- The CREATE TABLE statement creates a table in the catalog. Examples Create a table with two integer columns ( i and j ): CREATE TABLE t1 (i INTEGER, j INTEGER); Create a table with a primary key: CREATE TABLE t1 (id INTEGER PRIMARY KEY, j V
...ARCHAR); Create a table with a composite primary key: CREATE TABLE t1 (id INTEGER, j VARCHAR, PRIMARY KEY (id, j)); Create a table with various different types, co...Violates foreign key constraint because key "id: 2" does not exist in the referenced table Foreign keys can be defined on composite primary keys: CREATE TABLE t3 (id INTEGER, j VARCHAR, PRIMARY KEY (id, j)); CREATE TABLE t4 ( id INTEGER PRIMARY KEY, t3_i... - https://man.mtool.work/duckdb/2.0/sql/statements/create_table.html
- IN Operator 8620
- The IN operator checks containment of the left expression inside the collection on the right hand side (RHS). Supported collections on the RHS are tuples, lists, and maps, as well as subqueries that return a single column. The single-column
...restriction applies only to subqueries; tuples, lists, and maps may themselves contain composite values. IN (val1, val2, ...) (Tuple) The IN operator on a tuple (val1, val2, ...) returns true if the expression is presen... - https://man.mtool.work/duckdb/2.0/sql/expressions/in.html
- Troubleshoot 7697
- 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 v2, scanning a JSON value directly into a string or []byte is no longer supported. Scan into any or into the duckdb.Composite wrapper instead, as shown in Run Queries . If a plain string or byte result is needed and the JSON structure is not, cast... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
- Handle Results 7697
- Overview Beyond the standard JDBC ResultSet , the DuckDB driver can hand results to Apache Arrow , stream large results instead of materializing them, and expose raw columnar data chunks. This page covers each of these result-handling optio
...ching the C API and the user-defined function interfaces. The chunked result API currently supports basic data types only. Composite types such as LIST and STRUCT are not yet readable through this interface. The query() method is available on prepared sta... - https://man.mtool.work/duckdb/2.0/clients/java/result_handling.html
- Data Types 7697
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...tring Implicit and explicit typecasting is possible between numerous types, see the Typecasting page for details. Nested / Composite Types DuckDB supports the following nested data types: ARRAY , LIST , MAP , STRUCT , TUPLE , UNION and VARIANT . Each supp... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
DuckDB 2.0 Documentation / man.mtool.work