Explanation:
JSON and other semi-structured sources commonly contain arrays nested inside structs. Spark SQL array functions, such as explode, array_contains, transform, and filter, allow these nested arrays to be queried, flattened, and transformed directly. The other choices describe window functions, time functions, or general type handling rather than the primary purpose of array functions.
Which benefit is provided by array functions in Spark SQL?
A
An ability to work with data in a variety of types at once
B
An ability to work with data within certain partitions and windows
C
An ability to work with time-related data in specified intervals
D
An ability to work with complex, nested data ingested from JSON files
No comments yet.