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

controlled redestribution

    XMLWordPrintable

Details

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

    Description

      An already existed table in columnstore is in a "fixed" destribution state.

      extent elimination and partitions depends on the distribution order.

      The only way to fix it, is to dump table and try to load it in sorted way with cpimport.

      For very huge table the distribution order can make a difference.

      There was some approaches in the past (MCOL-1297, MCOL-3579),
      was rejected with "won't do", but this should be reconsidered,
      because it can be have a big impact on performance.

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MCOL-1297 Control distribution order on dbroot / segment level

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MCOL-3579 Manually set distribution key

          • Major - Major loss of function.
          • Closed

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MCOL-4217 ColumnStore Partitioning

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              Richard Richard Stracke
              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.