Preaggregations partitions are only built for query dateranges instead of the partition granularity.
Open
pre-aggregations
question
- Dominant language
- Rust
- Stars
- 20.8k
- Forks
- 2.1k
- Avg merge
- 1d 2h
- Merged PRs (30d)
- 181
Description
When running a query that has pre-aggregations defined with
`partition_granularity: 'quarter', granularity: 'day'. `
I.e.
Query with timedimension `['2023-11-01', '2023-12-05']`, it will build preaggregation with `'2023_10_01'` partition but that parition is only built for `2023_10_01 to 2023_12_05 instead of 2023_10_01 to 2023_12_31`.
Now I try to query with timedimension `['2023-11-01', '2023-12-15']`, it will still use the same partition which gives wrong data as it only has data upto `'2023_12_05'`.
Let me know if you need more details for the same.
Contributor guide
Assessment
This issue has not been assessed yet.