Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

name: op-agg-min
description: Smallest non-null value of the field.
kind: operator
category: AGG
operator: AGG_MIN
type: reference
applies_to: process, compose, predict
examples_tags: [financial, streaming-friendly]

Use when

Smallest value of a numeric or date field, over all rows or per group.

Questions it answers:

  • What is the earliest order date in each region?
  • Are there negative or impossible values in the age field?

Use something else:

  • AGG_MAX when you want the largest value.
  • AGG_PERCENTILE when one extreme row would mislead and you want a low value that ignores it.

Params

None.

Inputs

ParamAccepted field types
Fieldnumeric: u8/u16/u32/u64, f32/f64, decimal128, date, datetime, packed_bool, u4

Output

Scalar float64. Per-group when wired under a grouper.

Components

Universal floor {n, n_null} plus operator-specific:

KeyTypeNotes
minfloat64Smallest non-null value observed
  • Mergeability: Mergeable
  • Streaming: per-chunk emits running min

Gotchas

  • Null rows skipped; n_null counts them.
  • All-null cohort → emits NaN (sentinel for “no data”).
  • Decimal128 preserved on input; float64 output coerces the comparison space.

See