Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-30374 Feature Parity between PostgreSQL and Spark (ANSI/SQL)
  3. SPARK-33186

Respect ANSI standard and change FIRST_VALUE as pure window function.

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Later
    • 3.1.0
    • None
    • SQL
    • None

    Description

      FIRST_VALUE is an ANSI window function.
      But the current implement of FIRST_VALUE in Spark is an aggregate function.
      Although FIRST_VALUE could be used as window function.
      But it is an aggregate function in fact and will lead to users to mistakenly think that FIRST_VALUE is an aggregate function that can be used.
      Users can use FIRST now.

      Attachments

        Activity

          People

            Unassigned Unassigned
            beliefer jiaan.geng
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: