drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Neeraja (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1487) Drill window functions return wrong results
Date Fri, 03 Oct 2014 05:16:33 GMT
Neeraja created DRILL-1487:
------------------------------

             Summary: Drill window functions return wrong results
                 Key: DRILL-1487
                 URL: https://issues.apache.org/jira/browse/DRILL-1487
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 0.6.0
            Reporter: Neeraja


Executing the following window function with the requirement to see how a given employee salary
would compare to the avg(salary) in his/her position. 
Query executes fine however returns wrong results(expect the avg(salary) to stay same for
a given window (i.e position id)


0: jdbc:drill:zk=local> SELECT employee_id,position_id, salary, avg(salary) OVER (PARTITION
BY position_id order by position_id) FROM cp.`employee.json` order by employee_id;
+-------------+-------------+------------+------------+
| employee_id | position_id |   salary   |   EXPR$3   |
+-------------+-------------+------------+------------+
| 1           | 1           | 80000.0    | 80000.0    |
| 2           | 2           | 40000.0    | 37500.0    |
| 4           | 2           | 40000.0    | 38333.333333333336 |
| 5           | 2           | 35000.0    | 35000.0    |
| 6           | 3           | 25000.0    | 25000.0    |
| 7           | 4           | 15000.0    | 15000.0    |
| 8           | 11          | 10000.0    | 14333.333333333334 |
| 9           | 11          | 17000.0    | 17000.0    |



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message