Results of 1 - 4 of about 4 for iterator (0.002 sec.)
- Handle Results 12408
- 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
...ach the Arrow types through duckdb::arrow . Reading a Result 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::{C...tatement 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. For a result that should be consumed lazily, fetching chunks only as the iterator advance...tln!("{} rows", batch.num_rows()); } DuckDB may still materialize the result internally for some statements. The streaming iterator panics if fetching or Arrow conversion fails after execution has started. Querying an Arrow Batch An Arrow RecordBatch pro... - https://man.mtool.work/duckdb/2.0/clients/rust/result_handling.html
- Import Data 8451
- 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
...foo")?; app.append_row(params![1, 2])?; app.append_row(params![3, 4])?; app.flush()?; Ok(()) } To append many rows from an iterator of parameter lists in one call, use append_rows() : app.append_rows([[1, 2], [3, 4], [5, 6], [7, 8], [9, 10]])?; Additiona... - https://man.mtool.work/duckdb/2.0/clients/rust/data_import.html
- Run Queries 8340
- 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
...-based index with row.get() , whose return type is inferred from the struct field it is assigned to. query_map() yields an iterator of Result , which can be collected into a Vec : #[derive(Debug)] struct Person { id: i32, name: String, data: Option<Vec<u... - https://man.mtool.work/duckdb/2.0/clients/rust/querying.html
- Python Client API 7748
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...ation object in other_rel. Detailed examples can be found at Relational API page . iter_rows ( batch_size : int = 1024 ) → Iterator [ tuple [ Any , ... ] ] Every row, a batch at a time, over one run of the relation. The rows are read once into the engine... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work