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

May throw exception after expr rewritten , if the group by ordinal reference is still a numeric literal

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • Impala 4.0.0
    • Impala 4.0.0
    • Frontend
    • None
    • ghx-label-6

    Description

      When the sql can rewrite,  if the group by ordinal reference is still a numeric literal, it will throw exception

      select 13, id, count(1) from dimtbl group by 1, 2;

ERROR: AnalysisException: GROUP BY: ordinal exceeds the number of items in the SELECT list: 13

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. IMPALA-9620 Predicates in the SELECT and GROUP-BY cause failure with CNF rewrite enabled

          • Major - Major loss of function.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. IMPALA-10865 Query with select alias the same as column name rewrite error for grouping exprs

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved

          Activity

            People

              xqhe Xianqing He
              xqhe Xianqing He
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: