Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-24790

Allow complex aggregate expressions in Pivot

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.4.0
    • Fix Version/s: 2.4.0
    • Component/s: SQL
    • Labels:
      None

      Description

      In SPARK-24035, to conform with Oracle PIVOT syntax, a strict check of PIVOT's aggregate expressions was exerted, which allows only an AggregateExpression with or without alias. Now we would like to relax the check to allow complex aggregate expressions, like ceil(sum(col1)) or sum(col1) + 1

        Attachments

          Activity

            People

            • Assignee:
              maryannxue Wei Xue
              Reporter:
              maryannxue Wei Xue
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: