Explanation:
The explode function in SQL is designed to transform an array (or map) by creating a new row for each element within that array. This is particularly useful in data transformation tasks where it's necessary to flatten nested data structures for easier analysis.
Ultimate access to all questions.
What is the primary function of the explode function in SQL?
A
To merge multiple rows into a single array field.
B
To expand each element of an array field into individual rows.
C
To generate a database backup.
D
To remove elements from an array field.
No comments yet.