# 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. Possible values include:<ul> <li><code>AUTOSTATS</code> - stats for the optimizer</li> <li><code>FULLTEXT</code> - full-text index</li> <li><code>INVERTED_INDEX</code> - secondary hash index</li> <li><code>COLUMN</code> - data for columns, may be encoded</li> <li><code>COLUMN_GROUP</code> - indicates the column group index blobs</li> </ul>Both COLUMN and INVERTED\_INDEX objects can be stored inside one columnstore file. In these cases,`FILE_TYPE`shows the type of the first object in that file. To get detailed information for all columns and indexes in each file, use`MV_COLUMNAR_SEGMENT_INDEX`. |
| `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.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| `STORAGE_ID`      | Storage ID of the database.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| `COMPUTE_ID`      | ID of the current active compute session for the database.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| `BLOB_COMPUTE_ID` | ID of the compute session that wrote the file. Can differ from`COMPUTE_ID`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |

***

Modified at: October 16, 2025

Source: [/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/mv-columnstore-files/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/mv-columnstore-files/)

(An index of the documentation is available at /llms.txt)