Which of the following is the most effective method for improving query performance on large Hive tables?

Which of the following is the most effective method for improving query performance on large Hive tables?
A . Indexing
B . Bucketing
C . Partitioning
D . De-normalizing data

View Answer

Answer: B

Explanation:

Reference: https://dzone.com/articles/how-to-improve-hive-query-performance-with-hadoop