cube-js / cube-js/cube

Set OLAP Mode for mySQL

Open
#5,850 2 comments 0 reactions 0 assignees View on GitHub
help wanted
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

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;

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.