Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-7083

AnalysisException for GROUP BY and ORDER BY expressions that are folded to constants from 2.9 onwards

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • Impala 2.9.0
    • None
    • Frontend

    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;
      

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            ericlin Eric Lin

            Dates

              Created:
              Updated:

              Slack

                Issue deployment