Results of 1 - 10 of about 18 for depend (0.002 sec.)
- DROP Statement 13898
- The DROP statement removes a catalog entry added previously with the CREATE command. Examples Delete the table with the name tbl : DROP TABLE tbl; Drop the view with the name view1 ; do not throw an error if the view does not exist: DROP VI
...; Drop macro table mt : DROP MACRO TABLE mt; -- the `TABLE` is optional since v1.4.0 Drop type typ : DROP TYPE typ; Syntax Dependencies of Dropped Objects DuckDB performs limited dependency tracking for some object types. By default or if the RESTRICT...clause is provided, the entry will not be dropped if there are any other objects that depend on it. If the CASCADE clause is provided then all the objects that are dependent on the object will be dropped as well. CR...EATE SCHEMA myschema; CREATE TABLE myschema.t1 (i INTEGER); DROP SCHEMA myschema; Dependency Error: Cannot drop entry "myschema" because there are entries that depend on it. table "t1" depends on schema "myschem... - https://man.mtool.work/duckdb/2.0/sql/statements/drop.html
- Extensions 10964
- 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 functionali
...Adds support for autocomplete in the shell avro false Adds support for reading Avro files aws false Provides features that depend on the AWS SDK azure false Adds a filesystem abstraction for Azure blob storage to DuckDB ... ... ... This list will show...mal embeddings that do not load any extensions by default may need to run LOAD core_functions; explicitly. Some extensions depend on it as well, for example DuckLake , which otherwise fails with an error such as Binder Error: Failed to load DuckLake ta... - https://man.mtool.work/duckdb/2.0/extensions/overview.html
- CREATE SEQUENCE Statement 10964
- The CREATE SEQUENCE statement creates a new sequence number generator. Examples Generate an ascending sequence starting from 1: CREATE SEQUENCE serial; Generate sequence from a given start number: CREATE SEQUENCE serial START 101; Generate
...ault is the next value from id_sequence'); Attempting to drop the sequence results in an error: DROP SEQUENCE id_sequence; Dependency Error: Cannot drop entry "id_sequence" because there are entries that depend on it. table "tbl" depends on sequence "i...d_sequence". Use DROP...CASCADE to drop all dependents. As the error message suggests, you can force dropping by adding CASCADE . However, DuckDB currently tracks dependenci...a column DEFAULT value, because the replacement first drops the existing sequence: CREATE OR REPLACE SEQUENCE id_sequence; Dependency Error: Cannot drop entry "id_sequence" because there are entries that depend on it. table "tbl" depends on sequence "i... - https://man.mtool.work/duckdb/2.0/sql/statements/create_sequence.html
- Java (JDBC) Client 9299
- Installation To use the DuckDB Java (JDBC) client, visit the Java installation page . The latest stable version of the DuckDB Java (JDBC) client is 2.0.0. The DuckDB Java (JDBC) client lets Java applications query DuckDB through the standar
...ect storage repository with no browseable web page; it is consumed directly by Maven. Add the repository to your build and depend on a duckdb_jdbc SNAPSHOT version. See the preview builds page for a full Maven example. Basic API Usage DuckDB's JDBC API... - https://man.mtool.work/duckdb/2.0/clients/java/overview.html
- marimo Notebooks 8870
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...letting you interpolate Python values into the query with {} (shown later). In particular, this means your SQL queries can depend on the values of UI elements or other Python values, all part of marimo's dataflow graph. Warning Heads up! If you have us...QL result in Python Reactive SQL Cells marimo allows you to create reactive SQL cells that automatically update when their dependencies change. Working with expensive queries or large datasets? You can configure marimo's runtime to be “lazy”. By doing...so, dependent cells are only marked as stale, letting the user choose when they should be re-run. digits = mo.ui.slider(label="Digits... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- WITH Clause 8459
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
...ECT count(*) AS shipped FROM updated; Bestpractice Mark a data-modifying CTE as MATERIALIZED when later parts of the query depend on the modification having already run, so that it is not inlined or executed more than once. Recursive CTEs WITH RECURSIV...M clause only contains the rows from the most recent iteration. This is useful when termination conditions or calculations depend on the full accumulated result rather than just the previous iteration. Recursive CTEs with USING KEY Update DuckDB 1.5.0... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
- Profile and Monitor 8030
- 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
...stripped Java 8 builds, the feature is a silent no-op: the jdbc_jfr_memory_monitor property is ignored and no classes that depend on jdk.jfr are loaded. No additional JVM flags are required. Inspecting a Recording Inspect a captured recording with JDK... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- Rust Client 8030
- Installation To use the DuckDB Rust client, visit the Rust installation page . The latest stable version of the DuckDB Rust client is 2.0.0. The DuckDB Rust client, duckdb-rs , is an ergonomic wrapper over the DuckDB C API that exposes an i
...e form 1.⟨major_minor_patch⟩.x . A tilde requirement receives patch releases without changing the bundled DuckDB version: [dependencies] duckdb = { version = "~1.20000.0", features = ["bundled"] } The bundled feature is the simplest way to get started....d of compiling one, which is covered in Troubleshoot . To track the latest bindings before they are released on crates.io, depend on the main branch or a specific commit from git. The bundled DuckDB version is whatever that commit vendors: [dependencie...Flags The crate is modular: most integrations are gated behind Cargo features that are off by default. Enable them in the dependency declaration, for example features = ["bundled", "vtab", "appender-arrow"] . The following is the complete set of the c... - https://man.mtool.work/duckdb/2.0/clients/rust/overview.html
- Deploy 8030
- Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a
...ds to know the location of the follow-up files — the worker and WebAssembly components — in order to work. The exact steps depend on your setup; see the examples in the repository . For instance, the shell.duckdb.org deployment transpiles the main libr... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- SQLite Extension 8030
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...s, SQLite uses mutexes. When accessed from different processes, SQLite uses file system locks. The locking mechanisms also depend on SQLite configuration, like WAL mode. Refer to the SQLite documentation on locking for more information. Warning Linking... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
DuckDB 2.0 Documentation / man.mtool.work