cube-js/cube

Set OLAP Mode for mySQL

Open

#5 850 ouverte le 20 déc. 2022

Voir sur GitHub
 (2 commentaires) (0 réactions) (0 assignés)Rust (1 965 forks)batch import
help wanted

Métriques du dépôt

Stars
 (19 563 stars)
Métriques de merge PR
 (Merge moyen 5j 16h) (138 PRs mergées en 30 j)

Description

Is your feature request related to a problem? Please describe. MySQL and Planetscale, as a result, impose query timeouts when running on OLTP mode. Setting the mode to OLAP via a SQL set query resolves this.

Describe the solution you'd like Cube.js to support the setting of DB-level variables in the config file.

Describe alternatives you've considered I spoke to Rory from cube cloud support, and we tried multiple types of pre-aggregations over days.

Additional context Sample Error: (errno 2013) due to context deadline exceeded, elapsed time: 20.000298157s What I need to execute: SET workload=olap;

Guide contributeur