Results of 1 - 10 of about 75 for work (0.001 sec.)
- Profile and Monitor 10586
- Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T
...monitor", "analytics-db"); try (Connection conn = DriverManager.getConnection("jdbc:duckdb:/tmp/my_database", props)) { // work with the connection while a JFR recording is active } The same option can be set in the URL: jdbc:duckdb:/tmp/my_database;...ing r = new Recording()) { r.enable("duckdb.MemoryUsage").withPeriod(Duration.ofSeconds(1)); r.start(); // ... application work ... r.stop(); r.dump(Path.of("app.jfr")); } The equivalent .jfc snippet: <event name="duckdb.MemoryUsage"> <setting name="...bled">true</setting> <setting name="period">1 s</setting> </event> When no recording enables the event, the driver does no work: the underlying duckdb_memory() query is never issued. Event Schema While a recording is active with the event enabled, th... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- Avro Extension 10239
- 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
...avro('https://blobs.duckdb.org/data/userdata1.avro'); FROM read_avro('s3://⟨your-bucket⟩/⟨some_file⟩.avro'); should "just" work. You can also glob multiple files in a single read call or pass a list of files to the functions: FROM read_avro('some_fil...to DuckDB, where any value can be NULL . Of course DuckDB also supports UNION types, but this would be quite cumbersome to work with. This extension simplifies the Avro schema where possible: An Avro union of any type and the special null type is sim... - https://man.mtool.work/duckdb/2.0/core_extensions/avro.html
- UI Extension 10239
- The ui extension adds a user interface for your local DuckDB instance. Usage To start the UI from the command line: duckdb -ui To start the UI from SQL: CALL start_ui(); Running either of these will open the UI in your default browser. The
...all the resources of your local environment: all cores, memory and files. Closing this instance will cause the UI to stop working. The UI is served from an HTTP server embedded in DuckDB. To start this server without launching the browser, run: CALL...recommended, as the list of databases in the UI could get out of date, and some ways of connecting to MotherDuck will not work properly. Tips Opening a CSV File with the DuckDB UI Using the DuckDB CLI client , you can start the UI with a CSV availab...read_only_test.db In the UI, this results in: Catalog Error: SET schema: No catalog + schema named "memory.main" found. To work around this, run the UI on another database file: duckdb -ui ui_catalog.db Then, open a notebook and attach to the databas... - https://man.mtool.work/duckdb/2.0/core_extensions/ui.html
- Unofficial and Unsupported Platforms 10239
- Warning The platforms listed on this page are not officially supported. The build instructions are provided on a best-effort basis. Community contributions are very welcome. DuckDB is built and distributed for several platforms with differe
...g levels of success. This page provides an overview of these with the intent to clarify which platforms can be expected to work. 32-bit Architectures 32-bit architectures are officially not supported but it is possible to build DuckDB manually for so...MAKE_BUILD_TYPE=Release make -j$(nproc) Build time is approximately 2 hours on an 8-core SpacemiT K1. The resulting binary works out of the box: ./duckdb -c “SELECT 'Hello from RISC-V' AS message;” ┌───────────────────┐ │ message │ │ varchar │ ├─────...──────────────┤ │ Hello from RISC-V │ └───────────────────┘ Aggregation queries work as expected: ./duckdb -c “CREATE TABLE test AS SELECT range AS id, range * 3.14 AS value FROM range(1000); SELECT count(*)... - https://man.mtool.work/duckdb/2.0/dev/building/unofficial_and_unsupported_platfo...
- Swift Client 9877
- DuckDB has a Swift client. See the announcement post for details. Instantiating DuckDB DuckDB supports both in-memory and persistent databases. To work with an in-memory database, run: let database = try Database(store: .inMemory) To work w
...g DuckDB's ResultSet cast(to:) family of methods, before finally wrapping them up in a DataFrame from the TabularData framework. ... import TabularData extension ExoplanetStore { // Retrieves the number of exoplanets discovered by year func groupedBy... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/swift.html
- S3 API Support 9877
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...Cloud and lakeFS . Other services that implement the S3 API (such as Cloudflare R2 , SeaweedFS , and Tigris ) should also work, but not all features may be supported. The following table shows which parts of the S3 API are required for each httpfs f...be made available as AWS environment variables ( AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY ) for the credential chain to work properly. Finally, R2 secrets are only available when using URLs starting with r2:// , for example: SELECT * FROM read_par...be made available as AWS environment variables ( AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY ) for the credential chain to work properly. Finally, GCS secrets are only available when using URLs starting with gcs:// or gs:// , for example: SELECT * FR... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Troubleshooting 9516
- Troubleshooting Running EXPLAIN Renders Newlines In Python, the output of the EXPLAIN statement contains hard line breaks ( \n ): In [1]: import duckdb ...: duckdb.sql("EXPLAIN SELECT 42 AS x") Out[1]: ┌───────────────┬─────────────────────
...───────────────┴──────────────────────────────────────────────────────────────────────────────────────────────────────┘ To work around this, print the output of the explain() function: In [2]: print(duckdb.sql("SELECT 42 AS x").explain()) Out[2]: ╭─...e very elusive / hard to track down. Below is a list of these issues that you might have to be aware of, depending on your workflow. Numpy Import Multithreading When making use of multi threading and fetching results either directly as Numpy arrays o...d this, it's recommended to import numpy.core.multiarray before starting up threads. Many Threads per Database Besides its worker threads, each database starts a pool of asynchronous I/O threads : by default four times the number of CPU cores, at mos... - https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
- Limits 9516
- This page contains DuckDB's built-in limit values. To check the value of a setting on your system, use the current_setting function. Limit Values Limit Default value Configuration option Comment Array size 100000 - BLOB size 4 GB - Expressi
...practical limit for the size of a single DuckDB database file. We have database files using 15 TB+ of disk space and they work fine. However, connecting to such a huge database may take a few seconds and checkpointing can be slower.... - https://man.mtool.work/duckdb/2.0/operations_manual/limits.html
- Iceberg Extension 9169
- The iceberg extension implements support for the Apache Iceberg open table format . There are two ways to work with Iceberg in DuckDB: Individual tables are read directly from storage, by pointing at a table's metadata. This requires no cat
...st of parameters accepted by iceberg_scan , see the Iceberg Options page. Reading from Object Stores The iceberg extension works together with the httpfs extension or the azure extension to access Iceberg tables in object stores such as S3 or Azure B...M my_catalog.default.events; INSERT INTO my_catalog.default.events VALUES (1, 'click', now()); The metadata functions also work on catalog tables when passed a fully qualified name, e.g., iceberg_snapshots(my_catalog.default.events) . For the full se... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/overview.html
- Gitignore for DuckDB 9169
- If you work in a Git repository, you may want to configure your Gitignore to disable tracking files created by DuckDB . These potentially include the DuckDB database, write-ahead log, and temporary files. Sample Gitignore Files In the follo
... - https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/gitignor...
DuckDB 2.0 Documentation / man.mtool.work