Spark SQL - flatten Function

As many other programming frameworks, flatten is usually used to translate an array of arrays to a single array. In Spark SQL, a built in function flatten can be used to flatten arrays.

Code snippet

SELECT flatten(array(array(1, 2), array(3, 4, 5), array(6, 7), array(8)));