anthony-yau opened a new issue, #32366: URL: https://github.com/apache/doris/issues/32366
### 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 2.1.0 ### What's Wrong? ``` 1、创建了存储策略 create storage policy test3 PROPERTIES( "storage_resource" = "costest", "cooldown_datetime" = "2024-06-01 00:00:00" ); > show storage policy; +------------+-------+---------+---------+-----------------+---------------------+-------------+ | PolicyName | Id | Version | Type | StorageResource | CooldownDatetime | CooldownTtl | +------------+-------+---------+---------+-----------------+---------------------+-------------+ | test3 | 20337 | 0 | STORAGE | costest | 2024-06-01 00:00:00 | -1 | +------------+-------+---------+---------+-----------------+---------------------+-------------+ 2、修改存储策略 alter storage policy test3 PROPERTIES( "cooldown_datetime" = "1000-01-01 00:00:00", "cooldown_ttl" = "1d" ); 3、查看存储策略 > show storage policy; +------------+-------+---------+---------+-----------------+------------------+-------------+ | PolicyName | Id | Version | Type | StorageResource | CooldownDatetime | CooldownTtl | +------------+-------+---------+---------+-----------------+------------------+-------------+ | test3 | 20337 | 1 | STORAGE | costest | NULL | 86400 | +------------+-------+---------+---------+-----------------+------------------+-------------+ 4、创建表报错 CREATE TABLE IF NOT EXISTS test_table ( id INT, value text, ts date ) ENGINE=OLAP DUPLICATE KEY(id) DISTRIBUTED BY RANDOM PROPERTIES ( "replication_num" = "1", "storage_policy" = "test3" ); ERROR 1105 (HY000): errCode = 2, detailMessage = errCode = 2, detailMessage = remote storage cool down time: -30610252800000 should later than now: 1710732836426 ``` 从报错信息来看，迁移策略还存在cooldown_datetime，与show storage policy看的不一样。 ### What You Expected? 修正存储策略判断逻辑？能够使用修改的存储策略创建表。 ### 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
