Vertica 系统表 字段变更明细
仅列出「有变化」的字段。升级前参考此表即可了解系统表 schema 变化。
变更类型：新增 / 删除 / 类型变更
11.0.x → 11.1.x
| Schema |
表名 |
字段名 |
变更类型 |
版本 |
旧值 |
新值 |
| v_catalog |
CLIENT_AUTH |
IS_FALLTHROUGH_ENABLED |
删除 |
11.1.x |
Boolean |
- |
| v_catalog |
DIRECTED_QUERIES |
DIGEST |
删除 |
11.1.x |
INTEGER |
- |
| v_catalog |
DIRECTED_QUERIES |
SAVE_PLANS_VERSION |
删除 |
11.1.x |
INTEGER |
- |
| v_catalog |
DIRECTED_QUERIES |
SINCE_DATE |
删除 |
11.1.x |
VARCHAR |
- |
| v_catalog |
DIRECTED_QUERIES |
USERNAME |
删除 |
11.1.x |
VARCHAR |
- |
| v_catalog |
DIRECTED_QUERIES |
CREATION_DATE |
类型变更 |
11.1.x |
VARCHAR |
TIMESTAMPTZ |
| v_catalog |
NODES |
SANDBOX |
删除 |
11.1.x |
VARCHAR(128) |
- |
| v_catalog |
PRIMARY_KEYS |
IS_ENABLED |
新增 |
11.1.x |
- |
BOOLEAN |
| v_catalog |
PRIMARY_KEYS |
IS_ENABLED` |
删除 |
11.1.x |
BOOLEAN |
- |
| v_catalog |
TABLES |
IMMUTABLE_ROWS_SINCE_EPOCH |
删除 |
11.1.x |
INTEGER |
- |
| v_catalog |
TABLES |
IMMUTABLE_ROWS_SINCE_TIMESTAMP |
删除 |
11.1.x |
TIMESTAMPTZ |
- |
| v_catalog |
TABLES |
IS_EXTERNAL_ICEBERG_TABLE |
删除 |
11.1.x |
BOOLEAN |
- |
| v_catalog |
TABLE_CONSTRAINTS |
IS_ENABLED |
新增 |
11.1.x |
- |
BOOLEAN |
| v_catalog |
TABLE_CONSTRAINTS |
IS_ENABLED` |
删除 |
11.1.x |
BOOLEAN |
- |
| v_catalog |
USERS |
LAST_LOGIN_TIME |
删除 |
11.1.x |
TIMESTAMPTZ |
- |
| v_catalog |
USERS |
MANAGED_BY_OAUTH2_AUTH_ID |
删除 |
11.1.x |
INTEGER |
- |
| v_monitor |
CURRENT_SESSION |
CLIENT_OS_HOSTNAME |
删除 |
11.1.x |
VARCHAR |
- |
| v_monitor |
SESSIONS |
CLIENT_OS_HOSTNAME |
删除 |
11.1.x |
VARCHAR |
- |
| v_monitor |
STORAGE_CONTAINERS |
ORIGINAL_SEGMENT_LOWER_BOUND |
删除 |
11.1.x |
INTEGER |
- |
| v_monitor |
STORAGE_CONTAINERS |
ORIGINAL_SEGMENT_UPPER_BOUND |
删除 |
11.1.x |
INTEGER |
- |
| v_monitor |
USER_SESSIONS |
CLIENT_OS_HOSTNAME |
删除 |
11.1.x |
VARCHAR |
- |
11.1.x → 12.0.x
| Schema |
表名 |
字段名 |
变更类型 |
版本 |
旧值 |
新值 |
| v_catalog |
CLIENT_AUTH |
IS_FALLTHROUGH_ENABLED |
新增 |
12.0.x |
- |
Boolean |
| v_catalog |
DIRECTED_QUERIES |
DIGEST |
新增 |
12.0.x |
- |
INTEGER |
| v_catalog |
DIRECTED_QUERIES |
SAVE_PLANS_VERSION |
新增 |
12.0.x |
- |
INTEGER |
| v_catalog |
DIRECTED_QUERIES |
SINCE_DATE |
新增 |
12.0.x |
- |
VARCHAR |
| v_catalog |
DIRECTED_QUERIES |
USERNAME |
新增 |
12.0.x |
- |
VARCHAR |
| v_catalog |
DIRECTED_QUERIES |
CREATION_DATE |
类型变更 |
12.0.x |
TIMESTAMPTZ |
VARCHAR |
| v_catalog |
PRIMARY_KEYS |
IS_ENABLED` |
新增 |
12.0.x |
- |
BOOLEAN |
| v_catalog |
PRIMARY_KEYS |
IS_ENABLED |
删除 |
12.0.x |
BOOLEAN |
- |
| v_catalog |
TABLES |
IMMUTABLE_ROWS_SINCE_EPOCH |
新增 |
12.0.x |
- |
INTEGER |
| v_catalog |
TABLES |
IMMUTABLE_ROWS_SINCE_TIMESTAMP |
新增 |
12.0.x |
- |
TIMESTAMPTZ |
| v_catalog |
TABLE_CONSTRAINTS |
IS_ENABLED` |
新增 |
12.0.x |
- |
BOOLEAN |
| v_catalog |
TABLE_CONSTRAINTS |
IS_ENABLED |
删除 |
12.0.x |
BOOLEAN |
- |
| v_monitor |
STORAGE_CONTAINERS |
ORIGINAL_SEGMENT_LOWER_BOUND |
新增 |
12.0.x |
- |
INTEGER |
| v_monitor |
STORAGE_CONTAINERS |
ORIGINAL_SEGMENT_UPPER_BOUND |
新增 |
12.0.x |
- |
INTEGER |
12.0.x → 23.3.x
| Schema |
表名 |
字段名 |
变更类型 |
版本 |
旧值 |
新值 |
| v_catalog |
MODELS |
IS_INHERIT_PRIVILEGES |
新增 |
23.3.x |
- |
BOOLEAN |
| v_catalog |
NODES |
SANDBOX |
新增 |
23.3.x |
- |
VARCHAR(128) |
| v_catalog |
TABLES |
IS_EXTERNAL_ICEBERG_TABLE |
新增 |
23.3.x |
- |
BOOLEAN |
| v_catalog |
USERS |
LAST_LOGIN_TIME |
新增 |
23.3.x |
- |
TIMESTAMPTZ |
| v_catalog |
USERS |
MANAGED_BY_OAUTH2_AUTH_ID |
新增 |
23.3.x |
- |
INTEGER |
| v_monitor |
CONFIGURATION_PARAMETERS |
SUPERUSER_VISIBLE_ONLY |
新增 |
23.3.x |
- |
BOOLEAN |
| v_monitor |
CONFIGURATION_PARAMETERS |
SUPERUSER_ONLY |
删除 |
23.3.x |
BOOLEAN |
- |
| v_monitor |
CURRENT_SESSION |
CLIENT_OS_HOSTNAME |
新增 |
23.3.x |
- |
VARCHAR |
| v_monitor |
SESSIONS |
CLIENT_OS_HOSTNAME |
新增 |
23.3.x |
- |
VARCHAR |
| v_monitor |
USER_SESSIONS |
CLIENT_OS_HOSTNAME |
新增 |
23.3.x |
- |
VARCHAR |
23.3.x → 23.4.x
| Schema |
表名 |
字段名 |
变更类型 |
版本 |
旧值 |
新值 |
| v_monitor |
DEPOT_EVICTIONS |
IS_ANTI_PINNED |
新增 |
23.4.x |
- |
BOOLEAN |
| v_monitor |
DEPOT_FILES |
IS_ANTI_PINNED |
新增 |
23.4.x |
- |
BOOLEAN |
| v_monitor |
DEPOT_PIN_POLICIES |
LOCATION_LABEL |
新增 |
23.4.x |
- |
VARCHAR |
| v_monitor |
DEPOT_PIN_POLICIES |
POLICY_TYPE |
新增 |
23.4.x |
- |
VARCHAR |
| v_monitor |
DEPOT_PIN_POLICIES |
SUBCLUSTER_NAME |
新增 |
23.4.x |
- |
VARCHAR |
23.4.x → 24.1.x
| Schema |
表名 |
字段名 |
变更类型 |
版本 |
旧值 |
新值 |
| v_catalog |
COMMENTS |
CHILD_OBJECT |
新增 |
24.1.x |
- |
VARCHAR |
| v_catalog |
PROJECTIONS |
PROJECTION_NAMESPACE_NAME |
新增 |
24.1.x |
- |
VARCHAR |
| v_catalog |
SCHEMATA |
SCHEMA_NAMESPACE_NAME |
新增 |
24.1.x |
- |
VARCHAR |
| v_catalog |
TABLES |
TABLE_NAMESPACE_NAME |
新增 |
24.1.x |
- |
VARCHAR |
| v_catalog |
WORKLOAD_ROUTING_RULES |
PRIORITY |
新增 |
24.1.x |
- |
INTEGER |
| v_monitor |
UDX_EVENTS |
REQUEST_ID |
新增 |
24.1.x |
- |
INTEGER |
| v_monitor |
UDX_EVENTS |
STATEMENT_ID |
新增 |
24.1.x |
- |
INTEGER |
| v_monitor |
UDX_EVENTS |
TRANSACTION_ID |
新增 |
24.1.x |
- |
INTEGER |
| v_monitor |
UDX_EVENTS |
RAW |
新增 |
24.1.x |
- |
VARBINARY |
| v_monitor |
UDX_EVENTS |
RAW |
删除 |
24.1.x |
VARBINARY |
- |
| v_monitor |
UDX_EVENTS |
REQUEST_ID* |
删除 |
24.1.x |
INTEGER |
- |
| v_monitor |
UDX_EVENTS |
STATEMENT_ID* |
删除 |
24.1.x |
INTEGER |
- |
| v_monitor |
UDX_EVENTS |
TRANSACTION_ID* |
删除 |
24.1.x |
INTEGER |
- |
24.1.x → 24.2.x
| Schema |
表名 |
字段名 |
变更类型 |
版本 |
旧值 |
新值 |
| v_catalog |
COLUMNS |
TABLE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
CONSTRAINT_COLUMNS |
REFERENCE_TABLE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
CONSTRAINT_COLUMNS |
TABLE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
FOREIGN_KEYS |
REFERENCE_TABLE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
FOREIGN_KEYS |
REFERENCE_TABLE_NAMESPACE_ID |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
FOREIGN_KEYS |
TABLE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
FOREIGN_KEYS |
TABLE_NAMESPACE_ID |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
GRANTS |
OBJECT_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
INHERITED_PRIVILEGES |
OBJECT_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
PRIMARY_KEYS |
TABLE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
PRIMARY_KEYS |
TABLE_NAMESPACE_ID |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
PROJECTION_COLUMNS |
TABLE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
SEQUENCES |
SEQUENCE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
STORED_PROC_TRIGGERS |
NAMESPACE_NAME |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
USER_FUNCTION_PARAMETERS |
NAMESPACE_NAME |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
USER_PROCEDURES |
NAMESPACE_NAME |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
USER_SCHEDULES |
NAMESPACE_NAME |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
VIEWS |
TABLE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_catalog |
VIEW_COLUMNS |
TABLE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_monitor |
COLUMN_STORAGE |
ANCHOR_TABLE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_monitor |
CPU_USAGE |
PHYSICAL_CORES |
新增 |
24.2.x |
- |
INTEGER |
| v_monitor |
DATA_LOADERS |
ENABLED |
新增 |
24.2.x |
- |
BOOLEAN |
| v_monitor |
DATA_LOADERS |
NAMESPACENAME |
新增 |
24.2.x |
- |
VARCHAR |
| v_monitor |
DATA_LOADERS |
TRIGGER |
新增 |
24.2.x |
- |
VARCHAR |
| v_monitor |
DATA_LOADER_EVENTS |
DATA_LOADER_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_monitor |
DELETE_VECTORS |
NAMESPACE_NAME |
新增 |
24.2.x |
- |
VARCHAR |
| v_monitor |
DEPOT_PIN_POLICIES |
NAMPESPACE_NAME |
新增 |
24.2.x |
- |
VARCHAR |
| v_monitor |
EXTERNAL_TABLE_DETAILS |
TABLE_NAMESPACE |
新增 |
24.2.x |
- |
VARCHAR |
| v_monitor |
STORAGE_CONTAINERS |
NAMESPACE_NAME* |
新增 |
24.2.x |
- |
VARCHAR |
| v_monitor |
STORAGE_POLICIES |
NAMESPACE_NAME |
新增 |
24.2.x |
- |
VARCHAR |
| v_monitor |
UDFS_STATISTICS |
OVERALL_AVERAGE_LATENCY_MS |
新增 |
24.2.x |
- |
INTEGER |
| v_monitor |
UDFS_STATISTICS |
OVERALL_DOWNSTREAM_THROUGHPUT_MB_S |
新增 |
24.2.x |
- |
FLOAT |
| v_monitor |
UDFS_STATISTICS |
OVERALL_UPSTREAM_THROUGHPUT_MB_S |
新增 |
24.2.x |
- |
FLOAT |
| v_monitor |
UDFS_STATISTICS |
TOTAL_REQUEST_DURATION_MS |
新增 |
24.2.x |
- |
INTEGER |
| v_monitor |
USER_LIBRARIES |
NAMESPACE_NAME |
新增 |
24.2.x |
- |
VARCHAR |
| v_monitor |
USER_LIBRARY_MANIFEST |
NAMESPACE_NAME |
新增 |
24.2.x |
- |
VARCHAR |
24.2.x → 24.3.x
| Schema |
表名 |
字段名 |
变更类型 |
版本 |
旧值 |
新值 |
| v_monitor |
PROJECTION_STORAGE |
DISK_SIZE |
新增 |
24.3.x |
- |
INTEGER |
| v_monitor |
STORAGE_CONTAINERS |
DISK_SIZE |
新增 |
24.3.x |
- |
INTEGER |
24.3.x → 24.4.x
仅表级增减：+4/-0 表
24.4.x → 25.1.x
| Schema |
表名 |
字段名 |
变更类型 |
版本 |
旧值 |
新值 |
| v_monitor |
DATA_LOADER_EVENTS |
KAFKA_LATEST_OFFSET |
新增 |
25.1.x |
- |
INTEGER |
| v_monitor |
DATA_LOADER_EVENTS |
KAFKA_LOADER_TARGET |
新增 |
25.1.x |
- |
VARCHAR |
| v_monitor |
DATA_LOADER_EVENTS |
KAFKA_PARTITION_ID |
新增 |
25.1.x |
- |
INTEGER |
| v_monitor |
DATA_LOADER_EVENTS |
KAFKA_TOPIC_NAME |
新增 |
25.1.x |
- |
VARCHAR |
25.1.x → 25.2.x
无字段变更
25.2.x → 25.3.x
仅表级增减：+1/-1 表
25.3.x → 25.4.x
无字段变更
25.4.x → 26.1.x
无字段变更
26.1.x → 26.2.x
仅表级增减：+1/-0 表