Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16502

Join pushdown to something like an IN filter for different storage engine

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Optimizer, Plugins
    • Labels:
      None

      Description

      Extension of the join pushdown in MDEV-9062 we need a way to pushdown data from small tables in a join when pushdown join is used.

      Example:
      InnoDB table with 100 rows and 4 ColumnStore tables in a join. This feature should convert the 100 rows (or filtered results of the 100 rows) into something like an IN filter to pushdown the InnoDB results into ColumnStore.

      Customers often use InnoDB tables as pivot tables in AX which have very small number of rows so this is a common use case.

      There of course should be a threshold on this (a sysvar?), we don't know at what point this will become too expensive.

      I'm guessing an optimizer flag will be needed to separate to pushdown join but only allowed to be turned on when pushdown join is turned on.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                igor Igor Babaev
                Reporter:
                LinuxJedi Andrew Hutchings
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated: