Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27561 Support "lateral column alias references" to allow column aliases to be used within SELECT clauses
  3. SPARK-43851

Support LCA in grouping expressions

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Reopened
    • Major
    • Resolution: Unresolved
    • 3.5.0
    • None
    • SQL

    Description

      Teradata supports it:

      create table t1(a int) using  parquet;
select a + 1 as a1, a1 + 1 as a2 from t1 group by a1, a2;

      [UNSUPPORTED_FEATURE.LATERAL_COLUMN_ALIAS_IN_GROUP_BY] The feature is not supported: Referencing a lateral column alias via GROUP BY alias/ALL is not supported yet.

      Attachments

        Activity

          People

            Unassigned Unassigned
            yumwang Yuming Wang
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated: