Results of 1 - 10 of about 12 for Move (0.001 sec.)
- Editing 14663
- The linenoise-based CLI editor is available for macOS, Linux and Windows. DuckDB's CLI uses a line-editing library based on linenoise , which has shortcuts that are based on Emacs mode of readline . Below is a list of available commands. Yo
...u can also view these shortcuts from within the CLI using .help shortcuts . Moving Key Action Left Move back a character Right Move forward a character Up Move up a line. When on the first line, move to previous history entry...Down Move down a line. When on last line, move to next history entry Home Move to beginning of buffer End Move to end of buffer Ctrl...+ Left Move back a word Ctrl + Right Move forward a word Ctrl + A Move to beginning of line Ctrl + B Move back a character Ctrl + E Mo... - https://man.mtool.work/duckdb/2.0/clients/cli/editing.html
- Profile and Monitor 8808
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
...l interrupt_handle() on the connection to get an Arc<InterruptHandle> . InterruptHandle is both Send and Sync , so you can move it, or the connection, to another thread and call interrupt() from wherever is convenient. The interrupted query fails wit...ery(conn: Connection) -> Result<()> { let interrupt_handle = conn.interrupt_handle(); let join_handle = std::thread::spawn(move || { conn.execute("⟨expensive query⟩", []) }); // ... later, from this thread, cancel the query: interrupt_handle.interrup... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- FILTER Clause 8490
- The FILTER clause may optionally follow an aggregate function in a SELECT statement. This will filter the rows of data that are fed into the aggregate function in the same way that a WHERE clause filters rows, but localized to the specific
..., whereas a CASE WHEN expression can contribute NULL placeholders for those rows. However, FILTER does not automatically remove NULL values from rows that do satisfy the condition. To omit them, include an explicit condition on the aggregated value,...FROM ( SELECT i, count(*) OVER () AS rows FROM generate_series(1, 100_000_000) tbl(i) ) tbl; “Pivot” the data out by year (move each year out to a separate column): SELECT count(i) FILTER (year = 2022) AS "2022", count(i) FILTER (year = 2023) AS "202...LL values. The first function falls into this category, so FILTER is preferred in this case. “Pivot” the data out by year (move each year out to a separate column): SELECT first(i) FILTER (year = 2022) AS "2022", first(i) FILTER (year = 2023) AS "202... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/filter.html
- Extension Repositories 8348
- New Support for custom extension repositories was introduced in DuckDB 2.0. This feature is currently work-in-progress and the syntax may still change. By default, DuckDB installs extensions from its built-in repositories ( core , core_nigh
...positories is blocked and existing custom repositories are distrusted. While the database is running, the setting can only move from undecided to allowed or forbidden , or from allowed to forbidden . To opt in: SET allow_extension_repositories = 'all... - https://man.mtool.work/duckdb/2.0/extensions/extension_repositories.html
- Storage Versions and Format 8348
- Compatibility Backward Compatibility Backward compatibility refers to the ability of a newer DuckDB version to read storage files created by an older DuckDB version. Version 0.10 is the first release of DuckDB that supports backward compati
...mat, which DuckDB 2.0 uses by default for new database files. See Default Storage Version and the migration guide . How to Move between Storage Formats When you update DuckDB and open an old database file, you might encounter an error message about i...ncompatible storage formats, pointing to this page. To move your database(s) to newer format you only need the older and the newer DuckDB executable. Open your database file with the... - https://man.mtool.work/duckdb/2.0/internals/storage.html
- Migrating to DuckDB 2.0 8348
- 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
...between DuckDB versions and storage versions, see the Storage Versions and Format page . Converting Existing Databases To move an existing database file to the v2.0.0 storage format, open it with the older DuckDB version and export it, then import i....db -c "IMPORT DATABASE 'tmp'" For details on this and other conversion methods, including COPY FROM DATABASE , see How to Move between Storage Formats . Lambda Syntax DuckDB 2.0.0 takes the next step in the lambda syntax transition that began in v1....old syntax for the session: SET lambda_syntax = 'enable_single_arrow'; This flag is a temporary bridge: DuckDB 2.1 will remove it and the single arrow syntax entirely. For details, see Deprecated Syntax . SQL Parser DuckDB 2.0.0 replaced the Postgre... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- Release Cycle 8295
- This document outlines the DuckDB and core extension release cycle framework. It is intended for developers working on DuckDB extensions to better understand the underlying processes. Overview DuckDB follows Semantic Versioning ( v<MAJOR>.<
...ns For in-tree extensions , the release cycle is very simple. Since their code lives in the duckdb/duckdb repository, they move in complete lock-step with DuckDB. This means they share the same versioning and branching. In this sense they are not rea...e of these extensions tends to form a sometimes intricate dance around the main DuckDB release cycle. While the goal is to move as many extensions over to stable APIs, we expect unstable API extensions to be around for quite some time so there remain... - https://man.mtool.work/duckdb/2.0/dev/release_cycle.html
- DBeaver SQL IDE 8295
- DBeaver is a powerful and popular desktop SQL editor and integrated development environment (IDE). It has both an open source and enterprise version. DBeaver is useful for visually inspecting the available tables in DuckDB and for quickly b
...ager, select DuckDB, and click “Edit”. On the “Libraries” tab, click “Add File” and select the .jar file you downloaded. Remove any other entries in the list, or move the downloaded file to the top. Click “Find Class” and confirm that org.duckdb.Duck... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbeaver.html
- Import Data 8207
- Overview The Rust client offers two ways to get data into DuckDB in bulk: the high-performance Appender for inserting rows from Rust, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. Appender Th
...cannot report them. The Appender is Sync but not Send , because it borrows the Connection . To append from another thread, move the Connection to that thread and create the appender there. Appending Inside a Transaction For a large load, wrapping the... - https://man.mtool.work/duckdb/2.0/clients/rust/data_import.html
- Securing Extensions 8207
- DuckDB has a powerful extension mechanism, which has the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page
...lt: blocks adding new repositories, but keeps trusting existing ones). While the database is running, the setting can only move from 'undecided' to 'allowed' or 'forbidden' , or from 'allowed' to 'forbidden' . extension_repository_directory : the dir...s extensions and show adoption statistics like GitHub stars and download count. Because we manage the repository, we can remove problematic extensions from distribution quickly. Despite this, installing and loading DuckDB extensions from the communit... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
DuckDB 2.0 Documentation / man.mtool.work