Results of 1 - 10 of about 20 for mapping (0.002 sec.)
- Struct Functions 12745
- 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
...tation that serves as an alias for struct_extract from TUPLE s, using an index (1-based). remap_struct(input, target_type, mapping, defaults) Remap a STRUCT , LIST , or MAP value into the shape given by the type of target_type , renaming and reordering...from TUPLE s, using an index (1-based). | | Example | (row(42, 84))[1] | | Result | 42 | remap_struct(input, target_type, mapping, defaults) | Description | Remap an input value of type STRUCT , LIST , or MAP into the shape declared by the type of targ...al (e.g. NULL::STRUCT(v1 INT, v2 INT) ) is a convenient way to declare the target shape when no suitable value is at hand. mapping is a STRUCT keyed by target field name whose values name the source field to read from; defaults is a STRUCT of constant v... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Delta Extension 12201
- 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
...t 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 append rows to a Delta table, attach it and use INS..._domain_metadata('file:///⟨path⟩'); For an attached table, duckdb_tables() shows the same pairs in its tags column. Column Mapping Delta tables with column mapping enabled are read as the Delta protocol specifies for each mode: in id mode, columns are m...to carry Parquet field IDs, but some writers omit them, including DuckDB 1.5.5 and earlier. Since v1.5.6, the delta_column_mapping_policy setting decides how such files are read: strict : fail with an error that names the file. lenient : match the file'... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- S3 Express One 10943
- 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
..., ensure the EC2 instance is in the same availability zone as the S3 Express One bucket you are querying. To determine the mapping between zone names and zone IDs, use the aws ec2 describe-availability-zones command. Zone name to zone ID mapping: bash a...put json \ | jq -r '.AvailabilityZones[] | select(.ZoneName == "us-east-1f") | .ZoneId' text use1-az5 Zone ID to zone name mapping: bash aws ec2 describe-availability-zones --output json \ | jq -r '.AvailabilityZones[] | select(.ZoneId == "use1-az5") |... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_express_one.ht...
- Go Client 10111
- The latest stable release of the DuckDB Go client bundles DuckDB 2.0.0. Its own version tag encodes that DuckDB version; see Versioning below. The DuckDB Go client, duckdb-go , is a SQL driver that conforms to Go's built-in database/sql int
...ded to two digits: DuckDB 1.5.0 maps to duckdb-go v2.10500.x, and DuckDB 2.0.0 maps to v2.20000.0. The README has the full mapping table for earlier releases. The DuckDB 1.4 Andium LTS release line is published as its own tags, which still follow the cl...ewrite the import paths. gofmt -w -r '"github.com/marcboeker/go-duckdb/v2" -> "github.com/duckdb/duckdb-go/v2"' . # If the mapping or arrowmapping submodules are used, also run: gofmt -w -r '"github.com/marcboeker/go-duckdb/mapping" -> "github.com/duckd...b/duckdb-go/v2/mapping"' . gofmt -w -r '"github.com/marcboeker/go-duckdb/arrowmapping" -> "github.com/duckdb/duckdb-go/v2/arrowmapping"' . # Clea... - https://man.mtool.work/duckdb/2.0/clients/go/overview.html
- Write User Defined Functions 9822
- Overview The JDBC driver can register user-defined functions (UDFs) written in Java, including scalar functions and table functions. This page covers building and registering both, from the simple functional-interface overloads to the vecto
...rized interface, along with type mapping and the function registry. Scalar Functions Build a scalar function with the DuckDBFunctions.scalarFunction() builder — wh...mnIndex(position) maps each projected position back to the column index used in bind and in the output vectors. Store this mapping in the init state and consult it in apply . .withProjectionPushdown() .withFunction(new DuckDBTableFunction<Void, long[],...rojected[i] = info.getColumnIndex(i); } return projected; } // ... apply() writes only the columns listed in the projected mapping ... }) Without withProjectionPushdown() , getColumnCount() reports every declared column and the function must populate al... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- Types API 8717
- 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
...DuckDBPyType is expected, any of the options listed below can be given instead. Python Built-Ins The table below shows the mapping of Python Built-in types to DuckDB type. Built-in types DuckDB type bool BOOLEAN bytearray BLOB bytes BLOB float DOUBLE in...t BIGINT str VARCHAR NumPy Scalar Types The table below shows the mapping of NumPy scalar types to DuckDB type. A NumPy dtype object does not convert: DuckDBPyType(numpy.dtype("int32")) raises a N... - https://man.mtool.work/duckdb/2.0/clients/python/types.html
- Rust Client 8581
- Installation To use the DuckDB Rust client, visit the Rust installation page . The latest stable version of the DuckDB Rust client is 2.0.0. The DuckDB Rust client, duckdb-rs , is an ergonomic wrapper over the DuckDB C API that exposes an i
...r a database file. Queries are sent with execute() and execute_batch() , and results are read by preparing a statement and mapping each row to a Rust value with query_map() : use duckdb::{params, Connection, Result}; #[derive(Debug)] struct Person { id:...nfig options, connection pooling, and thread safety. Run Queries — execute() , prepared statements, parameter binding, and mapping rows to Rust types. Import Data — bulk loading with the Appender and reading directly from Parquet, CSV, and JSON files. H... - https://man.mtool.work/duckdb/2.0/clients/rust/overview.html
- Avro Extension 7885
- 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
...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 of handling NULL . Unlike other systems, Avro does not treat NULL a... - https://man.mtool.work/duckdb/2.0/core_extensions/avro.html
- ODBC Extension Functions 7885
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...s select) column_types ( MAP(VARCHAR, VARCHAR) ): when create_table=TRUE is specified, allows to provide/override the type mapping between source DuckDB types and destination RDBMS types, example: create_table=TRUE, column_types=MAP { 'DUCKDB_TYPE_VARCH...nly used with 2-step parameters binding, see Query parameters for details. Optional named parameters that can change types mapping: The extension supports a number of options that can be used to change how the query parameters are passed and how the res... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Run Queries 7613
- 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
...e("INSERT INTO person (id, name) VALUES (?, ?)")?; stmt.execute(params![1, "Steven"])?; stmt.execute(params![2, "Jane"])?; Mapping Rows to Rust Values To read a result set, prepare a SELECT and call query_map() , passing a closure that builds a value fr... - https://man.mtool.work/duckdb/2.0/clients/rust/querying.html
DuckDB 2.0 Documentation / man.mtool.work