ARRAY_FLATTEN (Lakehouse v2)
Flattens nested arrays into a single-level array.
Analyze Syntax
Section titled “Analyze Syntax”func.array_flatten([[1,2],[3,4]])Analyze Examples
Section titled “Analyze Examples”func.array_flatten([[1, 2], [3, 4]])
┌───────────┐│ [1,2,3,4] │└───────────┘SQL Syntax
Section titled “SQL Syntax”ARRAY_FLATTEN([[1,2],[3,4]])SQL Examples
Section titled “SQL Examples”SELECT ARRAY_FLATTEN([[1, 2], [3, 4]]);
┌───────────┐│ [1,2,3,4] │└───────────┘