Results of 1 - 9 of about 9 for compact (0.001 sec.)
- Agent Mode 13373
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...swer;" To force it off: duckdb -no-agent -c "SELECT 42 AS answer;" Output Format In agent mode, DuckDB: Renders results as compact Markdown tables. Prints a footer with the row count and, when the whole result was read, an order-independent hash of the...result. Emits errors as JSON on stderr . Renders compact query plans and cost estimates. Prints an estimate line and progress on stderr for a query that reads more than 1,000,000... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- Command Line 10012
- Unexpected Markdown Output When Piping If the output of the command line client is piped to another process and an AI agent environment variable (such as AI_AGENT ) is set, the CLI switches to agent mode and prints compact Markdown tables i
... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/command_line.html
- Reclaiming Space 10012
- DuckDB uses a single-file format, which has some inherent limitations w.r.t. reclaiming disk space. CHECKPOINT To reclaim space after deleting rows, use the CHECKPOINT statement . VACUUM The VACUUM statement does not trigger vacuuming delet
...es and hence does not reclaim space. Compacting a Database by Copying To compact the database, you can create a fresh copy of the database using the COPY FROM DATABASE... - https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/reclaimi...
- Guides 8340
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
... - https://man.mtool.work/duckdb/2.0/guides/overview.html
- What's New in the Docs for 2.0 8106
- 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
...partition subdirectories The ORDER_BY copy option for sorting rows before writing Clients 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 s... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Writing to Iceberg 7855
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...s, DuckDB-Iceberg writes positional deletes as Parquet files; in v3 tables, the same information is encoded as a much more compact binary deletion vector ( Puffin file ). DuckDB picks the right format automatically based on the table's format-version .... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Create Synthetic Data 7855
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...──┘ Cross Products A cross product (Cartesian product) multiplies rows from two sources, so combining two range calls is a compact way to produce a large number of rows: SELECT i, j FROM range(1, 3) s(i) CROSS JOIN range(1, 3) t(j); Generating Values Ra... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Friendly SQL 7855
- DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features were first introduced by DuckDB, while some are inspired by other
...ry of the schema of a table or query. SUMMARIZE : returns summary statistics for a table or query. Making SQL clauses more compact and readable: FROM -first syntax with an optional SELECT clause : DuckDB allows queries in the form of FROM tbl which sele... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
- Vector Similarity Search Extension 7369
- The vss extension is an experimental extension for DuckDB that adds indexing support to accelerate vector similarity search queries using DuckDB's new fixed-size ARRAY type. See the announcement blog post and the “What's New in the Vector S
...some time, but it should still be faster than simply dropping and re-creating the index. Inserts, Updates, Deletes and Re-Compaction The HNSW index does support inserting, updating and deleting rows from the table after index creation. However, there a...tale over time and negatively impact query quality and performance. To remedy the last point, you can call the PRAGMA hnsw_compact_index('⟨index_name⟩') pragma function to trigger a re-compaction of the index pruning deleted items, or re-create the inde... - https://man.mtool.work/duckdb/2.0/core_extensions/vss.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work