Skip to main content

insert_record_batch_reader

Function insert_record_batch_reader 

Source
pub fn insert_record_batch_reader(
    conn: &Connection,
    dest_table: &str,
    stream_name: &str,
    reader: Box<dyn RecordBatchReader + Send>,
    options: InsertOptions,
) -> Result<()>
Expand description

Insert from any RecordBatchReader via register_arrow_stream, or direct FFI when available.

See insert_record_batch for dest_table constraints.

ยงExamples

use std::sync::Arc;
use arrow::array::{Int64Array, RecordBatch, RecordBatchIterator};
use arrow::datatypes::{DataType, Field, Schema};
use chdb_rust::arrow_insert::insert_record_batch_reader;
use chdb_rust::InsertOptions;
use chdb_rust::connection::Connection;

let conn = Connection::open_in_memory()?;
conn.query(
    "CREATE TABLE metrics (id Int64) ENGINE=MergeTree ORDER BY id",
    chdb_rust::format::OutputFormat::TabSeparated,
)?;

let schema = Arc::new(Schema::new(vec![Field::new("id", DataType::Int64, false)]));
let batch = RecordBatch::try_new(
    Arc::clone(&schema),
    vec![Arc::new(Int64Array::from(vec![1i64, 2]))],
)
.map_err(|e| chdb_rust::error::Error::QueryError(e.to_string()))?;
let reader = RecordBatchIterator::new(vec![Ok(batch)].into_iter(), schema);

insert_record_batch_reader(
    &conn,
    "metrics",
    "flush_reader",
    Box::new(reader),
    InsertOptions::default_bulk(),
)?;