Function arrow::compute::nullif

source ·
pub fn nullif(
    left: &dyn Array,
    right: &BooleanArray,
) -> Result<Arc<dyn Array>, ArrowError>
Expand description

Returns a new array with the same values and the validity bit to false where the corresponding element ofright is true.

This can be used to implement SQL NULLIF

§Example

// input is [null, 8, 1, 9]
let a = Int32Array::from(vec![None, Some(8), Some(1), Some(9)]);
// use nullif to set index 1 to null
let bool_array = BooleanArray::from(vec![Some(false), Some(true), Some(false), None]);
let nulled = nullif(&a, &bool_array).unwrap();
// The resulting array is [null, null, 1, 9]
assert_eq!(nulled.as_primitive(), &Int32Array::from(vec![None, None, Some(1), Some(9)]));