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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: