GitHub user alislman21 created a discussion: Error: ORA-00979: not a GROUP BY expression - Superset with OracleDB
Hello everyone, I'm trying to use Apache Superset with an Oracle 19c or 21 databases. Whenever I create a Custom SQL query or build a chart Dataset from an existing table, I consistently get this error: Error: ORA-00979: not a GROUP BY expression <img width="1913" height="644" alt="Screenshot" src="https://github.com/user-attachments/assets/1a31598d-234b-4cc9-a7f3-dfbc524caf1a"; /> What I found so far After investigating, it seems that: Oracle does not support positional GROUP BY (e.g., GROUP BY 1). Superset’s SQLAlchemy/engine layer rewrites the query before execution. During this reformatting, Superset adds GROUP BY 1 by default, which causes Oracle to throw the ORA‑00979 error. ❗ Problem Because Oracle doesn't allow GROUP BY <position>, the rewritten queries fail even if the original SQL is valid. Question Has anyone faced this issue before? Is there a workaround, configuration change, or patch that allows Superset to work properly with Oracle 19c despite this GROUP BY handling? Any help or guidance would be appreciated! NOTE: Superset version is 6.0 GitHub link: https://github.com/apache/superset/discussions/37431 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
