CONSUMER_PLAN_NON_LEAF
The CONSUMER_PLAN_NON_LEAF table includes resource plans for non-leaf nodes only.
| Column name | Data type | Null (Y or N) | Key (PK or FK) | Comment |
|---|---|---|---|---|
| CLUSTER_NAME | VARCHAR(128) | N | Not applicable | The name of the cluster. |
| CONSUMER_NAME | VARCHAR(4000) | N | PK | The name of the consumer. This is the fully-qualified consumer name. |
| RESOURCE_GROUP | VARCHAR(256) | N | PK | The allocated resource group. Note that all
is a reserved value signifying all resource groups that are associated with the consumer. |
| TIME_STAMP_GMT | NUMERIC(13) | N | Not applicable | The record sample time in the GMT time zone. This is the number of seconds from midnight, 1 January, 1970. |
| TIME_STAMP | TIMESTAMP | N | PK | The record sample time in the local cluster time zone. |
| INSERT_SEQ | BIGINT | N | Not applicable | The order of sequence in which this record is inserted into the table. This field is auto-incremented whenever a new record is inserted into the table. |
| PLANNED_HOWN | NUMERIC(10) | Y | Not applicable | The hybrid own value from the distribution tree of this consumer resource group. If this is null, the value is 0. This is from the cluster configuration. |
| PLANNED_HRESERVE | NUMERIC(10) | Y | Not applicable | The hybrid reserve value from the distribution tree of this consumer resource group. If this is null, the value is 0. This is from the cluster configuration. |
| PLANNED_OWN | NUMERIC(10) | Y | Not applicable | The own value from the distribution tree of this consumer resource group. If this is null, the value is 0. This is from the cluster configuration. |
| SHARE_LIMIT | NUMERIC(10) | Y | Not applicable | The maximum number of slots that this consumer can obtain from the resource group share pool. This data is from the cluster configuration. |
| SHARE_RATIO | DOUBLE | Y | Not applicable | The share ratio of share pool slots for this consumer and resource group. This data is from the cluster configuration. |