Q. In Hive, what is the function of the LATERAL VIEW statement?
-
(A)
Sort the result set based on specified columns
-
(B)
Explode complex types in Hive tables
-
(C)
Group records based on a column
-
(D)
None of the above
✅ Correct Answer: (B)
Explode complex types in Hive tables