Spark SQL - flatten Function

visibility 567 event 2022-05-31 access_time 2 years ago language English

thumb_up 0

more_vert

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]

Log in with external accounts

toc Table of contents

Code snippet

insights Stats

warning Please login first to view stats information.

tag Spark SQL Functions

article Spark SQL - Extract Value from JSON String article Spark SQL - Check if String Contains a String article Spark SQL - Date/Timestamp Conversation from/to UNIX Date/Timestamp article Spark SQL - LAG Window Function article Spark SQL - DENSE_RANK Window Function Read more (46)