COLUMNAR_SEGMENTS
This view stores information about each columnar_segment (column segment).
The view does not include information about deleted segment files that have yet to be garbage collected.
Column Name | Description |
|---|---|
| The name of the related database. |
| The name of the related table. |
| The name of the related column. |
| The |
| The |
| The name of the file where a given segment is stored relative to the data directory of the node. |
| The hostname or IP address for the related leaf node. |
| The port number of the related leaf node. |
| The |
| The |
| The number of rows in a given segment. |
| The number of deleted rows in a given segment. |
| The encoding for a given column. |
| The minimum value of a given column in the segment. |
| The maximum value of a given column in the segment. |
| The minimum value of the sort key column(s) in a given segment. |
| The maximum value of the sort key column(s) in a given segment. |
| The uncompressed size of a given columnar segment in bytes. Does not include index data. |
| The compressed size of a given columnar segment in bytes. Does not include index data. |
| The timestamp when a given columnstore file was created. |
| Log sequence number of the related blob file. |
| The term of the database, used to uniquely identify which node was the master of a specific database. |
| The |
| The type for a file where a given segment is stored. |
| Whether or not a corresponding file exists for a given column segment. |
| The size, in bytes, of a file where a given segment is stored. |
| Specifies the offset in the file where a given segment is stored. |