Results of 1 - 10 of about 17 for registers (0.002 sec.)
- SQLSmith Extension 13759
- The sqlsmith extension is used for testing. Installing and Loading INSTALL AND LOAD sqlsmith; Functions The sqlsmith extension registers the following functions: sqlsmith fuzzyduck reduce_sql_statement fuzz_all_functions
... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlsmith.html
- Statically Linking Extensions 10828
- This page is for client and binding authors, and for anyone who embeds libduckdb in their own application. It describes how statically linking extensions changed in DuckDB 2.0 and what builders on top of DuckDB need to do. This change is in
...ives. The generated loader that libduckdb_static.a used to register extensions automatically. libduckdb_static.a no longer registers extensions on its own. Registering Statically Linked Extensions Because extension selection moved to link time, a client t...behaving. The engine exposes a C API call, duckdb_register_static_extension(describe) , which validates the descriptor and registers the extension for every database opened afterwards. A generated loader ( static_extension_loader.c ) defines duckdb_regist... - https://man.mtool.work/duckdb/2.0/dev/building/linking_extensions.html
- Unity Catalog Extension 10414
- 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
...ure was introduced in DuckDB 2.0. CREATE TABLE in a Unity Catalog schema writes the first version of a new Delta table and registers the table with Unity Catalog. Without a location, the table is a managed table: Unity Catalog chooses where it is stored,...able with this name. For the forms and options that CREATE TABLE does not support, see Limitations . Warning Unity Catalog registers the table while CREATE TABLE runs, so a ROLLBACK of the surrounding transaction does not remove the table. Checkpointing S... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- Write User Defined Functions 9155
- 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
...). The implementation is a DuckDBTableFunction with the following callbacks: bind runs when the statement is prepared. It registers the output columns with addResultColumn() and reads positional and named call parameters with getParameter() and getNamedP...sult it in apply . .withProjectionPushdown() .withFunction(new DuckDBTableFunction<Void, long[], Object>() { // ... bind() registers the full set of output columns ... @Override public long[] init(DuckDBTableFunctionInitInfo info) throws Exception { // Re... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- Handle Results 8742
- 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
...erate_series")); } } } Arrow Import The following example consumes an Arrow stream produced by the Java Arrow bindings and registers it on a DuckDB connection with registerArrowStream() . Once registered, the stream is addressed by the name passed to that... - https://man.mtool.work/duckdb/2.0/clients/java/result_handling.html
- DuckLake 8742
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...log tables for a DuckLake named my_ducklake in the __ducklake_metadata_⟨my_ducklake⟩ catalog. Functions Note that DuckLake registers several functions. These should be called with the catalog name as the first argument, e.g.: FROM ducklake_snapshots('my_d... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- Indexing 8742
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...to zero. When in doubt, use EXPLAIN ANALYZE to verify that your query plan uses the index scan. Indexes and Memory DuckDB registers index memory through its buffer manager. However, these index buffers are not yet buffer-managed. That means DuckDB does n... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
- CREATE TRIGGER Statement 8742
- New The CREATE TRIGGER feature was introduced in DuckDB 2.0. The CREATE TRIGGER statement registers a trigger: a set of SQL statements that run automatically in response to INSERT , UPDATE , or DELETE events on a table. Examples Record ever
... - https://man.mtool.work/duckdb/2.0/sql/statements/create_trigger.html
- Go Client 8310
- 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
...with the blank identifier alongside database/sql : import ( "database/sql" _ "github.com/duckdb/duckdb-go/v2" ) The import registers a driver named duckdb with database/sql . Code that calls the client's own types and functions directly, such as the Appen... - https://man.mtool.work/duckdb/2.0/clients/go/overview.html
- Write User Defined Functions 8310
- Overview The Rust client can register user-defined functions written in Rust: scalar functions with the vscalar feature and table functions with the vtab feature. Both operate on DuckDB's columnar data chunks, so a single call processes a b
...xtension feature and the duckdb_entrypoint_c_api macro to declare the extension entry point. The crate's hello-ext example registers a hello(name) table function this way. Warning Enable loadable-extension only when building an extension. In a client appl... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
DuckDB 2.0 Documentation / man.mtool.work