Results of 1 - 10 of about 41 for extra (0.005 sec.)
- Table Functions 16195
- 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_
...er ( duckdb_table_function table_function , const char * name , duckdb_logical_type type ); void duckdb_table_function_set_extra_info ( duckdb_table_function table_function , void * extra_info , duckdb_delete_callback_t destroy ); void duckdb_table_fu...ster_table_function ( duckdb_connection con , duckdb_table_function function ); Table Function Bind void * duckdb_bind_get_extra_info ( duckdb_bind_info info ); void duckdb_table_function_get_client_context ( duckdb_bind_info info , duckdb_client_cont...t ); 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 ); void duckdb_init_set_init_data... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- Replacement Scans 10724
- The replacement scan API can be used to register a callback that is called when a table is read that does not exist in the catalog. For example, when a query such as SELECT * FROM my_table is executed and my_table does not exist, the replac
...erence Overview void duckdb_add_replacement_scan ( duckdb_database db , duckdb_replacement_callback_t replacement , void * extra_data , duckdb_delete_callback_t delete_callback ); void duckdb_replacement_scan_set_function_name ( duckdb_replacement_sca...atabase. Syntax void duckdb_add_replacement_scan ( duckdb_database db , duckdb_replacement_callback_t replacement , void * extra_data , duckdb_delete_callback_t delete_callback ); Parameters db : The database object to add the replacement scan to repl...acement : The replacement scan callback extra_data : Extra data that is passed back into the specified callback delete_callback : The delete callback to call on the ext... - https://man.mtool.work/duckdb/2.0/clients/c/replacement_scans.html
- Complete API 10320
- 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
...kdb_state duckdb_execute_prepared_streaming ( duckdb_prepared_statement prepared_statement , duckdb_result * out_result ); Extract Statements idx_t duckdb_extract_statements ( duckdb_connection connection , const char * query , duckdb_extracted_statem...ents * out_extracted_statements ); duckdb_state duckdb_prepare_extracted_statement ( duckdb_connection connection , duckdb_extracted_statem...ents extracted_statements , idx_t index , duckdb_prepared_statement * out_prepared_statement ); const char * duckdb_extract_statement... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Describe 9201
- Describing a Table To view the schema of a table, use the DESCRIBE statement (or its alias DESC ) followed by the table name. CREATE TABLE tbl (i INTEGER PRIMARY KEY, j VARCHAR); DESCRIBE tbl; column_name column_type null key default extra
...f the result of a query, prepend DESCRIBE to a query. DESCRIBE SELECT * FROM tbl; column_name column_type null key default extra i INTEGER NO PRI NULL NULL j VARCHAR YES NULL NULL NULL Using DESCRIBE in a Subquery DESCRIBE can be used as a subquery. T...r example: DESCRIBE TABLE 'https://blobs.duckdb.org/data/Star_Trek-Season_1.csv'; column_name column_type null key default extra season_num BIGINT YES NULL NULL NULL episode_num BIGINT YES NULL NULL NULL aired_date DATE YES NULL NULL NULL cnt_kirk_hoo... - https://man.mtool.work/duckdb/2.0/guides/meta/describe.html
- Metrics 8548
- DuckDB provides a set of metrics that can be used to monitor the performance and health of the database. Metrics are named ⟨group⟩.⟨metric⟩ , e.g., query.total_time or operator.timing . The set of collected metrics is controlled with the tr
...the profiling output. Name Type Unit Description operator.cpu_time double seconds CPU time spent in the operator operator.extra_info map Unique operator metrics operator.intermediate_rows uint64 rows Number of intermediate rows produced by the operat...OM students JOIN exams USING (sid) WHERE name LIKE 'Ma%'; The file's content after executing the query: { "operator": [ { "extra_info": {}, "intermediate_rows": 0, "intermediate_size_bytes": 0, "timing": 5.458e-06, "type": "RESULT_COLLECTOR", "childre...n": [ { "extra_info": { "Projections": "name", "Estimated Cardinality": "1" }, "intermediate_rows": 2, "intermediate_size_bytes": 40, "ti... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
- Catalogs 8315
- The iceberg extension supports attaching Iceberg REST Catalogs. Attaching a catalog is required for writing to Iceberg . Before attaching an Iceberg REST Catalog, you must install the iceberg extension by following the instructions located
...; DROP TABLE seaweedfs_catalog.sales.orders; Google Cloud BigLake To attach to a Google Cloud BigLake catalog, you can use extra HTTP headers to specify the GCP project for billing purposes. First, get your Google Cloud access token: gcloud auth appli...cation-default print-access-token Then create a secret with the token and extra headers: CREATE SECRET biglake_secret ( TYPE iceberg, TOKEN '⟨your_access_token⟩', EXTRA_HTTP_HEADERS MAP { 'x-goog-user-p...xample using the BigLake public dataset : CREATE SECRET biglake_public_secret ( TYPE iceberg, TOKEN '⟨your_access_token⟩', EXTRA_HTTP_HEADERS MAP { 'x-goog-user-project': '⟨your_gcp_project_id⟩' } ); ATTACH 'gs://biglake-public-nyc-taxi-iceberg' AS bi... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- DuckLake 7911
- 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
...─────────┬───────────────────┐ │ snapshot_id │ snapshot_time │ schema_version │ changes │ author │ commit_message │ commit_extra_info │ │ int64 │ timestamp with time zone │ int64 │ map(varchar, varchar[]) │ varchar │ varchar │ varchar │ ├─────────────...IMESTAMP WITH TIME ZONE schema_version BIGINT changes MAP(VARCHAR, VARCHAR[]) author VARCHAR commit_message VARCHAR commit_extra_info VARCHAR ducklake_table_info The ducklake_table_info function returns information on the tables stored in the DuckLake... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- Raspberry Pi 7817
- DuckDB is not officially distributed for the Raspberry Pi OS (previously called Raspbian). You can build it following the instructions on this page. Raspberry Pi (64-bit) First, install the required build packages: sudo apt-get update sudo
...nclude them in the build. For example: mkdir build cd build cmake .. \ -DBUILD_EXTENSIONS="httpfs;json;parquet" \ -DDUCKDB_EXTRA_LINK_FLAGS="-latomic" make -j4... - https://man.mtool.work/duckdb/2.0/dev/building/raspberry_pi.html
- Dutch Railway Datasets 7584
- Examples in this documentation often use datasets based on the Dutch Railway datasets . These high-quality datasets are maintained by the team behind the Rijden de Treinen (Are the trains running?) application . This page contains download
...'https://blobs.duckdb.org/nl-railway/services-2025-03.csv.gz'; DESCRIBE services; column_name column_type null key default extra Service:RDT-ID BIGINT YES NULL NULL NULL Service:Date DATE YES NULL NULL NULL Service:Type VARCHAR YES NULL NULL NULL Serv... - https://man.mtool.work/duckdb/2.0/guides/snippets/dutch_railway_datasets.html
- Concurrency 7507
- Handling Concurrency Single Process In in-process mode, DuckDB has two configurable options for concurrency: Read-write mode: one process can both read and write to the database. Read-only mode: multiple processes can read from the database
...the transaction. Troubleshooting File locks. DuckDB handles concurrent database access requests using file locks. Exercise extra caution when accessing a DuckDB database file in a shared directory (e.g., from different operating systems using differen... - https://man.mtool.work/duckdb/2.0/connect/concurrency.html
DuckDB 2.0 Documentation / man.mtool.work