SingleStore Managed Service

information_schema.MV_COLUMNSTORE_FILES

This view stores information about columnstore files.

Column Name

Description

DATABASE_NAME

The name of the related database.

TABLE_NAME

The name of the related table.

FILE_TYPE

The type of a given columnstore file.

FILE

The name of a given columnstore file.

HOST

The hostname or IP address for the related leaf node.

PORT

The port number of the related leaf node.

NODE_ID

The ID of the related leaf node.

PARTITION

The ID of the related partition.

SIZE

The size, in bytes, of a given columnstore file.

CREATION_TIME

The timestamp when a given columnstore file was created.

LSN

Log sequence number of the related blob file.

TERM

The term of the database, used to uniquely identify which node was the master of a specific database.

CHECKSUM

The crc32c checksum of the file contents.