Error Executing Uniqueness Test in Data Quality for Columns (ORA-00937)

[armitajli]

I encountered an issue while running the data quality pipeline to test uniqueness for columns in Open Metadata. The pipeline fails to execute, and the following error appears in the logs:

(oracledb.exceptions.DatabaseError) ORA-00937: not a single-group group function [SQL: /* {"app": "OpenMetadata", "version": "1.5.10.0"} */ SELECT anon_1."valuesCount", anon_1."uniqueCount" FROM (SELECT count(name) AS "valuesCount", (SELECT count(*) AS "uniqueCount" FROM (SELECT count(name) AS count_1 FROM "C##ALI"."TEST_DATA_QUALITY" GROUP BY name HAVING count(name) = :count_2) only_once) AS "uniqueCount" FROM "C##ALI"."TEST_DATA_QUALITY") anon_1 WHERE ROWNUM <= 1] [parameters: {'count_2': 1}] (Background on this error at: https://sqlalche.me/e/14/4xp6)

When I ran the query separately, I also encountered the same error. It seems that there is an issue with the subquery structure or how the aggregation functions are being used in the query.