创建chart时，生成的查询SQL为什么是GROUP BY 1 ... 是否有调整的办法

[haxeljack]

2025-01-19 15:38:24,653:WARNING:superset.connectors.sqla.models:Query SELECT
anon_1."PAGE_NAME",
anon_1."count"
FROM (
SELECT
"PAGE_NAME" AS "PAGE_NAME",
COUNT() AS "count"
FROM iqpm.oms_base_log_web
GROUP BY
1
ORDER BY
COUNT() DESC
) anon_1
WHERE
ROWNUM <= 10000 on schema iqpm failed

[dosubot[bot]]

Hey @haxeljack! I'm here to help you with any bugs, questions, or contributions you have. Let's tackle this issue together.

The error "ORA-00979: not a GROUP BY expression" occurs because Oracle does not support the shorthand "GROUP BY 1" used in the generated SQL query. This shorthand is used in some databases to refer to the first column in the SELECT statement, but Oracle requires explicit column names or expressions in the GROUP BY clause.

To resolve this issue, you need to modify the query to explicitly specify the column name in the GROUP BY clause. For example, instead of:

GROUP BY 1

You should use:

GROUP BY "PAGE_NAME"

This change will ensure compatibility with Oracle by explicitly stating the column used for grouping ^[1].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}