Results of 1 - 10 of about 43 for whole (0.002 sec.)
- Agent Mode 15009
- 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
...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...err for a query that reads more than 1,000,000 rows. By default, a result of up to 1,000 rows and 10,000 bytes is rendered whole; a larger result is rendered as its first and last rows together with the total row count. Cells are truncated at 500 char...These limits can be adjusted with dot commands : Dot command Description .maxrows ⟨count⟩ Maximum number of rows to render whole ( -1 for all) .maxbytes ⟨count⟩ Maximum number of bytes of rows to render whole ( 0 for all) .maxcellwidth ⟨count⟩ Maximum... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- Subqueries 10119
- 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
...LL , ANY and SOME . The quantifiers ANY and SOME are equivalent. ALL The ALL quantifier specifies that the comparison as a whole evaluates to true when the individual comparison results of the expression at the left hand side of the comparison operato...s not greater than or equal to the subquery result 9. And thus, because not all comparisons evaluate to true , >= ALL as a whole evaluates to false . ANY The ANY quantifier specifies that the comparison as a whole evaluates to true when at least one o... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- Time Functions 9887
- This section describes functions and operators for examining and manipulating TIME values . Time Operators The table below shows the available mathematical operators for TIME types. Operator Description Example Result + addition of an INTER
...tract ). date_sub(part, starttime, endtime) The signed length of the interval between starttime and endtime , truncated to whole multiples of part . extract(part FROM time) Get subfield from a time. get_current_time() Current time (start of current tr...b(part, starttime, endtime) | Description | The signed length of the interval between starttime and endtime , truncated to whole multiples of part . | | Example | date_sub('hour', TIME '01:02:03', TIME '06:01:03') | | Result | 4 | | Alias | datesub |... - https://man.mtool.work/duckdb/2.0/sql/functions/time.html
- Connect 9641
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...ingle daemon thread named duckdb-query-cancel-scheduler-thread in the JVM the first time it is loaded. It is shared by the whole process and is used to fire Statement.setQueryTimeout() cancellations. Applications that unload the driver, for example in...password. Read-Only Lakes on Object Storage When both the catalog database and the data files live in object storage, the whole lake can be attached read-only without any local files, a setup often called a “frozen” lake. This works for a DuckDB or S...o reach, such as the same bucket or public host. Once attached or opened, DuckLake tables behave like local tables, so the whole JDBC API applies to them, including the Appender . Note that DuckLake, like other lakehouse formats, does not support inde... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Quack Remote Protocol 9641
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...ide Usage There are three ways to talk to a Quack server: ATTACH 'quack:host' AS name followed by CONNECT name : route the whole session to the remote . This is the recommended approach. ATTACH 'quack:host' AS name : attach the remote as a full catalo...'); ATTACH binds the remote's table definitions on the client, so a single table definition that cannot be bound fails the whole attachment. If this happens (for example, with an Iceberg catalog using lazy table resolution), see ATTACH Fails to Bind a...Remote Table Definition . Routing a Session with CONNECT Once a remote is attached, the CONNECT statement routes the whole session to it, so that subsequent queries execute on the server and their results stream back. This is the recommended way... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Handle Results 9394
- Overview Beyond reading a result set row by row , the Rust client can hand a query result to Apache Arrow as a stream of record batches, register an Arrow batch as a queryable table, and return results as Polars data frames. Each of these c
...ult as Arrow Call query_arrow() on a prepared statement to get an iterator of RecordBatch . Collecting it materializes the whole result, while iterating it reads one batch at a time: use duckdb::{Connection, Result}; use duckdb::arrow::record_batch::R...ema DuckDB inferred for the result. Streaming Arrow Results query_arrow() runs the statement to completion and buffers the whole result on the client side, so a large result is held in memory even while the iterator is advanced one batch at a time. Fo... - https://man.mtool.work/duckdb/2.0/clients/rust/result_handling.html
- Numeric Types 9147
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...in an error. The types UTINYINT , USMALLINT , UINTEGER , UBIGINT and UHUGEINT store whole unsigned numbers. Attempts to store negative numbers or values outside of the allowed range will result in an error. Name...y the WIDTH is specified, the SCALE defaults to 0 – for example, DECIMAL(18) is equivalent to DECIMAL(18, 0) and rounds to whole numbers (e.g., 1.5::DECIMAL(18) is 2 ). Specifying the WIDTH and the SCALE Both parameters are optional, and a trailing co... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- MERGE INTO Statement 8900
- The MERGE INTO statement is an alternative to INSERT INTO ... ON CONFLICT that doesn't need a primary key since it allows for a custom match condition. This is a very useful alternative for upserting use cases ( INSERT + UPDATE ) when the d
...ary FLOAT); INSERT INTO people VALUES (1, 'John', 92_000.0), (2, 'Anna', 100_000.0); The simplest upsert would be to use a whole row in the USING clause. This way, if there is a match, the row can be updated to the new row without further instuctions...le ORDER BY id; id name salary 1 John 105000.0 2 Anna 100000.0 3 Sarah 95000.0 In the previous example we are updating the whole row if id matches. However, it is also a common pattern to receive a change set with some keys and the changed value. This... - https://man.mtool.work/duckdb/2.0/sql/statements/merge_into.html
- Run Queries 8669
- Overview A Connection runs SQL through two families of methods: The execute_* methods ( execute() and execute_batch() ) send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. The query_* meth
...lumn row into a tuple: let count = conn.query_row( "SELECT count(*) FROM person", [], |row| row.get::<_, i64>(0), )?; // A whole row can be converted to a tuple in one step. let (n,) = conn.query_row("SELECT count(*) FROM person", [], |row| { <(i64,)>...on-exhaustive, so a match over them should include a wildcard arm to stay forward-compatible as DuckDB adds types. To read whole result sets as columnar batches instead of row by row, see Handle Results . Further Reading Handle Results — reading resul... - https://man.mtool.work/duckdb/2.0/clients/rust/querying.html
- Working with Huge Databases 8669
- This page contains information for working with huge DuckDB database files. While most DuckDB databases are well below 1 TB, in our 2024 user survey , 1% of respondents used DuckDB files of 2 TB or more (corresponding to roughly 10 TB of CS
...y immutable Parquet files instead of a single database file, it sidesteps the object-storage file-size limits and the slow whole-database checkpoints described above, while still providing transactional guarantees.... - https://man.mtool.work/duckdb/2.0/guides/performance/working_with_huge_databases...
DuckDB 2.0 Documentation / man.mtool.work