CARDINALITY (Array, Lakehouse v2)
Returns the number of elements in an array. Alias for ARRAY_LENGTH.
Analyze Syntax
Section titled “Analyze Syntax”func.cardinality([1, 2, 3])Analyze Examples
Section titled “Analyze Examples”func.cardinality([10, 20, 30])
┌───┐│ 3 │└───┘SQL Syntax
Section titled “SQL Syntax”CARDINALITY([1, 2, 3])SQL Examples
Section titled “SQL Examples”SELECT CARDINALITY([10, 20, 30]);
┌───┐│ 3 │└───┘