Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27764 Feature Parity between PostgreSQL and Spark
  3. SPARK-33125

Improve the error when Lead and Lag are not allowed to specify window frame

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.0
    • Fix Version/s: 3.1.0
    • Component/s: SQL
    • Labels:
      None

      Description

      Except for Postgresql, other data sources (for example: vertica, oracle, redshift, mysql, presto) are not allowed to specify window frame for the Lead and Lag functions.
      But the current error message is not clear enough.

      Window Frame $f must match the required frame
      

      The following error message is better.

      Cannot specify window frame for lead function
      

        Attachments

          Activity

            People

            • Assignee:
              beliefer jiaan.geng
              Reporter:
              beliefer jiaan.geng
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: