Table of Contents |
---|
Indexing is removed since 3.0
There are alternate options which might work similarily to indexing:
- Materialized views with automatic rewriting can result in very similar results
- using columnar file formats (parquet,orc) - they can do selective scanning; they may even skip entire files/blocks
Indexing have been removed in version 3.0 (HIVE-18448)
Overview of Hive Indexes
The goal of Hive indexing is to improve the speed of query lookup on certain columns of a table. Without an index, queries with predicates like 'WHERE tab1.col1 = 10' load the entire table or partition and process all the rows. But if an index exists for col1, then only a portion of the file needs to be loaded and processed.
...