[CARBONDATA-4158] Make Secondary Index as a coarse grain datamap and use secondary indexes for Presto queries

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.2.0

Docs Text

Link to community discussion -
http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/Discussion-Presto-Queries-leveraging-Secondary-Index-tt105291.html

Link to design document - https://docs.google.com/document/d/1VZlRYqydjzBXmZcFLQ4Ty-lK8RQlYVDoEfIId7vOaxk/edit#

• Assignee: Unassigned
• Reporter: Venugopal Reddy K
• Created: 30/Mar/21 11:42
• Updated: 22/Apr/21 07:10
• Resolved: 22/Apr/21 07:10

Description

Background:

Secondary Indexes are created as carbon tables and are managed as child tables to the main table. And these indexes are leveraged for query pruning via spark plan modification during optimizer/execution phases of query execution. In order to make use of Secondary Indexes for queries from engines other than spark like presto etc, it is not feasible to modify the engine specific query execution plans as we desire in the current approach. It makes Secondary Indexes not usable for presto query pruning. Thus need arises for an engine agnostic approach to use Secondary Indexes for presto queries.

Description:

Current Secondary Index pruning is tightly coupled with spark because the query plan modification is specific to the spark engine. It is hard to reuse the solution for presto queries. Need a new solution to use secondary indexes with Presto queries. And it  shouldn’t affect the existing customer using secondary index with spark.

Sub-Tasks

• Secondary Index coarse grain datamap to work for existing Secondary Index tables: Open