-
Notifications
You must be signed in to change notification settings - Fork 1.9k
Open
Open
Copy link
Labels
pre-aggregationsIssues related to pre-aggregationsIssues related to pre-aggregations
Description
Describe the bug
If a pre-aggregation contains only count_distinct_approx measures (one, two, etc.) and no other dimensions or measures, it will not build. Instead, the an error is shown.
To Reproduce
Steps to reproduce the behavior:
- Take the data model below.
- Run a query to the
mesmeasure in Playground so that a p-reaggregation build is triggered. - See the following error:
Error during create table:
CREATE TABLE prod_pre_aggregations.my_cube_test_main_qilx5vis_ieu50pzh_1jimlbg (`my_cube_test__mes` BYTES) LOCATION ?:
Sort key size can't be 0 for default, columns: [Column { name: "my_cube_test__mes", column_type: Bytes, column_index: 0 }]
Expected behavior
The pre-aggregation builds.
Minimally reproducible Cube data model
cube(`my_cube_test`, {
sql: `
SELECT 123 AS abc UNION ALL
SELECT 234 AS abc UNION ALL
SELECT 345 AS abc
`,
measures: {
mes: {
sql: `abc`,
type: `count_distinct_approx`
}
},
pre_aggregations: {
main: {
measures: [ mes ]
}
}
})Version:
v1.1.2
Additional context
Adding a count measure or a dimension to the pre-aggregation definition makes the error go away.
Metadata
Metadata
Assignees
Labels
pre-aggregationsIssues related to pre-aggregationsIssues related to pre-aggregations
