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

The alias created in SELECT could be used in GROUP BY and followed expressions

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.2.0
    • SQL
    • None

    Description

      This query should be able to run:

      select a a1, a1 + 1 as b, count(1) from t group by a1

      Attachments

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. SPARK-9338 Aliases from SELECT not available in GROUP BY

          • Major - Major loss of function.
          • Resolved
          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. SPARK-19778 alais cannot use in group by

          • Major - Major loss of function.
          • Resolved
          links to

          Pull request #17191 [Github] Pull Request #17191 (maropu)

          Activity

            People

              maropu Takeshi Yamamuro
              davies Davies Liu
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: