Results of 1 - 10 of about 15 for init (0.003 sec.)
- Table Functions 14594
- The table function API can be used to define a table function that can then be called from within DuckDB in the FROM clause of a query. API Reference Overview duckdb_table_function duckdb_create_table_function (); void duckdb_destroy_table_
...tion_set_bind ( duckdb_table_function table_function , duckdb_table_function_bind_t bind ); void duckdb_table_function_set_init ( duckdb_table_function table_function , duckdb_table_function_init_t init ); void duckdb_table_function_set_local_init (...duckdb_table_function table_function , duckdb_table_function_init_t init ); void duckdb_table_function_set_function ( duckdb_table_function table_function , duckdb_table_function_t functio...t cardinality , bool is_exact ); void duckdb_bind_set_error ( duckdb_bind_info info , const char * error ); Table Function Init void * duckdb_init_get_extra_info ( duckdb_init_info info ); void * duckdb_init_get_bind_data ( duckdb_init_info info ); v... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- Command Line Arguments 9787
- The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -agent Render
...from stdin , writing the result to stdout -format-file FILENAME Format the SQL in FILENAME , writing the result to stdout -init FILENAME Run the script in FILENAME upon startup (instead of ~/.duckdbrc ) -header Turn headers on -h Show the help messag...EP Set output row separator. Default: \n -no-agent Never render output for an AI coding agent. See the Agent Mode page -no-init Skip processing the init file ( ~/.duckdbrc or the file passed to -init ) -noheader Turn headers off -no-stdin Exit after...ple: duckdb -csv -c 'SELECT 42 AS hello' -json -c 'SELECT 84 AS world' Returns the following: hello 42 [{"world":84}] The -init script (or the default ~/.duckdbrc when -init is not given) is an exception: it always runs at startup, before any -cmd ,... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Write User Defined Functions 9596
- 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
...ll parameters with getParameter() and getNamedParameter() . It may return bind data that is passed to the later callbacks. init runs once before execution and returns the global state. localInit (optional) runs once per execution thread and returns t...s null . apply writes rows into the output vectors and returns the number of rows written, with access to the bind, global-init, and local-init data. The engine calls it repeatedly until it returns 0 . import java.sql.Connection; import java.sql.Driv...import org.duckdb.DuckDBTableFunction; import org.duckdb.DuckDBTableFunctionBindInfo; import org.duckdb.DuckDBTableFunctionInitInfo; import org.duckdb.DuckDBTableFunctionCallInfo; import org.duckdb.DuckDBDataChunkWriter; import org.duckdb.DuckDBValue... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- Connect 9213
- 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
...mory_monitor Enable JFR memory monitoring for the connection's database instance. See Memory Monitoring with JFR . session_init_sql_file Run the SQL in the given file before handing over the connection. URL-only, see Running SQL at Connection Startup.... session_init_sql_file_sha256 Expected SHA-256 digest of the session init SQL file. URL-only. Running SQL at Connection Startup The sess...ion_init_sql_file option points the driver at a SQL file on the local file system that is executed before the connection is returne... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Unit Tester Configuration 8760
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...est --no-checkpoint-on-shutdown # other types unittest --checkpoint-wal-size 100000 Command line options --settings , --on-init and --init-script can be used to specify DuckDB configuration . Configuration File A JSON file that can be passed in using...ding <none|available|all> Loading strategy for extensions not bundled in --base-config <path> Config file to load and base initial settings on --block-size <num> Block Allocation Size; must be a power of 2 --checkpoint-on-shutdown , --no-checkpoint-o...e-restart , --no-force-restart Force restart the database between runs --force-storage Test with persistent storage file --init-script <path> SQL script to execute on init --initial-db <path> Initial database path --keep-home Use $HOME/USERPROFILE in... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- Complete API 8673
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...date_struct duckdb_from_date ( duckdb_date date ); duckdb_date duckdb_to_date ( duckdb_date_struct date ); bool duckdb_is_finite_date ( duckdb_date date ); duckdb_time_struct duckdb_from_time ( duckdb_time time ); duckdb_time_tz duckdb_create_time_tz...om_timestamp ( duckdb_timestamp ts ); duckdb_timestamp duckdb_to_timestamp ( duckdb_timestamp_struct ts ); bool duckdb_is_finite_timestamp ( duckdb_timestamp ts ); bool duckdb_is_finite_timestamp_s ( duckdb_timestamp_s ts ); bool duckdb_is_finite_tim...estamp_ms ( duckdb_timestamp_ms ts ); bool duckdb_is_finite_timestamp_ns ( duckdb_timestamp_ns ts ); Hugeint Helpers double duckdb_hugeint_to_double ( duckdb_hugeint val ); duckdb_h... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Write User Defined Functions 8150
- 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
...sult columns with add_result_column() and reads the call's arguments with get_parameter() , returning read-only bind data. init runs once before execution and returns per-scan state, such as a cursor. func produces one chunk of rows per call. It fill...that returns one row per integer in 0..count , over columns of increasing complexity. Its skeleton, showing the bind data, init state, and per-chunk execution model: use duckdb::{ Connection, Result, core::{DataChunkHandle, LogicalTypeHandle, Logical...TypeId}, vtab::{BindInfo, InitInfo, TableFunctionInfo, VTab}, }; use std::sync::atomic::{AtomicUsize, Ordering}; struct Numbers; // Computed once from th... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- Command Line Client 7959
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...nformation on these options. Tip To prevent the DuckDB CLI client from reading the ~/.duckdbrc file, start it with the -no-init argument: batch duckdb -no-init Below, we summarize a few important dot commands. To see all available commands, see the d...ommands and SQL statements. This allows you to store the configuration state of the CLI. You may also point to a different initialization file using the -init flag. Warning The CLI reads and writes several files in the user's home directory, includin...atabase()} ⚫◗ " Or a simpler version without colours: .prompt "{sql:select current_database()} ⚫◗ " To invoke that file on initialization, use this command: duckdb -init prompt.sql This outputs: -- Loading resources from prompt.sql DuckDB v2.0.0 (Cya... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Write User Defined Functions 7959
- Overview The Go client can register user-defined functions written in Go: scalar functions that map input rows to a single output value, and table functions that produce a set of rows. It can also register a replacement scan that rewrites a
...tion through its methods: ColumnInfos() declares the result columns, each a duckdb.ColumnInfo with a name and a TypeInfo . Init() runs once before the scan. FillRow() is called repeatedly, filling one duckdb.Row per call with duckdb.SetRowValue() and...TypeInfo(duckdb.TYPE_BIGINT) check(err) return []duckdb.ColumnInfo{{Name: "result", T: t}} } func (udf *incrementTableUDF) Init() {} func (udf *incrementTableUDF) FillRow(row duckdb.Row) (bool, error) { if udf.currentRow+1 > udf.tableSize { return fa...un on several threads, implement duckdb.ParallelRowTableSource and register a duckdb.ParallelRowTableFunction instead. Its Init() returns a duckdb.ParallelTableSourceInfo that sets MaxThreads , a NewLocalState() method provides per-thread state, and... - https://man.mtool.work/duckdb/2.0/clients/go/functions.html
- Python 7906
- The DuckDB Python package has its own repository at duckdb/duckdb-python and uses nanobind 3 to create Python bindings with DuckDB. Prerequisites This guide assumes: You have a full clone of the DuckDB Python package source, including its g
...://github.com/duckdb/duckdb-python.git git fetch --all If you've already cloned without submodules: git submodule update --init --recursive git remote add upstream https://github.com/duckdb/duckdb-python.git git fetch --all Important notes: * DuckDB...is vendored as a git submodule and must be initialized, otherwise the build fails with RuntimeError: Duckdb submodule not initialized * The package version is the release...e tree, use pre-commit run --all-files . You can also install a post-checkout hook that always runs git submodule update --init --recursive . When you change branches between main and a bugfix branch, this makes sure the duckdb submodule is always co... - https://man.mtool.work/duckdb/2.0/dev/building/python.html
DuckDB 2.0 Documentation / man.mtool.work