drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deneche A. Hakim (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3292) SUM(constant) OVER(...) returns wrong results
Date Mon, 15 Jun 2015 16:14:00 GMT
Deneche A. Hakim created DRILL-3292:
---------------------------------------

             Summary: SUM(constant) OVER(...) returns wrong results
                 Key: DRILL-3292
                 URL: https://issues.apache.org/jira/browse/DRILL-3292
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Relational Operators, Query Planning & Optimization
    Affects Versions: 1.0.0
            Reporter: Deneche A. Hakim
            Assignee: Deneche A. Hakim


The following query returns wrong results:
{noformat}
0: jdbc:drill:> select sum(1) over w sum1, sum(5) over w sum5 from cp.`employee.json` where
position_id = 2 window w as (partition by position_id);
+-------+-------+
| sum1  | sum5  |
+-------+-------+
| 6     | 6     |
| 6     | 6     |
| 6     | 6     |
| 6     | 6     |
| 6     | 6     |
| 6     | 6     |
+-------+-------+
{noformat}

The second column should display 30 (5 x 6) instead of 6.

Here is the plan for the query:
{noformat}
00-00    Screen
00-01      Project(sum1=[$0], sum5=[$1])
00-02        Project(sum1=[$0], sum5=[$1])
00-03          Project($0=[$1], $1=[$2])
00-04            Window(window#0=[window(partition {0} order by [] range between UNBOUNDED
PRECEDING and UNBOUNDED FOLLOWING aggs [SUM($1), SUM($2)])])
00-05              SelectionVectorRemover
00-06                Sort(sort0=[$0], dir0=[ASC])
00-07                  Filter(condition=[=($0, 2)])
00-08                    Scan(groupscan=[EasyGroupScan [selectionRoot=/employee.json, numFiles=1,
columns=[`position_id`], files=[classpath:/employee.json]]])
{noformat}



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

Mime
View raw message