You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2015/05/22 23:15:17 UTC
[jira] [Updated] (DRILL-3172) Can not plan exception when over
clause is empty
[ https://issues.apache.org/jira/browse/DRILL-3172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Victoria Markman updated DRILL-3172:
------------------------------------
Description:
With all currently supported window functions:
{code}
0: jdbc:drill:schema=dfs> select c_integer, max(c_integer) over() from j7;
Error: SYSTEM ERROR: org.apache.calcite.plan.RelOptPlanner$CannotPlanException: Node [rel#4414:Subset#7.PHYSICAL.SINGLETON([]).[]] could not be implemented; planner state:
Root: rel#4414:Subset#7.PHYSICAL.SINGLETON([]).[]
Original rel:
AbstractConverter(subset=[rel#4414:Subset#7.PHYSICAL.SINGLETON([]).[]], convention=[PHYSICAL], DrillDistributionTraitDef=[SINGLETON([])], sort=[[]]): rowcount = 7680.0, cumulative cost = {inf}, id = 4416
DrillScreenRel(subset=[rel#4413:Subset#7.LOGICAL.ANY([]).[]]): rowcount = 7680.0, cumulative cost = {768.0 rows, 768.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4412
DrillProjectRel(subset=[rel#4411:Subset#6.LOGICAL.ANY([]).[]], c_integer=[$0], EXPR$1=[$1]): rowcount = 7680.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4410
DrillProjectRel(subset=[rel#4409:Subset#5.LOGICAL.ANY([]).[]], c_integer=[$1], $1=[$2]): rowcount = 7680.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4408
DrillWindowRel(subset=[rel#4407:Subset#4.LOGICAL.ANY([]).[]], window#0=[window(partition {} order by [] range between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [MAX($1)])]): rowcount = 7680.0, cumulative cost = {7680.0 rows, 15360.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4406
DrillScanRel(subset=[rel#4405:Subset#3.LOGICAL.ANY([]).[]], table=[[dfs, subqueries, j7]], groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=maprfs:///drill/testdata/subqueries/j7]], selectionRoot=/drill/testdata/subqueries/j7, numFiles=1, columns=[`*`]]]): rowcount = 7680.0, cumulative cost = {7680.0 rows, 7.68E7 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4395
{code}
was:
With all currently supported window functions:
{code}
{code}
> Can not plan exception when over clause is empty
> -------------------------------------------------
>
> Key: DRILL-3172
> URL: https://issues.apache.org/jira/browse/DRILL-3172
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Victoria Markman
>
> With all currently supported window functions:
> {code}
> 0: jdbc:drill:schema=dfs> select c_integer, max(c_integer) over() from j7;
> Error: SYSTEM ERROR: org.apache.calcite.plan.RelOptPlanner$CannotPlanException: Node [rel#4414:Subset#7.PHYSICAL.SINGLETON([]).[]] could not be implemented; planner state:
> Root: rel#4414:Subset#7.PHYSICAL.SINGLETON([]).[]
> Original rel:
> AbstractConverter(subset=[rel#4414:Subset#7.PHYSICAL.SINGLETON([]).[]], convention=[PHYSICAL], DrillDistributionTraitDef=[SINGLETON([])], sort=[[]]): rowcount = 7680.0, cumulative cost = {inf}, id = 4416
> DrillScreenRel(subset=[rel#4413:Subset#7.LOGICAL.ANY([]).[]]): rowcount = 7680.0, cumulative cost = {768.0 rows, 768.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4412
> DrillProjectRel(subset=[rel#4411:Subset#6.LOGICAL.ANY([]).[]], c_integer=[$0], EXPR$1=[$1]): rowcount = 7680.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4410
> DrillProjectRel(subset=[rel#4409:Subset#5.LOGICAL.ANY([]).[]], c_integer=[$1], $1=[$2]): rowcount = 7680.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4408
> DrillWindowRel(subset=[rel#4407:Subset#4.LOGICAL.ANY([]).[]], window#0=[window(partition {} order by [] range between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [MAX($1)])]): rowcount = 7680.0, cumulative cost = {7680.0 rows, 15360.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4406
> DrillScanRel(subset=[rel#4405:Subset#3.LOGICAL.ANY([]).[]], table=[[dfs, subqueries, j7]], groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=maprfs:///drill/testdata/subqueries/j7]], selectionRoot=/drill/testdata/subqueries/j7, numFiles=1, columns=[`*`]]]): rowcount = 7680.0, cumulative cost = {7680.0 rows, 7.68E7 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4395
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)