[ https://issues.apache.org/jira/browse/HIVE-11025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14591366#comment-14591366 ]
Hive QA commented on HIVE-11025: -------------------------------- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12740235/HIVE-11025.patch {color:green}SUCCESS:{color} +1 9008 tests passed Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4297/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4297/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-4297/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12740235 - PreCommit-HIVE-TRUNK-Build > In windowing spec, when the datatype is decimal, it's comparing the value > against NULL value incorrectly > -------------------------------------------------------------------------------------------------------- > > Key: HIVE-11025 > URL: https://issues.apache.org/jira/browse/HIVE-11025 > Project: Hive > Issue Type: Sub-task > Components: PTF-Windowing > Affects Versions: 2.0.0 > Reporter: Aihua Xu > Assignee: Aihua Xu > Attachments: HIVE-11025.patch > > > Given data and the following query, > {noformat} > deptno empno bonus salary > 30 7698 NULL 2850.0 > 30 7900 NULL 950.0 > 30 7844 0 1500.0 > select avg(salary) over (partition by deptno order by bonus range 200 > preceding) from emp2; > {noformat} > It produces incorrect result for the row in which bonus=0 > 1900.0 > 1900.0 > 1766.6666666666667 -- This message was sent by Atlassian JIRA (v6.3.4#6332)