【详述】我们从3.2版本的集群迁移到3.3.4版本,从3.2复制的ddl到3.3.4会自动更新
3.2 DDL
CREATE TABLE `instance` (
`id` varchar(1048576) NOT NULL COMMENT "主键",
`start_time` datetime NULL COMMENT "",
`end_time` datetime NULL COMMENT "任务结束时间",
`status` int(11) NULL DEFAULT "1" COMMENT "记录状态,默认1",
`remark` varchar(1048576) NULL COMMENT "任务备注",
`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT "任务创建时间",
`update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT "任务最后更新时间",
`sync_time` double NULL AS timestampdiff(SECOND, start_time, end_time) / 60 COMMENT "实例执行时长"
) ENGINE=OLAP
PRIMARY KEY(`id`)
COMMENT "实例"
DISTRIBUTED BY HASH(`id`) BUCKETS 10
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"enable_persistent_index" = "false",
"replicated_storage" = "true",
"compression" = "LZ4"
);`
3.3.4 DDL
CREATE TABLE `instance` (
`id` varchar(1048576) NOT NULL COMMENT "主键",
`start_time` datetime NULL COMMENT "开始同步数据时间",
`end_time` datetime NULL COMMENT "任务结束时间",
`status` int(11) NULL DEFAULT "1" COMMENT "记录状态,默认1",
`remark` varchar(1048576) NULL COMMENT "任务备注",
`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT "任务创建时间",
`update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT "任务最后更新时间"
) ENGINE=OLAP
PRIMARY KEY(`id`)
COMMENT "实例"
DISTRIBUTED BY HASH(`id`) BUCKETS 10
PROPERTIES (
"compression" = "LZ4",
"datacache.enable" = "true",
"enable_async_write_back" = "false",
"enable_persistent_index" = "false",
"replication_num" = "3",
"storage_volume" = "def_volume"
);
我需要在3.3.4版本中增加生成列 sync_time
执行SQL
ALTER TABLE config.instance
ADD COLUMN sync_time
double AS timestampdiff(SECOND, start_time, end_time) / 60
报错,报错信息为
Detail message: Generated Column only support olap table.
【StarRocks版本】例如:3.3.4