Accelerate query execution using indexes
----------------------------------------
Key: HIVE-1694
URL: https://issues.apache.org/jira/browse/HIVE-1694
Project: Hadoop Hive
Issue Type: New Feature
Components: Indexing, Query Processor
Affects Versions: 0.7.0
Reporter: Nikhil Deshpande
The index building patch (Hive-417) is checked into trunk, this JIRA issue
tracks supporting indexes in Hive compiler & execution engine for SELECT
queries.
This is in ref. to John's comment at
https://issues.apache.org/jira/browse/HIVE-417?focusedCommentId=12884869&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_12884869
on creating separate JIRA issue for tracking index usage in optimizer & query
execution.
The aim of this effort is to use indexes to accelerate query execution (for
certain class of queries). E.g.
- Filters and range scans (already being worked on by He Yongqiang as part of
HIVE-417?)
- Joins (index based joins)
- Group By, Order By and other misc cases
The proposal is multi-step:
1. Building index based operators, compiler and execution engine changes
2. Optimizer enhancements (e.g. cost-based optimizer to compare and choose
between index scans, full table scans etc.)
This JIRA initially focuses on the first step. This JIRA is expected to hold
the information about index based plans & operator implementations for above
mentioned cases.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
