Results of 1 - 7 of about 7 for payload (0.002 sec.)
- WITH Clause 12650
- 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.
...algorithms into readable SQL code. Example: USING KEY This is a recursive CTE where USING KEY has a key column ( a ) and a payload column ( b ). The payload columns correspond to the columns to be overwritten. In the first iteration we have two differen...so generate the row (2, 3) , where 2 is a key that already exists from the previous iteration. This will overwrite the old payload 4 with the new payload 3 . WITH RECURSIVE tbl(a, b) USING KEY (a) AS ( SELECT a, b FROM (VALUES (1, 3), (2, 4)) t(a, b) UN...ION ALL SELECT a + 1, b FROM tbl WHERE a < 3 ) SELECT * FROM tbl; a b 1 3 2 3 3 3 Aggregate Payloads in USING KEY By default, each payload column (i.e., each column not listed in USING KEY ) uses last semantics: a new row... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
- Variant Functions 10305
- This section describes functions that operate on the VARIANT type . New Most variant_* functions were introduced in DuckDB 2.0. The variant_extract , variant_normalize and variant_typeof functions were already available in DuckDB 1.5. Name
..._* functions are useful for inspecting and filtering semi-structured data stored in a VARIANT column: CREATE TABLE events (payload VARIANT); INSERT INTO events VALUES ('{"user": {"id": 42, "tags": ["a", "b"]}}'::JSON::VARIANT); SELECT variant_type(paylo...ad), variant_keys(payload) FROM events; SELECT * FROM events WHERE variant_contains(payload, {'user': {'id': 42}}::VARIANT);... - https://man.mtool.work/duckdb/2.0/sql/functions/variant.html
- Indexes 9705
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...ation occurs if you meet the following conditions: A table has a FOREIGN KEY constraint. There is an UPDATE on a composite payload column (e.g., a LIST or a STRUCT ), the corresponding PRIMARY KEY table, which DuckDB rewrites into a DELETE followed by a...table. If these hold, you'll encounter an unexpected constraint violation: CREATE TABLE pk_table (id INTEGER PRIMARY KEY, payload VARCHAR[]); INSERT INTO pk_table VALUES (1, ['hello']); CREATE TABLE fk_table (id INTEGER REFERENCES pk_table(id)); INSERT...INTO fk_table VALUES (1); UPDATE pk_table SET payload = ['world'] WHERE id = 1; Constraint Error: Violates foreign key constraint because key "id: 1" is still referenced by a f... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
- Reference 8524
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...efault Description quack_target_batch_bytes UBIGINT 33554432 (32 MiB) Target in-memory size of one batch (one wire message payload). Batches are cut when they reach this size. quack_prepare_inline_rows UBIGINT 24576 Rows returned inline in the PREPARE r...BIGINT 268435456 (256 MiB) Server-side per-stream byte budget, at most a quarter of memory_limit . FETCH counts serialized payload bytes, INSERT counts decoded chunk allocations. 0 disables the limit. Server Connections Setting Type Default Description...requests in one ATTACH ). client_query_id Monotonic id assigned by the client, correlates client / server logs. query SQL payload for PREPARE_REQUEST s. server HTTP URL on client-side logs, NULL on server-side logs. duration_ms Round-trip time (client)... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Connect 7797
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...S lake (DATA_PATH 'lake_files/')"); stmt.execute("USE lake"); stmt.execute("CREATE TABLE IF NOT EXISTS events (id INTEGER, payload VARCHAR)"); stmt.execute("INSERT INTO events VALUES (1, 'hello'), (2, 'world')"); try (ResultSet rs = stmt.executeQuery("S...duckdb:ducklake:metadata.ducklake"); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT id, payload FROM events ORDER BY id")) { while (rs.next()) { System.out.println(rs.getInt(1) + " " + rs.getString(2)); } } The part af....duckdb' AS lake (TYPE ducklake, READ_ONLY)"); stmt.execute("USE lake"); try (ResultSet rs = stmt.executeQuery("SELECT id, payload FROM events ORDER BY id")) { while (rs.next()) { System.out.println(rs.getInt(1) + " " + rs.getString(2)); } } } A SQLite... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Schema 7361
- Types It is important to use the correct type for encoding columns (e.g., BIGINT , DATE , DATETIME ). While it is always possible to use string types ( VARCHAR , etc.) to encode more specific values, this is not recommended. Strings use mor
...olumns is approx. 1.8× faster than performing the same join on VARCHAR -typed columns encoding the same value. Join column payload type Join column schema type Example value Query time BIGINT BIGINT 70368755640078 1.2 s BIGINT VARCHAR '70368755640078' 2... - https://man.mtool.work/duckdb/2.0/guides/performance/schema.html
- Writing to Iceberg 7197
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
..._NS '2026-05-20 12:00:00.123456789'), (2, {'kind': 'view'}::VARIANT, TIMESTAMP_NS '2026-05-20 12:00:00.987654321') ) t(id, payload, event_time); Warning The GEOGRAPHY type is not yet supported in DuckDB-Iceberg. Limitations for UPDATE and DELETE The UPD... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work