[Question]: V1.4.0 does not support DYNAMIC_PARTITION_POLICY, V1.3.0 is available

[SeoMP]

seekdb V1.4.0 (REVISION: 1-0003f8d4b32a2cfe3b75ae8f4dbe26fcee994541, Ubuntu 24.04):

CREATE TABLE t1 (id bigint NOT NULL, d datetime NOT NULL, PRIMARY KEY(id, d))
DYNAMIC_PARTITION_POLICY = (ENABLE = true, TIME_UNIT = 'day', EXPIRE_TIME = '30 day');
-- ERROR 1064 (42000): syntax error near 'DYNAMIC_PARTITION_POLICY ...'

This syntax can be used normally in V1.3.0. This syntax description is still retained in the document, but an error is reported when V1.4.0 is executed.
Is dynamic partitioning removed in V1.4.0 or is the syntax changed?

[hnwyllmm]

Thanks for reaching out. In V1.4.0, we removed dynamic partitioning, along with a number of other non-core features, as part of our effort to streamline seekdb and reduce its resource footprint.

Could you share more details about the scenario in which you need dynamic partitioning, such as the data retention pattern, partition granularity, expected data volume, and how you currently use this feature? This will help us better understand the requirement and evaluate the appropriate solution.

[SeoMP]

就是按照天分区，存储指标数据，做统计分析；目前用静态分区，然后使用job实现分区自动创建、删除的功能；

[hnwyllmm]

We’re very sorry for the inconvenience caused by this change.

Would it be fair to say that your use case is a time-series database workload, or something similar, where data is continuously written and partitions need to be created and expired on a rolling basis?

We’d be very happy to discuss your requirements and scenario further. Your feedback will help us better evaluate how seekdb should support this kind of workload.

[SeoMP]

对，指标数据比较大，所以要建按天建分区，然后借助seekdb的窗口函数进行统计，只是一些简单统计展示功能，所以不想引入专业的olap数据库，并且seekdb有olap的能力，所以就直接用seekdb