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

[armitajli]

Affected module
Backend

Describe the bug
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

To Reproduce

Run the data quality pipeline to test uniqueness for columns of oracle in Open Metadata.
Observe the error in the logs:
/* {"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

Expected behavior
The data quality pipeline should execute successfully and return the counts of values and unique values without errors.

Version:

• OS: Debian GNU/Linux 12
• Python version: 3.10.14
• OpenMetadata version: 1.5.10.0
• OpenMetadata Ingestion package version: 1.5.10.0

Additional context
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.

[ayush-shah]

closing as duplicate #17170