[jira] [Created] (IMPALA-7083) Impala query failed with error AnalysisException from 2.9 onwards

["Eric Lin (JIRA)" <ji...@apache.org>]

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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org