COLUMNAR_ SEGMENTS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
This view stores information about each columnar_
(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. |
|
The compressed size of a given columnar segment in bytes. |
|
The size of the footer of the columnar segment in bytes. |
|
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 |
|
Specifies the offset in the file where a given segment is stored. |
|
Storage Id of the database. |
|
Compute Id of the database. |
Last modified: May 13, 2025