Q. In Hive, what is the role of the INDEX clause in a CREATE TABLE statement?
-
(A)
Group records based on a column
-
(B)
Sort the result set based on specified columns
-
(C)
Filter records based on a condition
-
(D)
Create an index on a specified column
✅ Correct Answer: (D)
Create an index on a specified column