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

...

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.

...