[IMPALA-7083] AnalysisException for GROUP BY and ORDER BY expressions that are folded to constants from 2.9 onwards

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: Impala 2.9.0
• Component/s: Frontend
• Labels: regression
• Epic Color: ghx-label-7
• Assignee: Unassigned
• Reporter: Eric Lin
• Created: 27/May/18 23:55
• Updated: 07/Sep/23 22:22

Description

To reproduce, please run below impala query:

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);

It will fail with below error:

ERROR: AnalysisException: ORDER BY expression not produced by aggregation output (missing from GROUP BY clause?): (CASE WHEN TRUE THEN 1 ELSE a END)

However, if I replace column name "a" as a constant value, it works:

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);

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:

SELECT   ( 
    CASE 
       WHEN (1 =1) 
       THEN 1
       ELSE a
    end) AS b
FROM  test 
GROUP BY 1 
ORDER BY 1;

Issue Links

• causes: IMPALA-7094 Fallback to an unoptimized query if ExprRewriter fails
• is related to: IMPALA-7785 GROUP BY clause not analyzed prior to rewrite step