Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-33307 Refactor GROUPING ANALYTICS
  3. SPARK-34986

Aggregate ordinal should judge is it contains agg function

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.2.0
    • 3.2.0
    • SQL
    • None

    Description

      Aggregate ordinal should judge is it contains agg function.

      before this change it's
      ```

      – !query
      select a, b, sum(b) from data group by 3
      – !query schema
      struct<>
      – !query output
      org.apache.spark.sql.AnalysisException
      aggregate functions are not allowed in GROUP BY, but found sum(data.b)

      ```

      Attachments

        Activity

          People

            angerszhuuu angerszhu
            angerszhuuu angerszhu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: