70. Which function turns a single row containing an ARRAY of 5 items into 5 separate rows? | Databricks Certified Data Engineer - Associate Quiz - LeetQuiz
Databricks Certified Data Engineer - Associate
Explanation:
The explode() function in Spark SQL takes an array (or map) column and returns a new row for each element in the given array, effectively expanding a single row with an array of 5 items into 5 distinct rows.
Get started today
Ultimate access to all questions.
Which function turns a single row containing an ARRAY of 5 items into 5 separate rows?