cube-js / cube-js/cube

Preaggregations partitions are only built for query dateranges instead of the partition granularity.

Open
#7,713 3 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.