Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-4158

Make Secondary Index as a coarse grain datamap and use secondary indexes for Presto queries

    XMLWordPrintableJSON

    Details

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

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              VenuReddy Venugopal Reddy K
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 13h 10m
                13h 10m