STRATA
Contains internal details of how the Tuple Mover combines ROS containers in each projection, broken down by stratum and classifies the ROS containers by size and partition. The related STRATA_STRUCTURES table provides a summary of the strata values.
Mergeout in the Administrator's Guide describes how the Tuple Mover combines ROS containers.
| Column Name | Data Type | Description |
|---|---|---|
NODE_NAME
|
VARCHAR |
The node name for which information is listed. |
SCHEMA_NAME
|
VARCHAR |
The schema name for which information is listed. |
PROJECTION_ID
|
INTEGER |
A unique numeric ID assigned by the Vertica catalog, which identifies the projection. |
PROJECTION_NAME
|
VARCHAR |
The projection name for which information is listed on that node. |
PARTITION_KEY
|
VARCHAR |
Deprecated in favor of |
STRATUM_KEY
|
VARCHAR | References the partition or partition group for which information is listed. |
STRATA_COUNT
|
INTEGER |
The total number of strata for this projection partition. |
MERGING_STRATA_COUNT
|
INTEGER |
The number of strata the Tuple Mover can merge out. |
STRATUM_CAPACITY
|
INTEGER |
The maximum number of ROS containers for the stratum before they must be merged. |
STRATUM_HEIGHT
|
FLOAT |
The size ratio between the smallest and largest ROS container in this stratum. |
STRATUM_NO
|
INTEGER |
The stratum number. Strata are numbered starting at 0, for the stratum containing the smallest ROS containers. |
STRATUM_LOWER_SIZE
|
VARCHAR |
The smallest ROS container size allowed in this stratum. |
STRATUM_UPPER_SIZE
|
VARCHAR |
The largest ROS container size allowed in this stratum. |
ROS_CONTAINER_COUNT
|
INTEGER |
The current number of ROS containers in the projection partition. |