Spark SQL - flatten Function

event 2022-05-31 visibility 978 comment 0 insights
more_vert
insights Stats
Spark SQL - flatten Function
Kontext Kontext Code Snippets & Tips

Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise. 

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)));
Results:
[1,2,3,4,5,6,7,8]


More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts