Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4935

A prototype planner/optimizer using term rewriting

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • Icebox
    • None

    Description

      Currently columnstore does not have explicit query optimization phase - the optimization process is spread across several modules, some of them rewrite the execution plan (using peephole optimization), some of them rule out some of the operations of execution plan (extent elimination is one example). And, while we have "analyze_table" query, currently we do not have necessary means to use its results in a straightforward way in a planning , let alone use them with ease.

      The goals for this particular task are twofold:

      1. create a framework for query optimization stage that can be easily integrable with various parts of columnstore's internal information and
      2. demonstrate its effectiveness on different queries of various complexity - effectiveness in the addition of transformations and effectiveness of the resulting execution plan.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MCOL-5620 Implement ColumnStore query optimizer

          • Major - Major loss of function.
          • Stalled
          includes

          New Feature - A new feature of the product, which has yet to be developed. MCOL-6036 Rewrite optimizer engine + CES parallel read rewrite rule

          • Major - Major loss of function.
          • Closed
          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MCOL-4821 ColumnStore Engine Monitoring and Metrics

          • Major - Major loss of function.
          • Open
          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MCOL-4557 Columnstore - Technical debts in Optimizer / Rewriter

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MCOL-5999 Query Accelerator | get innodb data faster

          • Major - Major loss of function.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MCOL-5620 Implement ColumnStore query optimizer

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5983 Bit-wise operations slower than expected

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Activity

            People

              leonid.fedorov Leonid Fedorov
              sergey.zefirov Sergey Zefirov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.