Weizisheng created IMPALA-15534:
-----------------------------------
Summary: Select clause use the same case when expr with group by
clause throws AnalysisException
Key: IMPALA-15534
URL: https://issues.apache.org/jira/browse/IMPALA-15534
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 4.3.0, Impala 3.4.0
Reporter: Weizisheng
[192.168.8.24:21000] default> create table test (id int, name string) stored as
parquet;
Query: create table test (id int, name string) stored as parquet
+-------------------------+
| summary |
+-------------------------+
| Table has been created. |
+-------------------------+
Fetched 1 row(s) in 1.00s
[192.168.8.24:21000] default> select *case when '1'='1' then id else 123 end
as `分类/分类`* from test group by \{*}case when '1'='1' then id else 123 end{*};
Query: select case when '1'='1' then id else 123 end as `分类/分类` from test
group by case when '1'='1' then id else 123 end
Query submitted at: 2026-10-09 14:47:16 (Coordinator: http://192.168.8.24:25000)
*ERROR: AnalysisException: select list expression not produced by aggregation
output (missing from GROUP BY clause?): id `分类/分类`*
[192.168.8.24:21000] default> select case when '1'='1' then id else 123 end as
`分类/分类` from test group by `分类/分类`;
Query: select case when '1'='1' then id else 123 end as `分类/分类` from test
group by `分类/分类`
Query submitted at: 2026-10-09 14:58:35 (Coordinator: http://192.168.8.24:25000)
Query progress can be monitored at:
http://192.168.8.24:25000/query_plan?query_id=8d48912ab716f559:9da1cfba00000000
Fetched 0 row(s) in 0.30s
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
