[jira] [Updated] (DRILL-3292) SUM(constant) OVER(...) returns wrong results

2015-07-08 Thread Sean Hsuan-Yi Chu (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DRILL-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sean Hsuan-Yi Chu updated DRILL-3292:
-
Attachment: DRILL-3291.1.patch

 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: Sean Hsuan-Yi Chu
Priority: Critical
  Labels: window_function
 Fix For: 1.2.0

 Attachments: DRILL-3291.1.patch


 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-00Screen
 00-01  Project(sum1=[$0], sum5=[$1])
 00-02Project(sum1=[$0], sum5=[$1])
 00-03  Project($0=[$1], $1=[$2])
 00-04Window(window#0=[window(partition {0} order by [] range 
 between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [SUM($1), SUM($2)])])
 00-05  SelectionVectorRemover
 00-06Sort(sort0=[$0], dir0=[ASC])
 00-07  Filter(condition=[=($0, 2)])
 00-08Scan(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)

[jira] [Updated] (DRILL-3292) SUM(constant) OVER(...) returns wrong results

2015-07-01 Thread Victoria Markman (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DRILL-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Victoria Markman updated DRILL-3292:

Labels: window_function  (was: )

 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: Sean Hsuan-Yi Chu
Priority: Critical
  Labels: window_function
 Fix For: 1.2.0


 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-00Screen
 00-01  Project(sum1=[$0], sum5=[$1])
 00-02Project(sum1=[$0], sum5=[$1])
 00-03  Project($0=[$1], $1=[$2])
 00-04Window(window#0=[window(partition {0} order by [] range 
 between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [SUM($1), SUM($2)])])
 00-05  SelectionVectorRemover
 00-06Sort(sort0=[$0], dir0=[ASC])
 00-07  Filter(condition=[=($0, 2)])
 00-08Scan(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)

[jira] [Updated] (DRILL-3292) SUM(constant) OVER(...) returns wrong results

2015-06-25 Thread Aman Sinha (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DRILL-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aman Sinha updated DRILL-3292:
--
Fix Version/s: (was: 1.1.0)
   1.2.0

 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: Aman Sinha
 Fix For: 1.2.0


 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-00Screen
 00-01  Project(sum1=[$0], sum5=[$1])
 00-02Project(sum1=[$0], sum5=[$1])
 00-03  Project($0=[$1], $1=[$2])
 00-04Window(window#0=[window(partition {0} order by [] range 
 between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [SUM($1), SUM($2)])])
 00-05  SelectionVectorRemover
 00-06Sort(sort0=[$0], dir0=[ASC])
 00-07  Filter(condition=[=($0, 2)])
 00-08Scan(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)

[jira] [Updated] (DRILL-3292) SUM(constant) OVER(...) returns wrong results

2015-06-25 Thread Jacques Nadeau (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DRILL-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Nadeau updated DRILL-3292:
--
Priority: Critical  (was: Major)

 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: Aman Sinha
Priority: Critical
 Fix For: 1.2.0


 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-00Screen
 00-01  Project(sum1=[$0], sum5=[$1])
 00-02Project(sum1=[$0], sum5=[$1])
 00-03  Project($0=[$1], $1=[$2])
 00-04Window(window#0=[window(partition {0} order by [] range 
 between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [SUM($1), SUM($2)])])
 00-05  SelectionVectorRemover
 00-06Sort(sort0=[$0], dir0=[ASC])
 00-07  Filter(condition=[=($0, 2)])
 00-08Scan(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)

[jira] [Updated] (DRILL-3292) SUM(constant) OVER(...) returns wrong results

2015-06-16 Thread Aman Sinha (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DRILL-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Aman Sinha updated DRILL-3292:
--
Fix Version/s: 1.1.0

 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
 Fix For: 1.1.0


 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-00Screen
 00-01  Project(sum1=[$0], sum5=[$1])
 00-02Project(sum1=[$0], sum5=[$1])
 00-03  Project($0=[$1], $1=[$2])
 00-04Window(window#0=[window(partition {0} order by [] range 
 between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [SUM($1), SUM($2)])])
 00-05  SelectionVectorRemover
 00-06Sort(sort0=[$0], dir0=[ASC])
 00-07  Filter(condition=[=($0, 2)])
 00-08Scan(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)