[Feature]: supply a new drop strategy for partition plan

[yhilmare]

Is your feature request related to a problem?

no

Describe the solution you'd like

the current drop strategy is based on partition count:

this is confusing for user if he/she wants to delete partition by time.

Additional context

we need to supply a new drop strategy to drop partition by time~