Hive - Indexing Is Removed since 3.0

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.  Hive 2.3.0 adds support for materialzed views.
• Using columnar file formats (Parquet, ORC) – they can do selective scanning; they may even skip entire files/blocks.