Eric Lin created IMPALA-7083:
--------------------------------
Summary: Impala query failed with error AnalysisException from 2.9
onwards
Key: IMPALA-7083
URL: https://issues.apache.org/jira/browse/IMPALA-7083
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 2.9.0
Reporter: Eric Lin
To reproduce, please run below impala query:
{code}
DROP TABLE IF EXISTS test;
CREATE TABLE test (a int);
SELECT (
CASE
WHEN (1 =1)
THEN 1
ELSE a
end) AS b
FROM test
GROUP BY 1
ORDER BY (
CASE
WHEN (1 =1)
THEN 1
ELSE a
end);
{code}
It will fail with below error:
{code}
ERROR: AnalysisException: ORDER BY expression not produced by aggregation
output (missing from GROUP BY clause?): (CASE WHEN TRUE THEN 1 ELSE a END)
{code}
However, if I replace column name "a" as a constant value, it works:
{code}
SELECT (
CASE
WHEN (1 =1)
THEN 1
ELSE 2
end) AS b
FROM test
GROUP BY 1
ORDER BY (
CASE
WHEN (1 =1)
THEN 1
ELSE 2
end);
{code}
This issue is identified in CDH5.12.x (Impala 2.9), and no issues in 5.11.x
(Impala 2.8).
We know that it can be worked around by re-write as below:
{code}
SELECT (
CASE
WHEN (1 =1)
THEN 1
ELSE a
end) AS b
FROM test
GROUP BY 1
ORDER BY 1;
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
