Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4569 Queries with UNION ALL perform disproportionally badly
  3. MCOL-4589

Optimize out columns in a subquery involving a UNION which are not referenced in the outer select

    XMLWordPrintable

Details

    • Sub-Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 5.6.1
    • MDB Plugin
    • None
    • 2021-4

    Description

      This task is similar to MCOL-4543, but for subqueries involving a UNION. I.e., If query Q1 is of the form:

      SELECT count(c2) FROM (SELECT * FROM t1 UNION ALL SELECT * FROM t1)q;
      

      Assuming t1 here contains 10 columns c1, c2, ... , c10. We build an ineffective RowGroup in ExeMgr of the form (1, c2_value1, 1, 1, 1, 1, 1, 1, 1, 1). The objective here is to remove all non-referenced columns from the end, until the first referenced column is encountered, i.e. trim down the RowGroup to (1, c2_value1).

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            tntnatbry Gagan Goel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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