cube-js / cube-js/cube

Rollup Designer doesn't work: `'pre_aggregations' must be a sequence`

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

Description

**Problem**

Add to the Data Schema prompted "'pre_aggregations' must be a sequence", why?

**Related Cube.js schema**
```javascript
main: {
measures: [
vm_gs_jbxx.count
],
dimensions: [
vm_gs_jbxx.clrq,
vm_gs_jbxx.sfdm
],
timeDimension: vm_gs_jbxx.clrq,
granularity: `year`
}
```
**Related Cube.js generated SQL**
```sql
SELECT
CAST(
DATE_FORMAT(
CONVERT_TZ(`vm_gs_jbxx`.clrq, @ @session.time_zone, '+08:00'),
'%Y-01-01T00:00:00.000'
) AS DATETIME
) `vm_gs_jbxx__clrq_year`,
count(*) `vm_gs_jbxx__count`
FROM
jck.vm_gs_jbxx AS `vm_gs_jbxx`
WHERE
(`vm_gs_jbxx`.sfdm = ?)
AND (
`vm_gs_jbxx`.clrq >= TIMESTAMP(convert_tz(?, '+00:00', @ @session.time_zone))
)
GROUP BY
1
LIMIT
10000
```
Image

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.