cube-js/cube

Set OLAP Mode for mySQL

Open

#5.850 geöffnet am 20. Dez. 2022

Auf GitHub ansehen
 (2 Kommentare) (0 Reaktionen) (0 zugewiesene Personen)Rust (1.965 Forks)batch import
help wanted

Repository-Metriken

Stars
 (19.563 Stars)
PR-Merge-Metriken
 (Durchschn. Merge 5T 16h) (138 gemergte PRs in 30 T)

Beschreibung

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;

Contributor Guide