Skip to main content

ColumnarQueryResult

Struct ColumnarQueryResult 

Source
pub struct ColumnarQueryResult {
    pub columns: Vec<String>,
    pub data: Vec<TypedColumn>,
    pub row_count: usize,
    pub bytes_read: usize,
}
Expand description

Columnar query result - SIMD-friendly format for analytics

Instead of row-oriented Vec<HashMap<String, SochValue>>, this returns column-oriented Vec<TypedColumn> for efficient vectorized operations.

§Memory Layout

Row-oriented (standard):

Row 0: [id=1, name="Alice", score=85]
Row 1: [id=2, name="Bob", score=92]
Row 2: [id=3, name="Carol", score=78]

Column-oriented (this format):

id:    [1, 2, 3]           ← contiguous i64 array (SIMD-friendly)
name:  ["Alice", "Bob", "Carol"] ← Arrow-style string encoding
score: [85, 92, 78]        ← contiguous i64 array

§Performance Benefits

  • SIMD: Column sums use vectorized instructions (~8× faster)
  • Cache: Sequential access pattern maximizes L1/L2 cache hits
  • Compression: Same-type data compresses better (5-10× typical)
  • Filtering: Bitmap operations instead of row iteration

§Usage

let result = db.query(txn, "users")
    .columns(&["id", "score"])
    .as_columnar()?;

// SIMD sum
let total_score = result.column("score")
    .map(|c| c.sum_i64())
    .unwrap_or(0);

// Stats
println!("Rows: {}, Memory: {} bytes", result.row_count(), result.memory_size());

Fields§

§columns: Vec<String>

Column names in order

§data: Vec<TypedColumn>

Column data - each TypedColumn contains all values for one column

§row_count: usize

Number of rows

§bytes_read: usize

Bytes read from storage

Implementations§

Source§

impl ColumnarQueryResult

Source

pub fn empty() -> Self

Create an empty result

Source

pub fn column(&self, name: &str) -> Option<&CoreTypedColumn>

Get column by name

Source

pub fn column_index(&self, name: &str) -> Option<usize>

Get column index by name

Source

pub fn row_count(&self) -> usize

Number of rows

Source

pub fn column_count(&self) -> usize

Number of columns

Source

pub fn memory_size(&self) -> usize

Total memory size in bytes

Source

pub fn sum_i64(&self, column: &str) -> Option<i64>

Sum of an i64 column (SIMD-optimized)

Source

pub fn sum_f64(&self, column: &str) -> Option<f64>

Sum of an f64 column (SIMD-optimized)

Source

pub fn row_view(&self, index: usize) -> Option<ColumnarRowView<'_>>

Zero-allocation row access by index.

Returns a lightweight view that resolves column values on demand from the underlying columnar arrays — no HashMap per row.

let result = query.as_columnar()?;
for i in 0..result.row_count() {
    let row = result.row_view(i).unwrap();
    let name = row.get("name"); // SochValue::Text(...)
}
Source

pub fn into_query_result(self) -> QueryResult

Convert to row-oriented QueryResult for backward compatibility.

This materialises one HashMap<String, SochValue> per row, so prefer using row_view() or direct columnar access when performance matters.

Source

pub fn column_stats(&self, column: &str) -> Option<&ColumnStats>

Get column statistics (min, max, null count)

Source

pub fn to_toon(&self) -> String

Convert to TOON format (token-efficient)

Trait Implementations§

Source§

impl Clone for ColumnarQueryResult

Source§

fn clone(&self) -> ColumnarQueryResult

Returns a duplicate of the value. Read more
1.0.0 (const: unstable) · Source§

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source. Read more
Source§

impl Debug for ColumnarQueryResult

Source§

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more

Auto Trait Implementations§

Blanket Implementations§

Source§

impl<T> Allocation for T
where T: RefUnwindSafe + Send + Sync,

Source§

impl<T> Any for T
where T: 'static + ?Sized,

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

impl<T> Borrow<T> for T
where T: ?Sized,

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

impl<T> BorrowMut<T> for T
where T: ?Sized,

Source§

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more
Source§

impl<ST, DT> CastableFrom<ST, Initialized, Initialized> for DT
where ST: ?Sized, DT: ?Sized,

Source§

impl<ST, DT> CastableFrom<ST, Uninit, Uninit> for DT
where ST: ?Sized, DT: ?Sized,

Source§

impl<T> CloneToUninit for T
where T: Clone,

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. Read more
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T> Instrument for T

Source§

fn instrument(self, span: Span) -> Instrumented<Self>

Instruments this type with the provided Span, returning an Instrumented wrapper. Read more
Source§

fn in_current_span(self) -> Instrumented<Self>

Instruments this type with the current Span, returning an Instrumented wrapper. Read more
Source§

impl<T, U> Into<U> for T
where U: From<T>,

Source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

Source§

impl<T> IntoEither for T

Source§

fn into_either(self, into_left: bool) -> Either<Self, Self>

Converts self into a Left variant of Either<Self, Self> if into_left is true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
Source§

fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
where F: FnOnce(&Self) -> bool,

Converts self into a Left variant of Either<Self, Self> if into_left(&self) returns true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
Source§

impl<T> Pointable for T

Source§

const ALIGN: usize

The alignment of pointer.
Source§

type Init = T

The type for initializers.
Source§

unsafe fn init(init: <T as Pointable>::Init) -> usize

Initializes a with the given initializer. Read more
Source§

unsafe fn deref<'a>(ptr: usize) -> &'a T

Dereferences the given pointer. Read more
Source§

unsafe fn deref_mut<'a>(ptr: usize) -> &'a mut T

Mutably dereferences the given pointer. Read more
Source§

unsafe fn drop(ptr: usize)

Drops the object pointed to by the given pointer. Read more
Source§

impl<T> Read<Exclusive, BecauseExclusive> for T
where T: ?Sized,

Source§

impl<T> Same for T

Source§

type Output = T

Should always be Self
Source§

impl<T> ToOwned for T
where T: Clone,

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more
Source§

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more
Source§

impl<T, U> TryFrom<U> for T
where U: Into<T>,

Source§

type Error = Infallible

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

Performs the conversion.
Source§

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

Source§

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.
Source§

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.
Source§

impl<V, T> VZip<V> for T
where V: MultiLane<T>,

Source§

fn vzip(self) -> V

Source§

impl<T> WithSubscriber for T

Source§

fn with_subscriber<S>(self, subscriber: S) -> WithDispatch<Self>
where S: Into<Dispatch>,

Attaches the provided Subscriber to this type, returning a WithDispatch wrapper. Read more
Source§

fn with_current_subscriber(self) -> WithDispatch<Self>

Attaches the current default Subscriber to this type, returning a WithDispatch wrapper. Read more