Results of 1 - 10 of about 32 for engine (0.002 sec.)
- Jupyter Notebooks 14627
- DuckDB's Python client can be used directly in Jupyter notebooks with no additional configuration, as the first section shows. Additional libraries can simplify SQL query development; the rest of this guide uses the JupySQL package. See oth
...QL cell Pandas : Clean table visualizations and compatibility with other analysis matplotlib : Plotting with Python duckdb-engine (DuckDB SQLAlchemy driver) : Used by SQLAlchemy to connect to DuckDB (optional) Run these pip install commands from the co...notebook Or JupyterLab: pip install jupyterlab Install supporting libraries: pip install jupysql pandas matplotlib duckdb-engine Library Import and Configuration Open a Jupyter Notebook and import the relevant libraries. Set configurations on jupysql...uckDB connection. Connecting to DuckDB via SQLAlchemy Alternatively, you can connect to DuckDB via SQLAlchemy using duckdb_engine . See the performance and feature differences . import duckdb import pandas as pd # No need to import duckdb_engine # jupy... - https://man.mtool.work/duckdb/2.0/guides/python/jupyter.html
- Statically Linking Extensions 10761
- 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
...Because extension selection moved to link time, a client that statically links extensions must now register them with the engine before any database is opened. Each extension archive carries a generated describe function, duckdb_extension_⟨name⟩_descr...n_descriptor declared in the new public header duckdb_static_extension.h . The descriptor carries a layout version, so the engine refuses an archive whose descriptor layout it does not support, with a clear message instead of misbehaving. The engine ex...it. Linking the Archives by Hand Outside CMake, link one archive per extension, compile the generated loader, and put the engine archive last: LINK_EXTENSIONS='parquet;json' make static_extension_loader cc -I src/include main.c build/release/static_ex... - https://man.mtool.work/duckdb/2.0/dev/building/linking_extensions.html
- Spark API 10584
- The DuckDB Spark API implements the PySpark API , allowing you to use the familiar Spark API to interact with DuckDB. All statements are translated to DuckDB's internal plans using our relational API and executed using DuckDB's query engine
...on DuckDB, as its replacement. SQLFrame does not support DuckDB 2.0 yet: SQLFrame 4.5.0 requires duckdb<1.6 for its DuckDB engine. Please report bugs in the Spark API on GitHub . Example from duckdb.experimental.spark.sql import SparkSession as session... - https://man.mtool.work/duckdb/2.0/clients/python/spark_api.html
- Sirius Extension 9810
- The sirius extension is not yet available. It is coming soon. The sirius extension adds GPU-accelerated query execution to DuckDB. Sirius is a GPU-native SQL engine that runs DuckDB queries on NVIDIA GPUs.
... - https://man.mtool.work/duckdb/2.0/core_extensions/sirius.html
- Overview of DuckDB Internals 9617
- Tip For a detailed explanation of DuckDB internals, see the Design and Implementation of DuckDB Internals ("DiDi") library entry. On this page is a brief description of the internals of the DuckDB engine. Parser The parser converts a query
...BoundReferenceExpression nodes that refer to a specific index into the DataChunks that are passed around in the execution engine. Physical Plan Generator The physical plan generator converts the resulting logical operator tree into a PhysicalOperator... - https://man.mtool.work/duckdb/2.0/internals/overview.html
- Write User Defined Functions 9424
- 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
...s a NULL , the driver skips the Java call and writes NULL to the output automatically. Call withNullInNullOut() to let the engine short-circuit NULL in, NULL out : it may skip the call and return NULL whenever an argument is NULL . The engine does not...unction whose output can change between calls with the same arguments — for example one that reads external state — so the engine evaluates it for every row. Error Handling Type and value errors raised while a callback reads its inputs or writes its re...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.DriverManager; import java.util.concu... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- Geometry Data Type 9037
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...spatial extension, but this conversion is performed automatically at the storage layer and is not visible to the execution engine or the user. Shredding and Compression The GEOMETRY type supports a storage optimization called "shredding", which improve...mproved compression, but in the future we plan to add ways to expose the shredded representation directly to the execution engine without having to "reassemble" the geometry back into binary again. The following example illustrates the effects of shred...bounding box and all geometry types and vertex dimensions will be marked as maybe present, which means that the execution engine will not be able to do any optimizations based on the geometry statistics. Coordinate Reference Systems As far as the exec... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- DuckDB Wasm Client 8844
- Installation To use the DuckDB Wasm client, visit the duckdb-wasm GitHub repository . The latest stable version of the DuckDB WebAssembly client is 2.0.0. DuckDB-Wasm is a version of DuckDB that has been compiled to WebAssembly , the portab
...le binary format that browsers can run at near-native speed. This lets a full DuckDB engine run entirely inside any browser on any device, with no server to send queries to and no data leaving the user's machine. I...t, importing data, running queries, loading extensions, and deploying it. Try It Yourself The shell below is a full DuckDB engine running in your browser — type a SQL query and run it right here: Note The shell above is itself built with DuckDB-Wasm. I... - https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
- Out of Memory Errors 8264
- DuckDB has a state of the art out-of-core query engine that can spill to disk for larger-than-memory processing. We continuously strive to improve DuckDB's scalability and prevent out of memory errors whenever possible. That said, you may s
... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/oom_errors.html
- ATTACH and DETACH Statements 7877
- DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db'; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'fil
...extension page for the full list: PostgreSQL , MySQL , and Iceberg . Database Type The TYPE option specifies which storage engine backs the attached database. The type name is case-insensitive. Native DuckDB storage uses DUCKDB (the default). Other typ...orage and disables the path-based deduction described above. If you attach a path that carries a scheme prefix for another engine but also pass TYPE DUCKDB , the prefix is ignored and the statement does not have the intended effect. Attaching Data File... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
DuckDB 2.0 Documentation / man.mtool.work