search

diffix / explorer

Tool to automatically explore and generate stats on data anonymized using Diffix
MIT License
2 stars 1 forks source link

Error: Duplicate grouping sets #250

Closed sebastian closed 4 years ago

sebastian commented 4 years ago 
Aircloak API query error.
DataSource: LondonPolice.
Error: Duplicated grouping sets used in the `GROUP BY` clause.
Query Id: eced35a6-7110-47a7-807f-142f7ea85d27
Query Statement: 
                select
                    grouping_id(
                        bucket("Longitude" by 0.0001),bucket("Longitude" by 0.0001),bucket("Longitude" by 0.0005)
                    ),
                    bucket("Longitude" by 0.0001),bucket("Longitude" by 0.0001),bucket("Longitude" by 0.0005),
                    count(*),
                    count_noise(*)
                from "london_street"
                group by grouping sets (2,3,4)

The problem is that you are loading out the same bucket of 0.0001 twice in a row (index 2 and 3). It's questionable whether this should really be an error or not, but either way the query isn't particularly meaningful, so probably worth fixing on the Explorer side too.

Internal issue: https://github.com/Aircloak/aircloak/issues/4625