Results of 1 - 10 of about 50 for changes (0.001 sec.)
- Migrating to DuckDB 2.0 13460
- DuckDB 2.0.0 is packed with new features and performance improvements, including query optimization and asynchronous I/O. It also ships a small set of breaking changes, most notably a new default storage format, which DuckDB versions before
...e more care. We expect the most common source of issues to be the storage format, which is described first below. Breaking Changes Storage Format DuckDB versions before 2.0.0 cannot read database files that use the DuckDB 2.0.0 storage format. By defaul.... The database file was created with a newer version of DuckDB. Newer DuckDB version might introduce backward incompatible changes (possibly guarded by compatibility settings). See the storage page for migration strategy and more information: https://du...lendars and collations are now implemented natively by the icu extension , and will continue to behave as before. No query changes are required, but if you ship a custom build, note that ICU is no longer bundled. If you find that ICU's behavior changed,... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- ALTER VIEW Statement 13325
- The ALTER VIEW statement changes the schema of an existing view in the catalog. Examples Rename a view: ALTER VIEW view1 RENAME TO view2; ALTER VIEW changes the schema of an existing view. All the changes made by ALTER VIEW fully respect th
... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_view.html
- Transaction Management 10678
- DuckDB supports ACID database transactions . Transactions provide isolation, i.e., changes made by a transaction are not visible from concurrent transactions until it is committed. A transaction can also be aborted, which discards any changes
...fail. Rolling Back a Transaction You can abort a transaction. This operation, also known as rolling back, will discard any changes the transaction made to the database. To abort a transaction, run: ROLLBACK; You can also use the abort command, which has... - https://man.mtool.work/duckdb/2.0/sql/statements/transactions.html
- DuckLake 10257
- 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[]) │ var...following schema: Column name Column type snapshot_id BIGINT snapshot_time TIMESTAMP WITH TIME ZONE schema_version BIGINT changes MAP(VARCHAR, VARCHAR[]) author VARCHAR commit_message VARCHAR commit_extra_info VARCHAR ducklake_table_info The ducklake_t...ME ZONE no The schema of the table returned by the function is equivalent to that of the table table_name . ducklake_table_changes The ducklake_table_changes function returns the rows changed in a given table between snapshots of given versions or times... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- ALTER TABLE Statement 10121
- The ALTER TABLE statement changes the schema of an existing table in the catalog. Examples CREATE TABLE integers (i INTEGER, j INTEGER); Add a new column with name k to the table integers , it will be filled with the default value NULL : AL
...D PRIMARY KEY (i); Add a unique constraint to a column of a table: ALTER TABLE integers ADD UNIQUE (j); Syntax ALTER TABLE changes the schema of an existing table. All the changes made by ALTER TABLE fully respect the transactional semantics, i.e., they...ata for each row: ALTER TABLE integers ALTER i SET DATA TYPE VARCHAR USING concat(i, '_', j); The [SET [DATA]] TYPE clause changes the type of a column in a table. Any data present in the column is converted according to the provided expression in the U...ing NOT NULL ) on a table that has an index. Adding columns and setting or dropping column defaults are allowed. For other changes, drop the index, alter the table, and then recreate the index. Otherwise, you will get a Dependency Error . ADD PRIMARY KE... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_table.html
- Indexing 9144
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...column(s). The tradeoffs of having an ART index on a column are as follows: ART indexes enable constraint checking during changes (inserts, updates, and deletes). Changes on indexed tables perform worse than their non-indexed counterparts. That is beca...ning indexes can mitigate this effect, as we deserialize index memory lazily. Disabling index scans and re-attaching after changes can further decrease the impact of indexes on DuckDB's available memory. Indexes and Opening Databases Indexes are seriali... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
- CREATE TRIGGER Statement 8166
- New The CREATE TRIGGER feature was introduced in DuckDB 2.0. The CREATE TRIGGER statement registers a trigger: a set of SQL statements that run automatically in response to INSERT , UPDATE , or DELETE events on a table. Examples Record ever
...ON t FOR EACH ROW INSERT INTO log VALUES (NEW.id); INSERT INTO t VALUES (1), (2); SELECT * FROM log; Restrict a trigger to changes of specific columns with UPDATE OF : CREATE TRIGGER trg_price AFTER UPDATE OF price ON products FOR EACH STATEMENT INSERT...INTO price_changes DEFAULT VALUES; Drop a trigger: DROP TRIGGER trg_audit ON target; Drop a trigger if it exists: DROP TRIGGER IF EXISTS trg_... - https://man.mtool.work/duckdb/2.0/sql/statements/create_trigger.html
- INSERT Statements 7745
- INSERT statements are the standard way of loading data into a relational database. When using INSERT statements, the values are supplied row-by-row. While simple, there is significant overhead involved in parsing and processing individual I
...ta in a loop, avoid executing the statements in auto-commit mode. After every commit, the database is required to sync the changes made to disk to ensure no data is lost. In auto-commit mode every single statement will be wrapped in a separate transacti... - https://man.mtool.work/duckdb/2.0/data/insert.html
- Lakehouse Formats 7610
- Lakehouse formats, often referred to as open table formats, are specifications for storing data in object storage while maintaining some guarantees such as ACID transactions or keeping snapshot history. Over time, multiple lakehouse formats
...✅ Compaction and maintenance ✅ ✅ ❌ ✅ Encryption ✅ ❌ ❌ ❌ Manage table properties ✅ ✅ ✅ ** ❌ Time travel ✅ ✅ ✅ ❌ Query table changes ✅ ❌ ❌ ❌ * Through the unity_catalog extension. ** Table properties can be set when creating the table but cannot be altere... - https://man.mtool.work/duckdb/2.0/lakehouse_formats.html
- SET and RESET Statements 7610
- The SET statement modifies the provided DuckDB configuration option at the specified scope. Examples Update the memory_limit configuration value: SET memory_limit = '10GB'; Configure the system to use 1 thread: SET threads = 1; Or use the T
...SET GLOBAL threads = 4; Syntax SET updates a DuckDB configuration option to the provided value. RESET The RESET statement changes the given DuckDB configuration option to the default value. Scopes Configuration options can have different scopes: GLOBAL... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
DuckDB 2.0 Documentation / man.mtool.work