hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-11025) In windowing spec, when the datatype is decimal, it's comparing the value against NULL value incorrectly
Date Tue, 16 Jun 2015 19:33:00 GMT
Aihua Xu created HIVE-11025:
-------------------------------

             Summary: 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


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)

Mime
View raw message