hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-5460) invalid offsets in lag lead should return an exception (per ISO-SQL)
Date Sun, 06 Oct 2013 14:44:41 GMT
N Campbell created HIVE-5460:
--------------------------------

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

                 Key: HIVE-5460
                 URL: https://issues.apache.org/jira/browse/HIVE-5460
             Project: Hive
          Issue Type: Bug
    Affects Versions: 0.11.0
            Reporter: N Campbell
            Priority: Minor


ISO-SQL 2012 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



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message