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

Adjust high-water mark on final valid partition and drop other partitions when DELETE removes rows from the end of a table in key order.

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • None
    • Icebox
    • writeengine
    • None

    Description

      There is a possible edgecase where the end of a ColumnStore table is deleted... ie,

      /* "customer" Table loaded in "custkey" order */
      DELETE FROM customer
      WHERE custkey > 1000;
      

      Which may leave the end of the table with a series of rows marked as deleted. There could also be partitions at the end of the table that contain only rows marked for deletion.

      Could ColumnStore recover this space automatically in the case of deletes in key order as described?

      Attachments

        Activity

          People

            toddstoffel Todd Stoffel (Inactive)
            juan.vera Juan
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.