Accelarator opened a new issue, #16321: URL: https://github.com/apache/doris/issues/16321
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 1.2.1 ### What's Wrong? 添加字段4次，有3次会出现table is unstable问题 执行语句： ```SQL alter table dw.ods_kafka_xxxx_rt add create_time datetime COMMENT '数据落地时间' ``` 问题现象：  数据写： 只有一个Flink任务在写，10s一个checkpoint，但是执行alter前已停止Flink任务 数据读： 有2个10s一次的调度任务在读 show create table 结果语句： ```SQL CREATE TABLE `ods_kafka_xxxxxxxxxx_rt` ( `event` varchar(64) NULL COMMENT '事件名', `col1` bigint(20) NULL , `col2` varchar(64) NULL , `col3` varchar(256) NULL , `col4` varchar(64) NULL , `col5` varchar(64) NULL , `col6` varchar(256) NULL , `col7` varchar(64) NULL , `col8` varchar(256) NULL , `col9` varchar(64) NULL , `col10` varchar(64) NULL , `col11` text NULL , `col12` bigint(20) NULL , `col13` varchar(64) NULL , `col14` varchar(64) NULL , `col15` varchar(64) NULL , `col16` varchar(64) NULL , `col17` varchar(64) NULL , `col18` varchar(64) NULL , `col19` varchar(64) NULL , `col20` varchar(64) NULL , `col21` varchar(64) NULL , `col22` varchar(64) NULL , `col23` varchar(64) NULL , `col24` varchar(64) NULL , `col25` text NULL , `col26` datetime NULL , `col27` datetime NULL , `col28` varchar(64) NULL , `col29` varchar(64) NULL , `col31` varchar(64) NULL , `col32` varchar(64) NULL , `col33` varchar(256) NULL ) ENGINE=OLAP DUPLICATE KEY(`event`) COMMENT '' PARTITION BY RANGE(`col26`) (PARTITION p20221225 VALUES [('2022-12-25 00:00:00'), ('2022-12-26 00:00:00')), PARTITION p20221226 VALUES [('2022-12-26 00:00:00'), ('2022-12-27 00:00:00')), PARTITION p20221227 VALUES [('2022-12-27 00:00:00'), ('2022-12-28 00:00:00')), PARTITION p20221228 VALUES [('2022-12-28 00:00:00'), ('2022-12-29 00:00:00')), PARTITION p20221229 VALUES [('2022-12-29 00:00:00'), ('2022-12-30 00:00:00')), PARTITION p20221230 VALUES [('2022-12-30 00:00:00'), ('2022-12-31 00:00:00')), PARTITION p20221231 VALUES [('2022-12-31 00:00:00'), ('2023-01-01 00:00:00')), PARTITION p20230101 VALUES [('2023-01-01 00:00:00'), ('2023-01-02 00:00:00')), PARTITION p20230102 VALUES [('2023-01-02 00:00:00'), ('2023-01-03 00:00:00')), PARTITION p20230103 VALUES [('2023-01-03 00:00:00'), ('2023-01-04 00:00:00')), PARTITION p20230104 VALUES [('2023-01-04 00:00:00'), ('2023-01-05 00:00:00')), PARTITION p20230105 VALUES [('2023-01-05 00:00:00'), ('2023-01-06 00:00:00')), PARTITION p20230106 VALUES [('2023-01-06 00:00:00'), ('2023-01-07 00:00:00')), PARTITION p20230107 VALUES [('2023-01-07 00:00:00'), ('2023-01-08 00:00:00')), PARTITION p20230108 VALUES [('2023-01-08 00:00:00'), ('2023-01-09 00:00:00')), PARTITION p20230109 VALUES [('2023-01-09 00:00:00'), ('2023-01-10 00:00:00')), PARTITION p20230110 VALUES [('2023-01-10 00:00:00'), ('2023-01-11 00:00:00')), PARTITION p20230111 VALUES [('2023-01-11 00:00:00'), ('2023-01-12 00:00:00')), PARTITION p20230112 VALUES [('2023-01-12 00:00:00'), ('2023-01-13 00:00:00')), PARTITION p20230113 VALUES [('2023-01-13 00:00:00'), ('2023-01-14 00:00:00')), PARTITION p20230114 VALUES [('2023-01-14 00:00:00'), ('2023-01-15 00:00:00')), PARTITION p20230115 VALUES [('2023-01-15 00:00:00'), ('2023-01-16 00:00:00')), PARTITION p20230116 VALUES [('2023-01-16 00:00:00'), ('2023-01-17 00:00:00')), PARTITION p20230117 VALUES [('2023-01-17 00:00:00'), ('2023-01-18 00:00:00')), PARTITION p20230118 VALUES [('2023-01-18 00:00:00'), ('2023-01-19 00:00:00')), PARTITION p20230119 VALUES [('2023-01-19 00:00:00'), ('2023-01-20 00:00:00')), PARTITION p20230120 VALUES [('2023-01-20 00:00:00'), ('2023-01-21 00:00:00')), PARTITION p20230121 VALUES [('2023-01-21 00:00:00'), ('2023-01-22 00:00:00')), PARTITION p20230122 VALUES [('2023-01-22 00:00:00'), ('2023-01-23 00:00:00')), PARTITION p20230123 VALUES [('2023-01-23 00:00:00'), ('2023-01-24 00:00:00')), PARTITION p20230124 VALUES [('2023-01-24 00:00:00'), ('2023-01-25 00:00:00')), PARTITION p20230125 VALUES [('2023-01-25 00:00:00'), ('2023-01-26 00:00:00')), PARTITION p20230126 VALUES [('2023-01-26 00:00:00'), ('2023-01-27 00:00:00')), PARTITION p20230127 VALUES [('2023-01-27 00:00:00'), ('2023-01-28 00:00:00')), PARTITION p20230128 VALUES [('2023-01-28 00:00:00'), ('2023-01-29 00:00:00')), PARTITION p20230129 VALUES [('2023-01-29 00:00:00'), ('2023-01-30 00:00:00')), PARTITION p20230130 VALUES [('2023-01-30 00:00:00'), ('2023-01-31 00:00:00')), PARTITION p20230131 VALUES [('2023-01-31 00:00:00'), ('2023-02-01 00:00:00')), PARTITION p20230201 VALUES [('2023-02-01 00:00:00'), ('2023-02-02 00:00:00')), PARTITION p20230202 VALUES [('2023-02-02 00:00:00'), ('2023-02-03 00:00:00'))) DISTRIBUTED BY HASH(`event`) BUCKETS 2 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "day", "dynamic_partition.time_zone" = "Asia/Shanghai", "dynamic_partition.start" = "-2147483648", "dynamic_partition.end" = "1", "dynamic_partition.prefix" = "p", "dynamic_partition.replication_allocation" = "tag.location.default: 3", "dynamic_partition.buckets" = "2", "dynamic_partition.create_history_partition" = "true", "dynamic_partition.history_partition_num" = "15", "dynamic_partition.hot_partition_num" = "0", "dynamic_partition.reserved_history_periods" = "NULL", "dynamic_partition.storage_policy" = "", "in_memory" = "false", "storage_format" = "V2", "disable_auto_compaction" = "false" ); ``` ### What You Expected? 问题很频繁，希望想知道是为啥。以及unstable时要怎么处理（除了drop） ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
