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

Handle UNION pushdown edge case that triggers slow table mode processing

    XMLWordPrintable

Details

    Description

      Sometimes queries runs slow , but suddenly runs fast without "order by" clause
      or wrapping into a subselect like select * from (<select query>)
      Even every case must be fixed , it should be a possibility to force the behaviour
      of wrapping the query in a subselect, so application must not be changed,
      so something like
      columnstore_forced_subselect,
      so simply set

      set columnstore_forced_subselect = 1;

      can work as a workarround,
      Must be certainly dynamically and possible with global and session level.

      Description:
      Add an extra step to tuple union step. This will enable processing of unions better. Thus handling it on the columnstore side. Enable order by after unions, enabling sorting. See leonid.fedorov for details

      Attachments

        1. workaround.sql
          2 kB
        2. tables.ddl.txt
          53 kB
        3. issue.sql
          2 kB
        4. data-large.sql
          39 kB
        5. data.sql
          39 kB

        Issue Links

          Activity

            People

              alexey.antipovsky Aleksei Antipovskii
              Richard Richard Stracke
              Votes:
              1 Vote for this issue
              Watchers:
              9 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.