[jira] [Updated] (DRILL-2234) IOOB when streaming aggregate is on the left side of hash join
[ https://issues.apache.org/jira/browse/DRILL-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zelaine Fong updated DRILL-2234: Assignee: Boaz Ben-Zvi > IOOB when streaming aggregate is on the left side of hash join > -- > > Key: DRILL-2234 > URL: https://issues.apache.org/jira/browse/DRILL-2234 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Relational Operators >Reporter: Mehant Baid >Assignee: Boaz Ben-Zvi > Fix For: Future > > > This issue is similar to DRILL-2107. > Issue can be reproduced by enabling SwapJoinRule in DrillRuleSets and running > the following query. > alter session set `planner.slice_target` = 1; > alter session set `planner.enable_hashagg` = false; > alter session set `planner.enable_streamagg` = true; > select l_suppkey, sum(l_extendedprice)/sum(l_quantity) as avg_price > from cp.`tpch/lineitem.parquet` where l_orderkey in > (select o_orderkey from cp.`tpch/orders.parquet` where o_custkey = 2) > group by l_suppkey having sum(l_extendedprice)/sum(l_quantity) > 1850.0; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (DRILL-2234) IOOB when streaming aggregate is on the left side of hash join
[ https://issues.apache.org/jira/browse/DRILL-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2234: - Fix Version/s: (was: 1.1.0) 1.2.0 IOOB when streaming aggregate is on the left side of hash join -- Key: DRILL-2234 URL: https://issues.apache.org/jira/browse/DRILL-2234 Project: Apache Drill Issue Type: Bug Components: Execution - Relational Operators Reporter: Mehant Baid Assignee: Mehant Baid Fix For: 1.2.0 This issue is similar to DRILL-2107. Issue can be reproduced by enabling SwapJoinRule in DrillRuleSets and running the following query. alter session set `planner.slice_target` = 1; alter session set `planner.enable_hashagg` = false; alter session set `planner.enable_streamagg` = true; select l_suppkey, sum(l_extendedprice)/sum(l_quantity) as avg_price from cp.`tpch/lineitem.parquet` where l_orderkey in (select o_orderkey from cp.`tpch/orders.parquet` where o_custkey = 2) group by l_suppkey having sum(l_extendedprice)/sum(l_quantity) 1850.0; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (DRILL-2234) IOOB when streaming aggregate is on the left side of hash join
[ https://issues.apache.org/jira/browse/DRILL-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2234: Fix Version/s: (was: 1.0.0) 1.1.0 IOOB when streaming aggregate is on the left side of hash join -- Key: DRILL-2234 URL: https://issues.apache.org/jira/browse/DRILL-2234 Project: Apache Drill Issue Type: Bug Components: Execution - Relational Operators Reporter: Mehant Baid Assignee: Mehant Baid Fix For: 1.1.0 This issue is similar to DRILL-2107. Issue can be reproduced by enabling SwapJoinRule in DrillRuleSets and running the following query. alter session set `planner.slice_target` = 1; alter session set `planner.enable_hashagg` = false; alter session set `planner.enable_streamagg` = true; select l_suppkey, sum(l_extendedprice)/sum(l_quantity) as avg_price from cp.`tpch/lineitem.parquet` where l_orderkey in (select o_orderkey from cp.`tpch/orders.parquet` where o_custkey = 2) group by l_suppkey having sum(l_extendedprice)/sum(l_quantity) 1850.0; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (DRILL-2234) IOOB when streaming aggregate is on the left side of hash join
[ https://issues.apache.org/jira/browse/DRILL-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2234: - Assignee: Mehant Baid (was: Sean Hsuan-Yi Chu) IOOB when streaming aggregate is on the left side of hash join -- Key: DRILL-2234 URL: https://issues.apache.org/jira/browse/DRILL-2234 Project: Apache Drill Issue Type: Bug Components: Execution - Relational Operators Reporter: Mehant Baid Assignee: Mehant Baid Fix For: 1.0.0 This issue is similar to DRILL-2107. Issue can be reproduced by enabling SwapJoinRule in DrillRuleSets and running the following query. alter session set `planner.slice_target` = 1; alter session set `planner.enable_hashagg` = false; alter session set `planner.enable_streamagg` = true; select l_suppkey, sum(l_extendedprice)/sum(l_quantity) as avg_price from cp.`tpch/lineitem.parquet` where l_orderkey in (select o_orderkey from cp.`tpch/orders.parquet` where o_custkey = 2) group by l_suppkey having sum(l_extendedprice)/sum(l_quantity) 1850.0; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (DRILL-2234) IOOB when streaming aggregate is on the left side of hash join
[ https://issues.apache.org/jira/browse/DRILL-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2234: --- Assignee: Sean Hsuan-Yi Chu (was: Mehant Baid) IOOB when streaming aggregate is on the left side of hash join -- Key: DRILL-2234 URL: https://issues.apache.org/jira/browse/DRILL-2234 Project: Apache Drill Issue Type: Bug Components: Execution - Relational Operators Reporter: Mehant Baid Assignee: Sean Hsuan-Yi Chu Fix For: 1.0.0 This issue is similar to DRILL-2107. Issue can be reproduced by enabling SwapJoinRule in DrillRuleSets and running the following query. alter session set `planner.slice_target` = 1; alter session set `planner.enable_hashagg` = false; alter session set `planner.enable_streamagg` = true; select l_suppkey, sum(l_extendedprice)/sum(l_quantity) as avg_price from cp.`tpch/lineitem.parquet` where l_orderkey in (select o_orderkey from cp.`tpch/orders.parquet` where o_custkey = 2) group by l_suppkey having sum(l_extendedprice)/sum(l_quantity) 1850.0; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (DRILL-2234) IOOB when streaming aggregate is on the left side of hash join
[ https://issues.apache.org/jira/browse/DRILL-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2234: - Fix Version/s: (was: 0.9.0) 1.0.0 IOOB when streaming aggregate is on the left side of hash join -- Key: DRILL-2234 URL: https://issues.apache.org/jira/browse/DRILL-2234 Project: Apache Drill Issue Type: Bug Components: Execution - Relational Operators Reporter: Mehant Baid Assignee: Mehant Baid Fix For: 1.0.0 This issue is similar to DRILL-2107. Issue can be reproduced by enabling SwapJoinRule in DrillRuleSets and running the following query. alter session set `planner.slice_target` = 1; alter session set `planner.enable_hashagg` = false; alter session set `planner.enable_streamagg` = true; select l_suppkey, sum(l_extendedprice)/sum(l_quantity) as avg_price from cp.`tpch/lineitem.parquet` where l_orderkey in (select o_orderkey from cp.`tpch/orders.parquet` where o_custkey = 2) group by l_suppkey having sum(l_extendedprice)/sum(l_quantity) 1850.0; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (DRILL-2234) IOOB when streaming aggregate is on the left side of hash join
[ https://issues.apache.org/jira/browse/DRILL-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2234: - Fix Version/s: (was: 0.8.0) 0.9.0 IOOB when streaming aggregate is on the left side of hash join -- Key: DRILL-2234 URL: https://issues.apache.org/jira/browse/DRILL-2234 Project: Apache Drill Issue Type: Bug Components: Execution - Relational Operators Reporter: Mehant Baid Assignee: Mehant Baid Fix For: 0.9.0 This issue is similar to DRILL-2107. Issue can be reproduced by enabling SwapJoinRule in DrillRuleSets and running the following query. alter session set `planner.slice_target` = 1; alter session set `planner.enable_hashagg` = false; alter session set `planner.enable_streamagg` = true; select l_suppkey, sum(l_extendedprice)/sum(l_quantity) as avg_price from cp.`tpch/lineitem.parquet` where l_orderkey in (select o_orderkey from cp.`tpch/orders.parquet` where o_custkey = 2) group by l_suppkey having sum(l_extendedprice)/sum(l_quantity) 1850.0; -- This message was sent by Atlassian JIRA (v6.3.4#6332)