Indexes

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)

Introduction

This document explains the proposed design for adding index support to Hive (HIVE-417). Indexing is a standard database technique, but with many possible variations. Rather than trying to provide a "one-size-fits-all" index implementation, the approach we are taking is to define indexing in a pluggable manner (related to StorageHandlers) and provide one concrete indexing implementation as a reference, leaving it open for contributors to plug in other indexing schemes as time goes by. No index support will be available until Hive 0.7.

...