Results of 1 - 10 of about 28 for variant (0.002 sec.)
- Variant Functions 14469
- 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
...Description variant_typeof(v) Return the full type of a VARIANT value, including nested structure. variant_type(v) Return the top-level type c...ategory of a VARIANT value. variant_keys(v) Return the keys of a VARIANT object as a list. variant_extract(v, field) Extract a nested value by...object field name or list index. Returns a VARIANT . variant_extract_string(v, field) Extract a nested value as a VARCHAR . variant_array_length(v) Return the number of elem... - https://man.mtool.work/duckdb/2.0/sql/functions/variant.html
- Variant Type 13027
- The VARIANT type stores typed, binary data where each row is self-contained with its own type information. This differs from the JSON type , which is physically stored as text. Because type metadata is embedded per-value, VARIANT provides b
...etter compression and query performance than JSON for semi-structured data. The VARIANT type is inspired by Snowflake's semi-structured VARIANT data type . It is available in Parquet since 2025 and also support...ed by DuckDB's Parquet reader . Examples Storing Different Types in the Same Column A VARIANT column can hold values of different types across rows: CREATE TABLE events (id INTEGER, data VARIANT); INSERT INTO events...VALUES (1, 42::VARIANT), (2, 'hello world'::VARIANT), (3, [1, 2, 3]::VARIANT), (4, {'name': 'Alice', 'age': 30}::VARIANT); SELECT * FROM events;... - https://man.mtool.work/duckdb/2.0/sql/data_types/variant.html
- Nested Functions 9176
- The following nested data types have dedicated function pages ( TUPLE values are handled by the STRUCT functions): Name Type page Functions page ARRAY ARRAY type ARRAY functions LIST LIST type LIST functions MAP MAP type MAP functions STRUC
...T STRUCT type STRUCT functions UNION UNION type UNION functions VARIANT VARIANT type VARIANT functions... - https://man.mtool.work/duckdb/2.0/sql/functions/nested.html
- What's New in the Docs for 2.0 9143
- 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
...T statements CLI -serve and -connect arguments Securing Quack with a reverse proxy Remote pushdown to PostgreSQL and MySQL VARIANT Becomes a First-Class Citizen The VARIANT type stores semi-structured, schema-less data such as JSON while keeping the per...formance of columnar execution. A family of variant_* functions constructs and inspects variant values. Variant type Variant functions Triggers DuckDB 2.0 added trigger suppo...o you can run actions automatically in response to table changes. This is useful for building audit tables and enforcing invariants. CREATE TRIGGER statement SQL Dialect Additions DuckDB 2.0 extended the SQL dialect in several directions, from new join... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Delta Extension 8602
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...eeded. Values can be any constant expression except NULL . Some properties cannot be set at creation, such as 'delta.enableVariantShredding' . To create a table with column mapping , set 'delta.columnMapping.mode' to 'name' or 'id' . Appending Data To a...enient in DuckDB 1.5 to strict in v2.0. To read such files as v1.5 did, run SET delta_column_mapping_policy = 'lenient'; . VARIANT Columns Delta variant columns are read as DuckDB VARIANT , whether their files are shredded or not, and top-level VARIANT...columns can be appended to. New The following were introduced in DuckDB 2.0. A query that reads one field of a VARIANT or STRUCT column, such as SELECT v.a , reads only that field from the Parquet files, so on a shredded table it skips the c... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Unity Catalog Extension 8422
- The unity_catalog extension attaches a Unity Catalog catalog, on Databricks or Unity Catalog OSS, as a DuckDB database. You can list, read, insert into and create its Delta Lake tables. It uses the delta extension to access the tables. For
...ot read is listed with the type UNKNOWN , e.g., in DESCRIBE . Reading the table fails with an error that names the column. VARIANT Columns New Support for VARIANT columns was introduced in DuckDB 2.0. Unity Catalog's variant maps to VARIANT . VARIANT co...lumns can be read whether their files are shredded or not. Inserts write shredded variants if the table sets delta.enableVariantShredding . An INSERT into a table with a VARIANT inside a struct, list or map fails... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- S3 Express One 8291
- In late 2023, AWS announced the S3 Express One Zone , a high-speed variant of traditional S3 buckets. DuckDB can read S3 Express One buckets using the httpfs extension . Credentials and Configuration The configuration of S3 Express One buck
...File size Runtime Loading only from Parquet 4.1 GB 3.5 s Creating local table from Parquet 4.1 GB 5.1 s The “loading only” variant is running the load as part of an EXPLAIN ANALYZE statement to measure the runtime without actually creating a local table..., while the “creating local table” variant uses CREATE TABLE ... AS SELECT to create a persistent table on the local disk.... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_express_one.ht...
- Data Types 8291
- 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
...Nested / Composite Types DuckDB supports the following nested data types: ARRAY , LIST , MAP , STRUCT , TUPLE , UNION and VARIANT . Each supports different use cases and has a different structure. Name Description Rules when used in a column Build from...ember type. Rows may be set to different member types of the union. union_value(num := 2) UNION(num INTEGER, text VARCHAR) VARIANT A semi-structured type where each value is self-contained with its own type information. Each row may hold a value of a di...fferent type. 42::VARIANT VARIANT Rules for Case Sensitivity The keys of MAP s are case-sensitive, while keys of UNION s and STRUCT s are case-insen... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- Writing to Iceberg 7914
- 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.
...ize. Iceberg V3 Support DuckDB-Iceberg supports the following Iceberg v3 specification features for both reads and writes: VARIANT and TIMESTAMP_NS data types Schema-level default values for columns Binary deletion vectors Row lineage tracking The bigge...CREATE TABLE iceberg_catalog.default.v3_table WITH ('format-version' = 3) AS FROM (VALUES (1, {'kind': 'click', 'x': 10}::VARIANT, TIMESTAMP_NS '2026-05-20 12:00:00.123456789'), (2, {'kind': 'view'}::VARIANT, TIMESTAMP_NS '2026-05-20 12:00:00.987654321... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Utility Functions 7734
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...leep_ms(milliseconds) Pause execution for the specified number of milliseconds. Returns NULL . stats(expression) Returns a VARIANT with statistics about the expression. Expression can be a column, constant, or SQL expression. txid_current() Returns the...f milliseconds. Returns NULL . | | Example | sleep_ms(500) | | Result | NULL | stats(expression) | Description | Returns a VARIANT with statistics about the expression. Expression can be a column, constant, or SQL expression. | | Example | stats(5) | |...stop , incrementing by step . The stop parameter is inclusive, and the stop and step arguments are optional. See the list variant for the available argument combinations. | | Example | generate_series(2, 5) | | Result | 4 rows: 2, 3, 4, 5 | glob(search... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
DuckDB 2.0 Documentation / man.mtool.work