Results of 1 - 10 of about 11 for history (0.002 sec.)
- Editing 13656
- 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
...tion 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 en...Ctrl + E Move to end of line Ctrl + F Move forward a character Alt + Left Move back a word Alt + Right Move forward a word History Key Action Ctrl + P Move to previous history entry Ctrl + N Move to next history entry Ctrl + R Reverse search the history...Ctrl + S Forward search the history Ctrl + Up Move to first history entry Ctrl + Down Move to last history entry Alt + N Search the history Alt + P Search the... - https://man.mtool.work/duckdb/2.0/clients/cli/editing.html
- Dot Commands 10295
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...Toggle highlighting in result tables on / off (duckbox only). See the result syntax highlighting section for more details .history ⟨N⟩ Show the command history with syntax highlighting. If N is given, only the last N entries are shown. See the command h...arguments. .dump %swim% The --newlines option allows unescaped newline characters in the output: .dump --newlines Command History New As of DuckDB 2.0, the .history dot command and the shell_history() table function are available in the command line cl...ient. The .history command shows the previously executed statements with syntax highlighting: .history To show only the last ⟨N⟩ entries, pas... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Files Created by DuckDB 9815
- DuckDB creates several files and directories on disk. This page lists both the global and the local ones. Global Files and Directories DuckDB creates the following global files and directories in the user's home directory (denoted with ~ ):
...tatements. The naming of this file follows the ~/.bashrc and ~/.zshrc “run commands” files. Yes Only used by CLI ~/.duckdb_history History file, similar to ~/.bash_history and ~/.zsh_history . Used by the DuckDB CLI client . Yes Only used by CLI ~/.duck... - https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/files_cr...
- Window Functions 8908
- DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o
...using the same ordering clause. Here is a table of power generation data, available as a CSV file ( power-plant-generation-history.csv ). To load the data, run: CREATE TABLE "Generation History" AS FROM 'power-plant-generation-history.csv'; After partit...sing the query: SELECT "Plant", "Date", row_number() OVER (PARTITION BY "Plant" ORDER BY "Date") AS "Row" FROM "Generation History" ORDER BY 1, 2; The result will be the following: Plant Date Row Boston 2019-01-02 1 Boston 2019-01-03 2 Boston 2019-01-04...ASC RANGE BETWEEN INTERVAL 3 DAYS PRECEDING AND INTERVAL 3 DAYS FOLLOWING) AS "MWh 7-day Moving Average" FROM "Generation History" ORDER BY 1, 2; This query partitions the data by Plant (to keep the different power plants' data separate), orders each p... - https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
- Merge Statement for SCD Type 2 8641
- This is a practical, step-by-step guide to using DuckDB's MERGE statement (introduced in v1.4.0) to perform upserts and build Slowly Changing Dimension Type 2 (SCD Type 2) tables . Type 2 SCDs let you keep full historical versions of record
...r INSERT , UPDATE , and soft DELETE (upsert and expire). Much cleaner and faster than equivalent Python/Pandas logic. Full history tracking without hard deletes. Works directly on Parquet, CSV, databases, thanks to DuckDB's connectivity! Prerequisites B...shows what happened to each row (INSERT/UPDATE/DELETE) Build an SCD Type 2 Dimension Table We'll track ducks and preserve history whenever their name, breed, or location changes. DuckDB has a frontend notebook UI, this is great for managing several SQL...LL, true); Step 2: Create the Master (target) Table This table represents the type 2 SCD data (i.e., transaction data with history). CREATE TABLE IF NOT EXISTS master_ducks ( record_id INTEGER PRIMARY KEY, duck_id INTEGER NOT NULL, duck_name VARCHAR, br... - https://man.mtool.work/duckdb/2.0/guides/sql_features/merge.html
- What's New in the Docs for 2.0 8286
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...CLI agent mode , which produces compact, machine-readable output when the CLI is driven by an AI coding agent CLI command history : the .history command and the shell_history() table function Pretty-printed, highlighted .schema output with --no-indent... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Subqueries 8019
- Subqueries are parenthesized query expressions that appear as part of a larger, outer query. Subqueries are usually based on SELECT ... FROM , but in DuckDB other query constructs such as PIVOT can also appear as a subquery. Scalar Subquery
...grades WHERE course = 'Math') AS math_grades_present; math_grades_present true SELECT EXISTS (FROM grades WHERE course = 'History') AS history_grades_present; history_grades_present false The subqueries in the examples above make use of the fact that y... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- CREATE SECRET Statement 8019
- The CREATE SECRET statement creates a new secret in the Secrets Manager . Syntax for CREATE SECRET Warning When using the command line client , the CREATE SECRET statements are stored in your DuckDB history as plain text. Syntax for DROP SE
... - https://man.mtool.work/duckdb/2.0/sql/statements/create_secret.html
- Iceberg Functions 7610
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...s of an Iceberg table snapshot. iceberg_manifests(source) Returns the manifest files of an Iceberg table snapshot. iceberg_history(source) Returns the history of the table's current snapshot. iceberg_refs(source) Returns the branches and tags of an Iceb...c ID, the snapshot that added it, counts of added/existing/deleted data and delete files, and partition summaries. iceberg_history(source) Returns the snapshot log of the table with the columns made_current_at , snapshot_id , parent_id and is_current_an... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- Lakehouse Formats 7468
- 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
... - https://man.mtool.work/duckdb/2.0/lakehouse_formats.html
DuckDB 2.0 Documentation / man.mtool.work