StarRocks / starrocks

The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
https://starrocks.io
Apache License 2.0
8.99k stars 1.81k forks source link

Partition by quarter for date_trunc() #36799

Open jcotterill opened 11 months ago

jcotterill commented 11 months ago

Feature request

Partition by quarter for date_trunc()

Is your feature request related to a problem? Please describe. No but would improve performance based on our data and queries

Describe the solution you'd like The quarter keyword to be supported when partitioning with the date_trunc() method e.g. (PARTITION BY date_trunc('quarter', Key_BillingMonth))

Additional context image

github-actions[bot] commented 5 months ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!

jcotterill commented 5 months ago

Remove "[no-issue-activity]" tag