Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5460

invalid offsets in lag lead should return an exception (per ISO-SQL)

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 0.11.0
    • Fix Version/s: 0.13.0
    • Component/s: None
    • Labels:
      None

      Description

      ISO-SQL 2011 defines how lag and lead should behave when invalid offsets are provided to the functions.

      i.e. select tint.rnum,tint.cint, lag( tint.cint, -100 ) over ( order by tint.rnum) from tint tint

      Instead of a meaningful error (as other vendors will emit) you get

      Error: Query returned non-zero code: 2, cause: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
      SQLState: 08S01
      ErrorCode: 2

        Attachments

        1. HIVE-5460.1.patch.txt
          21 kB
          Edward Capriolo

          Activity

            People

            • Assignee:
              appodictic Edward Capriolo
              Reporter:
              the6campbells N Campbell
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: