[HIVE-18448] Drop Support For Indexes From Apache Hive

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: Indexing
• Target Version/s: 3.0.0
• Assignee: Zoltan Haindrich
• Reporter: David Mollitor
• Created: 12/Jan/18 21:29
• Updated: 28/May/22 10:39
• Resolved: 14/Feb/18 10:00

Description

If a user needs to look up a small subset of records quickly, they can use Apache HBase, if they need fast retrieval of larger sets of data, or fast joins, aggregations, they can use Apache Impala. It seems to me that Hive indexes do not serve much of a role in the future of Hive.

Even without moving workloads to other products, columnar file formats with their statistics achieve similar goals as Hive indexes.

Please consider dropping Indexes from the Apache Hive project.

Issue Links

• is related to: HIVE-18496 Create tests to cover add/alter/drop index methods
• is related to: HIVE-21968 Remove index related codes
• is related to: HIVE-24815 Remove "IDXS" Table from Metastore Schema
• supercedes: HIVE-1502 finish the index design doc

Sub-Tasks

• Investigate usage of IndexPredicateAnalyzer in StorageHandlers: Open
• Remove index support from metastore: Closed