I want to use time as a criterion for table partitioning, but do I have to add a separate field specifically for table partitioning

[JiaoXingbo]

Your Question

I want to partition tables based on the time of stored records. However, when using the framework, I found that if I use the create_time in the table as the sharding_key, I cannot search records by time range because the sharding_key is restricted to use an equal sign. Therefore, I added a separate shard_key field for the model that requires table partitioning. However, this field has no business meaning and is only used to record the shard_key. Is there any other way to achieve the requirement of partitioning tables based on time without adding additional fields?

The document you expected this should be explained

Expected answer