Results of 1 - 10 of about 22 for functionality (0.002 sec.)
- Glossary of Terms 13114
- This page contains a glossary of a few common terms used in DuckDB. Terms In-Process Database Management System The DBMS runs in the client application's process instead of running as a separate process, which is common in the traditional c
...ension DuckDB has a flexible extension mechanism that allows for dynamically loading extensions. These may extend DuckDB's functionality by providing support for additional file formats, introducing new types, and domain-specific functionality. For details, s... - https://man.mtool.work/duckdb/2.0/guides/glossary.html
- Extensions 11699
- DuckDB has a flexible extension mechanism that allows for dynamically loading extensions. Extensions can enhance DuckDB's functionality by providing support for additional file formats, introducing new types, and domain-specific functionality
...tensions The same API that the core extensions use is available for developing extensions. This allows users to extend the functionality of DuckDB such that it suits their domain the best. A template for creating extensions is available in the extension-templ... - https://man.mtool.work/duckdb/2.0/extensions/overview.html
- httpfs Extension for HTTP and S3 Support 10555
- The httpfs extension is an autoloadable extension implementing a file system that allows reading remote/writing remote files. For plain HTTP(S), only file reading is supported. For object storage using the S3 API, the httpfs extension suppo
...writing/ globbing files. Installation and Loading The httpfs extension will be, by default, autoloaded on first use of any functionality exposed by this extension. To manually install and load the httpfs extension, run: INSTALL AND LOAD httpfs; HTTP(S) The ht... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/overview.html
- sqllogictest Introduction 10285
- For testing plain SQL, we use an extended version of the SQL logic test suite, adopted from SQLite . Every test is a single self-contained file located in the test/sql directory. To run tests located outside of the default test directory, s
...a TO '__TEST_DIR__/output_file.csv.gz' (COMPRESSION gzip); Require & Extensions To avoid bloating the core system, certain functionality of DuckDB is available only as an extension. Tests can be built for those extensions by adding a require field in the test...ill prevent the test from being run unless the vector size is greater than or equal to 512. This is useful because certain functionality is not supported for low vector sizes, but we run tests using a vector size of 2 in our CI.... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- Load Extensions 9713
- Overview DuckDB-Wasm's (dynamic) extension loading is modeled after regular DuckDB's extension loading, with a few relevant differences due to the difference in platform. A growing subset of core, community, and external extensions is suppo
...via the Emscripten implementation of dlopen . Autoloading Autoloading , i.e., the possibility for DuckDB to add extension functionality on-the-fly, is enabled by default in DuckDB-Wasm. Available Extensions A growing subset of extensions is supported for Duc...nces and some restrictions relative to native. Instead, DuckDB-Wasm ships a separate JavaScript implementation of the same functionality. Running LOAD httpfs; opts into this re-implemented HTTP stack, which is interchangeable with the native extension for mos... - https://man.mtool.work/duckdb/2.0/clients/wasm/extensions.html
- Writing to Iceberg 9427
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...also work: COPY FROM DATABASE duckdb_db TO iceberg_datalake; -- Or COPY FROM DATABASE iceberg_datalake TO duckdb_db; This functionality enables deep copies between Iceberg and DuckDB storage. Creating Schemas and Tables Iceberg namespaces are exposed as sche...mitations: DuckDB-Iceberg only writes positional deletes (encoded as binary deletion vectors for v3 tables). Copy-on-write functionality is not yet supported. DuckDB-Iceberg only supports merge-on-read semantics . If a table has write.update.mode or write.del... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Core Extensions 8854
- List of Core Extensions Name Description Maintainer Support tier Aliases autocomplete Autocompletion for CLI client DuckDB team avro Avro files reading DuckDB team aws AWS S3 functionality DuckDB team azure Filesystem abstraction for Azure
... - https://man.mtool.work/duckdb/2.0/core_extensions/overview.html
- Catch C/C++ Tests 8854
- While we prefer the sqllogic tests for testing most functionality, for certain tests only SQL is not sufficient. This typically happens when you want to test the C++ API. When using pure SQL is really not an option it might be necessary to
... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/catch.html
- Tableau – A Data Visualization Tool 8013
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
...b:/User/username/path/to/database.db . For the Dialect, choose PostgreSQL. The rest of the fields can be ignored: However, functionality will be missing such as median and percentile aggregate functions. To make the data source connection more compatible with... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Import Data 7727
- Overview The JDBC driver offers two ways to load data into DuckDB in bulk: the high-performance Appender and a JDBC batch writer. This page describes both and when to use each. Appender The Appender is available in the DuckDB JDBC driver vi
.... DuckDBSingleValueAppender is kept only for existing applications. Batch Writer The DuckDB JDBC driver offers batch write functionality. The batch writer supports prepared statements to mitigate the overhead of query parsing. The preferred method for bulk in... - https://man.mtool.work/duckdb/2.0/clients/java/data_import.html
DuckDB 2.0 Documentation / man.mtool.work