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-5462) improve error when an approximate numeric literal provided to lag lead
Date Sun, 06 Oct 2013 14:48:42 GMT
N Campbell created HIVE-5462:
--------------------------------

             Summary: improve error when an approximate numeric literal provided to lag lead

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


ISO SQL would define this as an error.

select vint.rnum,vint.cint, lead( vint.cint, 1.70 )  over ( order by vint.rnum) from vint
vint 

The issue is the error message returned by Hive

Query returned non-zero code: 40000, cause: FAILED: SemanticException Failed to breakup Windowing
invocations into Groups. At least 1 group must only depend on input columns. Also check for
circular dependencies.
Underlying error: org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: Lead amount must
be a integer value double was passed as parameter 1.




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

Mime
View raw message