Configurable Partition options

[mr-karan]

We have a large deployment log cluster and store multiple year's worth of logs. For us, partitioning by date is more useful than partitioning by hour.

Would it be possible to have this configurable as a PARTITION_INTERVAL variable?

Probably we can take

• weekly
• monthly
• daily`
• hourly

as different options from user, fallback being the current hourly.

Thanks!

[lmangani]

@akvlad and @adubovikov any comments or suggestions here?

[adubovikov]

@mr-karan i suggestion to you make it daily because at the end you should not have a huge number of partitions in the table. You should not worry about huge file, because scan will be by partition datetime key.

[lmangani]

Feel free to reopen if still interested for 3.x