Kontext Copilot - An AI-powered assistant for data analytics that runs on your local computer. Learn more Get started

spark-sql-function

Spark SQL - flatten Function

event 2022-05-31 thumb_up 0 visibility 978 comment 0 insights

more_vert

warning Please login first to view stats information.

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

Code snippet

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]

copyright This page is subject to Site terms.

Spark SQL - flatten Function

insights Stats

Code snippet

Log in with external accounts

Spark SQL - flatten Function

insights Stats

Table of contents

Code snippet

Log in with external accounts