Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

MV_COLUMNSTORE_MERGE_STATUS

This view stores information about the status of background_merger processes for columnstore tables.

Column Name

Description

DATABASE_NAME

The name of the related database.

TABLE_NAME

The name of the related table.

PARTITION_ID

The ID of the related partition.

MERGER

Specifies whether the given status is for slow, fast, manual, or index merging.

  • (Current Groups) is the current state of the segment groups regarding the sort key.

  • (Current Index Groups on <index name>) is the current state of the cross segment index blobs (for multi column indexes).

  • (Current Index Groups on Column <column name>) is the current state of the cross segment index blobs (for single column indexes, and columns part of a multi column index).

  • Fast Merger / Slow Merger are the two background merger processes.

  • Manual Merger indicates a user running the OPTIMIZE TABLE command.

STATE

For rows corresponding to the current state of a merge process:

  • Idle - not doing anything.

  • Waiting - waiting on another merger (mainly for manual OPTIMIZE commands).

  • Preparing - gathering information for merge.

  • Merging Segments

  • Compacting Segments

  • Merging Indexes

  • Compacting Indexes

  • Updating Statistics

  • Populating Altering-Encoding

For rows corresponding to the current state of the table (Current Groups, etc.):

  • NULL

  • Building - only for newly added indexes that are not yet populated.

PLAN

The size, in number of segments, or the rows being merged.

PROGRESS_PERCENT

Merge progress represented as a number between 0 and 100.

Last modified:

Was this article helpful?