cube-js/cube

Recycle preaggregations for different timezone when granularity is <= 1h

Open

#4,263 opened on Mar 24, 2022

View on GitHub
 (4 comments) (1 reaction) (0 assignees)Rust (1,965 forks)batch import
help wanted

Repository metrics

Stars
 (19,563 stars)
PR merge metrics
 (Avg merge 5d 16h) (138 merged PRs in 30d)

Description

In order to use preaggregations with timezones we now need to specify in the configurations files a list of timezones for which cubejs generate the aggregations periodically. This makes sense when the granularity is larger than one hour, since the data might be different. However, when the granularity is one hour or less the UTC preaggregations could be used, just by shiftings the key by n-hours.

Contributor guide

Research direction
Explore the preaggregation caching logic in Cube.js to identify where timezone keys are generated and modify the logic to allow reuse of UTC preaggregations for granularities ≤1h by shifting keys.
Tech stack
javascripttypescript
Domain
backend
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
JavaScript
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
50