search

cube-js / cube

📊 Cube — The Semantic Layer for Building Data Applications
https://cube.dev
Other
17.86k stars 1.77k forks source link

Cube allows to define a pre-aggregation with non-unique member references #3486

Open igorlukanin opened 3 years ago

igorlukanin commented 3 years ago

Describe the bug Cube allows to define and build a pre-aggregation with non-unique member references (e.g., one dimension referenced twice in the pre-aggregation definition).

To Reproduce

  1. Create a cube with at least one dimension
  2. Add a rollup pre-aggregation that references this dimension twice and stores pre-aggregation data in CUbe Store
  3. Execute a query (Cube will build a pre-aggregation, Cube Store will download the CSV file and store it)
  4. The query will yield this error:

    Internal: Error during planning: Schema contains duplicate qualified field name "..."

Expected behavior Cube won't compile the schema with pre-aggregations that have non-unique member references and it will show an error.

Screenshots

Screenshot 2021-09-24 at 14 23 47 Screenshot 2021-09-24 at 14 22 36

Version: 0.28.38

igorlukanin commented 3 years ago

Related: https://github.com/cube-js/cube.js/issues/3485

igorlukanin commented 1 week ago

Still reproduces on Cube v0.36.7.