|Table of Contents|
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 resultsusing . Hive 2.3.0 adds support for materialzed views.
- Using columnar file formats (parquetParquet, orc) - they ORC) – they can do selective scanning; they may even skip entire files/blocks.
has been removed in version 3.0 (HIVE-18448).
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.