cube icon indicating copy to clipboard operation
cube copied to clipboard

Cube Store readily ingests CSV files with non-unique columns

Open igorlukanin opened this issue 4 years ago • 1 comments

Describe the bug Cube Store loads a CSV file with pre-aggregated data and stores it without errors even if it contains non-unique columns (e.g., two columns with identical names).

To Reproduce Steps to reproduce the behavior:

  1. Create a pre-aggregation where a single dimension is references twice
  2. Execute a query and trigger pre-aggregations build
  3. The query will yield this error:

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

Expected behavior Cube Store fails to ingest data with non-unique columns and shows an error message clearly indicating the issue.

Screenshots Screenshot 2021-09-24 at 14 22 36 Screenshot 2021-09-24 at 14 18 35

Version: 0.28.38

igorlukanin avatar Sep 24 '21 11:09 igorlukanin

Still reproduces on Cube v0.36.7.

igorlukanin avatar Oct 09 '24 01:10 igorlukanin