Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3596

Allow only (<expression>) or (<expression>, 1) for LEAD and LAG window functions as input parameters

    Details

      Description

      We need to disable the third input parameter in LEAD and LAG window functions. We should support this syntax.

      LEAD(<expression>) ,or LEAD(<expression>,1)
      LAG(<expression>), or LAG(<expression>,1)

      In both the functions above, the second parameter is the default offset value, use of any other value must he handled and reported to user as error.

      Use of a third input parameter to both the functions must be disallowed.

        Attachments

          Activity

            People

            • Assignee:
              adeneche Deneche A. Hakim
              Reporter:
              khfaraaz Khurram Faraaz
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: