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

Enable the AUX column (DELETE optimization) for existing tables

    XMLWordPrintable

Details

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

    Description

      MCOL-5021 adds support for an auxilliary (AUX) column in ColumnStore which improves the performance of the DELETE operation (refer to that ticket for more details). The AUX column, however, is only created when the user creates a new table in the ColumnStore version which supports this feature. This means the existing tables will not benefit from MCOL-5021. The objective of this ticket is to allow the user to add the AUX column to an existing table. One way to achieve this would be to create a new UDF that creates the AUX column.

      While adding the new AUX column, the implementation needs to take into account existing deleted rows for the table.

      Attachments

        Issue Links

          Activity

            People

              leonid.fedorov Leonid Fedorov
              tntnatbry Gagan Goel (Inactive)
              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.