[Bug] doris4.1.3 在使用timestamptz 作为分区列是 DYNAMIC 失效无法生成新分区
- Dominant language
- Java
- Stars
- 15.9k
- Forks
- 3.9k
- Avg merge
- 2d 23h
- Merged PRs (30d)
- 520
Description
### 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
v4.1.3
### What's Wrong?
当使用 TIMESTAMPTZ 作为分区键时,开启动态分区 "dynamic_partition.enable" = "true"时仅在创建时创建分区,后续无调度继续创建分区;使用SHOW DYNAMIC PARTITION TABLES ;时也不显示任何报错信息
### What You Expected?
后续会创建分区
### How to Reproduce?
最小复现:
```sql
CREATE TABLE IF NOT EXISTS inland_dwd.dwd_fact_game_online_dot (
event_at TIMESTAMPTZ(3) NOT NULL COMMENT '上报时间(分区键)',
user_id VARCHAR(256) COMMENT '用户ID'
) ENGINE=OLAP
DUPLICATE KEY(event_at)
PARTITION BY RANGE (`event_at`)()
DISTRIBUTED BY HASH(user_id) BUCKETS 3
PROPERTIES (
"storage_format" = "V3",
"compression" = "ZSTD",
"compaction_policy" = "time_series",
"dynamic_partition.enable" = "true",
"dynamic_partition.prefix" = "p_",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.end" = "2",
"dynamic_partition.create_history_partition" = "false"
);
```
第二天时不会继续调度
### 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)
Contributor guide
Research direction
Start by running the provided CREATE TABLE statement with TIMESTAMPTZ(3), then inspect SHOW DYNAMIC PARTITION TABLES and compare the results after the next scheduling interval. Trace the dynamic-partition scheduling path for RANGE partition columns and check how TIMESTAMPTZ is handled. Done means new daily partitions are created after the initial table creation and the SHOW command reports no unexplained error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100