Results of 1 - 10 of about 40 for Fields (0.003 sec.)
- Full-Text Search Extension 12747
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
...d VARCHAR Column name of document identifier, e.g., 'document_identifier' input_values... VARCHAR Column names of the text fields to be indexed (vararg), e.g., 'text_field_1' , 'text_field_2' , ..., 'text_field_N' , or '\*' for all columns in input_tab...lified name of input table, e.g., 'table_name' or 'main.table_name' match_bm25 Function match_bm25(input_id, query_string, fields := NULL, k := 1.2, b := 0.75, conjunctive := 0) When an index is built, this retrieval macro is created that can be used t...AR Column name of document identifier, e.g., 'document_identifier' query_string VARCHAR The string to search the index for fields VARCHAR Comma-separated list of fields to search in, e.g., 'text_field_2, text_field_N' . Defaults to NULL to search all i... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Typecasting 11701
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...least one field. The rationale behind this requirement is to help avoid unintended errors. If two structs do not have any fields in common, then the cast was likely not intended. SELECT CAST({'a': 42} AS STRUCT(a VARCHAR)); Fields that exist in the ta...uct, but that do not exist in the source struct, default to NULL . SELECT CAST({'a': 42} AS STRUCT(a VARCHAR, b VARCHAR)); Fields that only exist in the source struct are ignored. SELECT CAST({'a': 42, 'b': 43} AS STRUCT(a VARCHAR)); The names of the s...truct can also be in a different order. The fields of the struct will be reshuffled based on the names of the structs. SELECT CAST({'a': 42, 'b': 84} AS STRUCT(b VARCHAR, a... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- Struct Functions 11342
- The functions on this page work on STRUCT values . Functions that access entries by position, such as struct[idx] , struct_extract_at , struct_contains , struct_position and struct_values , also accept TUPLE values , i.e., structs with unna
..., defaults) Remap a STRUCT , LIST , or MAP value into the shape given by the type of target_type , renaming and reordering fields, descending into nested types, and filling missing fields from defaults . row(any, ...) Create a TUPLE containing the argu...an input value of type STRUCT , LIST , or MAP into the shape declared by the type of target_type , renaming and reordering fields, descending into nested types, and filling target fields that have no source counterpart from defaults . Only the type of...eld name whose values name the source field to read from; defaults is a STRUCT of constant values for the remaining target fields. Every target field must be covered by either mapping or defaults . | | Example | remap_struct({'i': 1, 'j': 2}, NULL::STR... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Caveats 10827
- Equality Comparison Warning Currently, equality comparison of JSON files can differ based on the context. In some cases, it is based on raw text comparison, while in other cases, it uses logical content comparison. The following query retur
...ns true for all fields: SELECT a != b, -- Space is part of physical JSON content. Despite equal logical content, values are treated as not equal....c != d, -- Same. c[0] = d[0], -- Equality because space was removed from physical content of fields: a = c[0], -- Indeed, field is equal to empty list without space... b != c[0], -- ... but different from empty list with s... - https://man.mtool.work/duckdb/2.0/data/json/caveats.html
- Variant Type 10484
- 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
...4 │ {'age': 30, 'name': Alice} │ OBJECT(age, name) │ └───────┴────────────────────────────┴───────────────────┘ Extracting Fields from Nested Variants Fields can be extracted from nested VARIANT values using dot notation or the variant_extract function...uckDB database file, DuckDB 2.0 automatically detects the common structure of the values and shreds them, i.e., stores the fields that share a type as separate, typed columns. Shredded data compresses well and can be scanned efficiently. Shredding is o... - https://man.mtool.work/duckdb/2.0/sql/data_types/variant.html
- Avro Extension 8908
- 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
...also becomes a DuckDB INTEGER . The extension also "flattens" the Avro schema. Avro defines tables as root-level "record" fields, which are the same as DuckDB STRUCT fields. For more convenient handling, this extension turns the entries of a single to... - https://man.mtool.work/duckdb/2.0/core_extensions/avro.html
- Array Type 8908
- An ARRAY column stores fixed-sized arrays. All fields in the column must have the same length and the same underlying type. Arrays are typically used to store arrays of numbers, but can contain any uniform data type, including ARRAY , LIST
...ee the data types overview for a comparison between nested data types. The ARRAY type in PostgreSQL allows variable-length fields. DuckDB's ARRAY type is fixed-length. Creating Arrays Arrays can be created using the array_value(expr, ...) function . Co... - https://man.mtool.work/duckdb/2.0/sql/data_types/array.html
- Run Queries 8565
- 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
...); Object[] values = (Object[]) list.getArray(); DuckDBStruct struct = (DuckDBStruct) rs.getObject(2); Map<String, Object> fields = struct.getMap(); } } The DuckDB result set also exposes typed accessors as extensions to the JDBC API, including getArra...int) , getStruct(int) , getUuid(int) , getHugeint(int) , and getJsonObject(int) . DuckDBStruct.getMap() returns the struct fields keyed by name. DuckDBArray.getResultSet() exposes the list elements as an org.duckdb.DuckDBArrayResultSet , a read-only Re...ry types from STRUCT and LIST types, so they are bound with the same factory methods. A POINT_2D is a struct of two DOUBLE fields, and a LINESTRING is a list of such points. After loading the extension, build the value with createStruct() (or createArr... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- Python Client API 8393
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...function rollback ( self ) → _duckdb.DuckDBPyConnection Roll back changes performed within a transaction row_type ( self , fields : object ) → _duckdb._sqltypes.DuckDBPyType Create a struct type object from ‘fields' property rowcount Get result set row...llation : str = '' ) → _duckdb._sqltypes.DuckDBPyType Create a string type with an optional collation struct_type ( self , fields : object ) → _duckdb._sqltypes.DuckDBPyType Create a struct type object from ‘fields' table ( table_name : str ) → DuckDBP...: path, value. SQL: json_set . strip_nulls ( * args : ValueOrExpr ) → JsonExpr The document without its null-valued object fields. SQL: json_strip_nulls . structure ( * args : ValueOrExpr ) → JsonExpr The shape of the document, with types in place of v... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Types API 8393
- The DuckDBPyType class, duckdb.sqltypes.DuckDBPyType , represents one of the data types . Use DuckDBPyType to describe SQL types when declaring function parameters, return types or casts. Python types such as int are accepted too: int descr
...type Parameters: type: DuckDBPyType array_type Parameters: type: DuckDBPyType size: int struct_type | row_type Parameters: fields: Union[list[DuckDBPyType], dict[str, DuckDBPyType]] A list names the fields v1 , v2 and so on. An empty dict or list gives... - https://man.mtool.work/duckdb/2.0/clients/python/types.html
DuckDB 2.0 Documentation / man.mtool.work