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

Evaluation for Cross Engine Join only single-table queries processing

    XMLWordPrintable

Details

    • New Feature
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      This issue describes a new feature enables processing of foreign engines queries, e.g. InnoDB. Consider a query 

      SELECT count(*) from non_mcs where c1 > 5;

      or

      SELECT count(*) from non_mcs1 t1, non_mcs2 t2 where t1.c1 = t2.c1;

      Given there is a mechanism to hand such queries over to MCS SELECT handler one has to alter a number of facilities to enable processing for single table queries.
      This issue is supposed to deliver evaluation for a single foreign table query performance, .e.g count() with an explicit GROUP BY uses key columns that don't belong to Innodb index.
      The mentioned handover mechanism in the context of this issue would be a temporary shortcut that conditionally hands over processing of a query down to MCS.
      As of now CrossEngineStep is an equivalent of TBPS that implements TupleDeliveryStep interface thus can be the source step of a JobList.

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MCOL-5876 Evaluation for Cross Engine Join only multi-table queries processing

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

          New Feature - A new feature of the product, which has yet to be developed. MCOL-5882 Research statistics and partitioning methods available for innodb table

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MCOL-5883 Remove locale-related funcs used by dataconvert for CES data ingestion

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5917 Query Accelerator | large dataset retrieval bug

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              drrtuy Roman
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.