You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2015/05/07 01:16:01 UTC
[jira] [Commented] (DRILL-2897) Update Limit 0 to avoid
parallelization
[ https://issues.apache.org/jira/browse/DRILL-2897?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14531645#comment-14531645 ]
Jacques Nadeau commented on DRILL-2897:
---------------------------------------
Yeah, the issue has nothing to do with the limit 0 bit. This query just fails if exchanges are disabled. It appears to be an issue with Hash Join disabled.
Can be reproduced as follows. [~amansinha100], can you take a look and let me know what you think is going wrong?
{code}
ALTER SESSION SET `planner.enable_hashjoin` = false";
{code}
{code}
ALTER SESSION SET `planner.disable_exchanges` = true";
{code}
{code}
SELECT
nations.N_NAME,
regions.R_NAME
FROM
cp.`tpch/nation.parquet` nations
JOIN
cp.`tpch/region.parquet` regions
on nations.N_REGIONKEY = regions.R_REGIONKEY where 1 = 0"
{code}
Trace
{code}
Node [rel#90:Subset#16.PHYSICAL.SINGLETON([]).[]] could not be implemented; planner state:
Root: rel#90:Subset#16.PHYSICAL.SINGLETON([]).[]
Original rel:
AbstractConverter(subset=[rel#90:Subset#16.PHYSICAL.SINGLETON([]).[]], convention=[PHYSICAL], DrillDistributionTraitDef=[SINGLETON([])], sort=[[]]): rowcount = 25.0, cumulative cost = {inf}, id = 92
DrillScreenRel(subset=[rel#89:Subset#16.LOGICAL.ANY([]).[]]): rowcount = 25.0, cumulative cost = {2.5 rows, 2.5 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 88
DrillLimitRel(subset=[rel#87:Subset#15.LOGICAL.ANY([]).[]], offset=[0], fetch=[0]): rowcount = 25.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 86
DrillProjectRel(subset=[rel#85:Subset#14.LOGICAL.ANY([]).[]], N_NAME=[$1], R_NAME=[$3]): rowcount = 25.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 84
DrillJoinRel(subset=[rel#83:Subset#13.LOGICAL.ANY([]).[]], condition=[=($0, $2)], joinType=[inner]): rowcount = 25.0, cumulative cost = {30.0 rows, 340.0 cpu, 0.0 io, 0.0 network, 88.0 memory}, id = 82
DrillProjectRel(subset=[rel#80:Subset#11.LOGICAL.ANY([]).[]], N_REGIONKEY=[$1], N_NAME=[$0]): rowcount = 25.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 79
DrillScanRel(subset=[rel#78:Subset#10.LOGICAL.ANY([]).[]], table=[[cp, tpch/nation.parquet]], groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=/tpch/nation.parquet]], selectionRoot=/tpch/nation.parquet, numFiles=1, columns=[`N_REGIONKEY`, `N_NAME`]]]): rowcount = 25.0, cumulative cost = {25.0 rows, 50.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 66
DrillScanRel(subset=[rel#81:Subset#12.LOGICAL.ANY([]).[]], table=[[cp, tpch/region.parquet]], groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=/tpch/region.parquet]], selectionRoot=/tpch/region.parquet, numFiles=1, columns=[`R_REGIONKEY`, `R_NAME`]]]): rowcount = 5.0, cumulative cost = {5.0 rows, 10.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 64
Sets:
Set#10, type: RecordType(ANY N_NAME, ANY N_REGIONKEY)
rel#78:Subset#10.LOGICAL.ANY([]).[], best=rel#66, importance=0.531441
rel#66:DrillScanRel.LOGICAL.ANY([]).[](table=[cp, tpch/nation.parquet],groupscan=ParquetGroupScan [entries=[ReadEntryWithPath [path=/tpch/nation.parquet]], selectionRoot=/tpch/nation.parquet, numFiles=1, columns=[`N_REGIONKEY`, `N_NAME`]]), rowcount=25.0, cumulative cost={25.0 rows, 50.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
rel#159:AbstractConverter.LOGICAL.ANY([]).[](input=rel#158:Subset#10.PHYSICAL.SINGLETON([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#162:AbstractConverter.LOGICAL.ANY([]).[](input=rel#161:Subset#10.PHYSICAL.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#158:Subset#10.PHYSICAL.SINGLETON([]).[], best=rel#157, importance=0.4782969000000001
rel#160:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#78:Subset#10.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#157:ScanPrel.PHYSICAL.SINGLETON([]).[](groupscan=ParquetGroupScan [entries=[ReadEntryWithPath [path=/tpch/nation.parquet]], selectionRoot=/tpch/nation.parquet, numFiles=1, columns=[`N_REGIONKEY`, `N_NAME`]]), rowcount=25.0, cumulative cost={25.0 rows, 50.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
rel#163:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#161:Subset#10.PHYSICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#202:UnionExchangePrel.PHYSICAL.SINGLETON([]).[](input=rel#161:Subset#10.PHYSICAL.ANY([]).[]), rowcount=25.0, cumulative cost={50.0 rows, 250.0 cpu, 0.0 io, 204800.0 network, 0.0 memory}
rel#161:Subset#10.PHYSICAL.ANY([]).[], best=rel#157, importance=0.4304672100000001
rel#160:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#78:Subset#10.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#157:ScanPrel.PHYSICAL.SINGLETON([]).[](groupscan=ParquetGroupScan [entries=[ReadEntryWithPath [path=/tpch/nation.parquet]], selectionRoot=/tpch/nation.parquet, numFiles=1, columns=[`N_REGIONKEY`, `N_NAME`]]), rowcount=25.0, cumulative cost={25.0 rows, 50.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
rel#163:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#161:Subset#10.PHYSICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#164:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#78:Subset#10.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#165:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#158:Subset#10.PHYSICAL.SINGLETON([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#202:UnionExchangePrel.PHYSICAL.SINGLETON([]).[](input=rel#161:Subset#10.PHYSICAL.ANY([]).[]), rowcount=25.0, cumulative cost={50.0 rows, 250.0 cpu, 0.0 io, 204800.0 network, 0.0 memory}
Set#11, type: RecordType(ANY N_REGIONKEY, ANY N_NAME)
rel#80:Subset#11.LOGICAL.ANY([]).[], best=rel#79, importance=0.5904900000000001
rel#79:DrillProjectRel.LOGICAL.ANY([]).[](input=rel#78:Subset#10.LOGICAL.ANY([]).[],N_REGIONKEY=$1,N_NAME=$0), rowcount=25.0, cumulative cost={26.0 rows, 51.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
rel#120:AbstractConverter.LOGICAL.ANY([]).[](input=rel#119:Subset#11.PHYSICAL.ANY([]).[0],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#168:AbstractConverter.LOGICAL.ANY([]).[](input=rel#167:Subset#11.PHYSICAL.SINGLETON([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#176:AbstractConverter.LOGICAL.ANY([]).[](input=rel#175:Subset#11.PHYSICAL.RANDOM_DISTRIBUTED([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#119:Subset#11.PHYSICAL.ANY([]).[0], best=null, importance=0.531441
rel#121:AbstractConverter.PHYSICAL.ANY([]).[0](input=rel#80:Subset#11.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#169:AbstractConverter.PHYSICAL.ANY([]).[0](input=rel#167:Subset#11.PHYSICAL.SINGLETON([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#177:AbstractConverter.PHYSICAL.ANY([]).[0](input=rel#175:Subset#11.PHYSICAL.RANDOM_DISTRIBUTED([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#167:Subset#11.PHYSICAL.SINGLETON([]).[], best=rel#166, importance=0.4782969000000001
rel#170:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#80:Subset#11.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#171:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#119:Subset#11.PHYSICAL.ANY([]).[0],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#166:ProjectPrel.PHYSICAL.SINGLETON([]).[](input=rel#158:Subset#10.PHYSICAL.SINGLETON([]).[],N_REGIONKEY=$1,N_NAME=$0), rowcount=25.0, cumulative cost={26.0 rows, 51.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
rel#178:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#175:Subset#11.PHYSICAL.RANDOM_DISTRIBUTED([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#193:UnionExchangePrel.PHYSICAL.SINGLETON([]).[](input=rel#175:Subset#11.PHYSICAL.RANDOM_DISTRIBUTED([]).[]), rowcount=25.0, cumulative cost={51.0 rows, 251.0 cpu, 0.0 io, 204800.0 network, 0.0 memory}
rel#194:UnionExchangePrel.PHYSICAL.SINGLETON([]).[](input=rel#119:Subset#11.PHYSICAL.ANY([]).[0]), rowcount=25.0, cumulative cost={inf}
rel#175:Subset#11.PHYSICAL.RANDOM_DISTRIBUTED([]).[], best=rel#174, importance=0.4304672100000001
rel#179:AbstractConverter.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#80:Subset#11.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=RANDOM_DISTRIBUTED([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#180:AbstractConverter.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#119:Subset#11.PHYSICAL.ANY([]).[0],convention=PHYSICAL,DrillDistributionTraitDef=RANDOM_DISTRIBUTED([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#181:AbstractConverter.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#167:Subset#11.PHYSICAL.SINGLETON([]).[],convention=PHYSICAL,DrillDistributionTraitDef=RANDOM_DISTRIBUTED([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#174:ProjectPrel.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#161:Subset#10.PHYSICAL.ANY([]).[],N_REGIONKEY=$1,N_NAME=$0), rowcount=25.0, cumulative cost={26.0 rows, 51.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
Set#12, type: RecordType(ANY R_REGIONKEY, ANY R_NAME)
rel#81:Subset#12.LOGICAL.ANY([]).[], best=rel#64, importance=0.5904900000000001
rel#64:DrillScanRel.LOGICAL.ANY([]).[](table=[cp, tpch/region.parquet],groupscan=ParquetGroupScan [entries=[ReadEntryWithPath [path=/tpch/region.parquet]], selectionRoot=/tpch/region.parquet, numFiles=1, columns=[`R_REGIONKEY`, `R_NAME`]]), rowcount=5.0, cumulative cost={5.0 rows, 10.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
rel#123:AbstractConverter.LOGICAL.ANY([]).[](input=rel#122:Subset#12.PHYSICAL.ANY([]).[0],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=5.0, cumulative cost={inf}
rel#197:AbstractConverter.LOGICAL.ANY([]).[](input=rel#196:Subset#12.PHYSICAL.SINGLETON([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=5.0, cumulative cost={inf}
rel#122:Subset#12.PHYSICAL.ANY([]).[0], best=null, importance=0.531441
rel#124:AbstractConverter.PHYSICAL.ANY([]).[0](input=rel#81:Subset#12.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=5.0, cumulative cost={inf}
rel#198:AbstractConverter.PHYSICAL.ANY([]).[0](input=rel#196:Subset#12.PHYSICAL.SINGLETON([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=5.0, cumulative cost={inf}
rel#196:Subset#12.PHYSICAL.SINGLETON([]).[], best=rel#195, importance=0.4782969000000001
rel#199:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#81:Subset#12.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=5.0, cumulative cost={inf}
rel#200:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#122:Subset#12.PHYSICAL.ANY([]).[0],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=5.0, cumulative cost={inf}
rel#195:ScanPrel.PHYSICAL.SINGLETON([]).[](groupscan=ParquetGroupScan [entries=[ReadEntryWithPath [path=/tpch/region.parquet]], selectionRoot=/tpch/region.parquet, numFiles=1, columns=[`R_REGIONKEY`, `R_NAME`]]), rowcount=5.0, cumulative cost={5.0 rows, 10.0 cpu, 0.0 io, 0.0 network, 0.0 memory}
rel#201:UnionExchangePrel.PHYSICAL.SINGLETON([]).[](input=rel#122:Subset#12.PHYSICAL.ANY([]).[0]), rowcount=5.0, cumulative cost={inf}
Set#13, type: RecordType(ANY N_REGIONKEY, ANY N_NAME, ANY R_REGIONKEY, ANY R_NAME)
rel#83:Subset#13.LOGICAL.ANY([]).[], best=rel#82, importance=0.6561
rel#82:DrillJoinRel.LOGICAL.ANY([]).[](left=rel#80:Subset#11.LOGICAL.ANY([]).[],right=rel#81:Subset#12.LOGICAL.ANY([]).[],condition==($0, $2),joinType=inner), rowcount=25.0, cumulative cost={61.0 rows, 401.0 cpu, 0.0 io, 0.0 network, 88.0 memory}
rel#110:AbstractConverter.LOGICAL.ANY([]).[](input=rel#109:Subset#13.PHYSICAL.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#127:AbstractConverter.LOGICAL.ANY([]).[](input=rel#126:Subset#13.PHYSICAL.ANY([]).[0],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#133:AbstractConverter.LOGICAL.ANY([]).[](input=rel#132:Subset#13.NONE.ANY([]).[0],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#109:Subset#13.PHYSICAL.ANY([]).[], best=null, importance=0.5904900000000001
rel#111:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#83:Subset#13.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#128:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#126:Subset#13.PHYSICAL.ANY([]).[0],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#129:AbstractConverter.PHYSICAL.ANY([]).[0](input=rel#83:Subset#13.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#130:AbstractConverter.PHYSICAL.ANY([]).[0](input=rel#109:Subset#13.PHYSICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#125:HashJoinPrel.PHYSICAL.ANY([]).[0](left=rel#119:Subset#11.PHYSICAL.ANY([]).[0],right=rel#122:Subset#12.PHYSICAL.ANY([]).[0],condition==($0, $2),joinType=inner), rowcount=25.0, cumulative cost={inf}
rel#134:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#132:Subset#13.NONE.ANY([]).[0],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#135:AbstractConverter.PHYSICAL.ANY([]).[0](input=rel#132:Subset#13.NONE.ANY([]).[0],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#139:SortPrel.PHYSICAL.ANY([]).[0](input=rel#109:Subset#13.PHYSICAL.ANY([]).[],sort0=$0,dir0=ASC), rowcount=25.0, cumulative cost={inf}
rel#156:MergeJoinPrel.PHYSICAL.ANY([]).[0](left=rel#119:Subset#11.PHYSICAL.ANY([]).[0],right=rel#122:Subset#12.PHYSICAL.ANY([]).[0],condition==($0, $2),joinType=inner), rowcount=25.0, cumulative cost={inf}
rel#126:Subset#13.PHYSICAL.ANY([]).[0], best=null, importance=0.531441
rel#129:AbstractConverter.PHYSICAL.ANY([]).[0](input=rel#83:Subset#13.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#130:AbstractConverter.PHYSICAL.ANY([]).[0](input=rel#109:Subset#13.PHYSICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#125:HashJoinPrel.PHYSICAL.ANY([]).[0](left=rel#119:Subset#11.PHYSICAL.ANY([]).[0],right=rel#122:Subset#12.PHYSICAL.ANY([]).[0],condition==($0, $2),joinType=inner), rowcount=25.0, cumulative cost={inf}
rel#135:AbstractConverter.PHYSICAL.ANY([]).[0](input=rel#132:Subset#13.NONE.ANY([]).[0],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#139:SortPrel.PHYSICAL.ANY([]).[0](input=rel#109:Subset#13.PHYSICAL.ANY([]).[],sort0=$0,dir0=ASC), rowcount=25.0, cumulative cost={inf}
rel#156:MergeJoinPrel.PHYSICAL.ANY([]).[0](left=rel#119:Subset#11.PHYSICAL.ANY([]).[0],right=rel#122:Subset#12.PHYSICAL.ANY([]).[0],condition==($0, $2),joinType=inner), rowcount=25.0, cumulative cost={inf}
rel#132:Subset#13.NONE.ANY([]).[0], best=null, importance=0.4782969000000001
rel#136:AbstractConverter.NONE.ANY([]).[0](input=rel#83:Subset#13.LOGICAL.ANY([]).[],convention=NONE,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#137:AbstractConverter.NONE.ANY([]).[0](input=rel#109:Subset#13.PHYSICAL.ANY([]).[],convention=NONE,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#138:AbstractConverter.NONE.ANY([]).[0](input=rel#126:Subset#13.PHYSICAL.ANY([]).[0],convention=NONE,DrillDistributionTraitDef=ANY([]),sort=[0]), rowcount=25.0, cumulative cost={inf}
rel#131:LogicalSort.NONE.ANY([]).[0](input=rel#109:Subset#13.PHYSICAL.ANY([]).[],sort0=$0,dir0=ASC), rowcount=25.0, cumulative cost={inf}
Set#14, type: RecordType(ANY N_NAME, ANY R_NAME)
rel#85:Subset#14.LOGICAL.ANY([]).[], best=rel#84, importance=0.7290000000000001
rel#84:DrillProjectRel.LOGICAL.ANY([]).[](input=rel#83:Subset#13.LOGICAL.ANY([]).[],N_NAME=$1,R_NAME=$3), rowcount=25.0, cumulative cost={62.0 rows, 402.0 cpu, 0.0 io, 0.0 network, 88.0 memory}
rel#99:AbstractConverter.LOGICAL.ANY([]).[](input=rel#98:Subset#14.PHYSICAL.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#114:AbstractConverter.LOGICAL.ANY([]).[](input=rel#113:Subset#14.PHYSICAL.RANDOM_DISTRIBUTED([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#98:Subset#14.PHYSICAL.ANY([]).[], best=null, importance=0.6561
rel#100:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#85:Subset#14.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#115:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#113:Subset#14.PHYSICAL.RANDOM_DISTRIBUTED([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#116:AbstractConverter.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#85:Subset#14.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=RANDOM_DISTRIBUTED([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#117:AbstractConverter.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#98:Subset#14.PHYSICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=RANDOM_DISTRIBUTED([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#112:ProjectPrel.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#109:Subset#13.PHYSICAL.ANY([]).[],N_NAME=$1,R_NAME=$3), rowcount=25.0, cumulative cost={inf}
rel#142:ProjectPrel.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#126:Subset#13.PHYSICAL.ANY([]).[0],N_NAME=$1,R_NAME=$3), rowcount=25.0, cumulative cost={inf}
rel#113:Subset#14.PHYSICAL.RANDOM_DISTRIBUTED([]).[], best=null, importance=0.5904900000000001
rel#116:AbstractConverter.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#85:Subset#14.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=RANDOM_DISTRIBUTED([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#117:AbstractConverter.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#98:Subset#14.PHYSICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=RANDOM_DISTRIBUTED([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#112:ProjectPrel.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#109:Subset#13.PHYSICAL.ANY([]).[],N_NAME=$1,R_NAME=$3), rowcount=25.0, cumulative cost={inf}
rel#142:ProjectPrel.PHYSICAL.RANDOM_DISTRIBUTED([]).[](input=rel#126:Subset#13.PHYSICAL.ANY([]).[0],N_NAME=$1,R_NAME=$3), rowcount=25.0, cumulative cost={inf}
Set#15, type: RecordType(ANY N_NAME, ANY R_NAME)
rel#87:Subset#15.LOGICAL.ANY([]).[], best=rel#86, importance=0.81
rel#86:DrillLimitRel.LOGICAL.ANY([]).[](input=rel#85:Subset#14.LOGICAL.ANY([]).[],offset=0,fetch=0), rowcount=25.0, cumulative cost={63.0 rows, 403.0 cpu, 0.0 io, 0.0 network, 88.0 memory}
rel#94:AbstractConverter.LOGICAL.ANY([]).[](input=rel#93:Subset#15.PHYSICAL.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#103:AbstractConverter.LOGICAL.ANY([]).[](input=rel#102:Subset#15.PHYSICAL.SINGLETON([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#93:Subset#15.PHYSICAL.ANY([]).[], best=null, importance=0.7290000000000001
rel#95:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#87:Subset#15.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#104:AbstractConverter.PHYSICAL.ANY([]).[](input=rel#102:Subset#15.PHYSICAL.SINGLETON([]).[],convention=PHYSICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#105:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#87:Subset#15.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#106:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#93:Subset#15.PHYSICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#101:LimitPrel.PHYSICAL.SINGLETON([]).[](input=rel#98:Subset#14.PHYSICAL.ANY([]).[],offset=0,fetch=0), rowcount=25.0, cumulative cost={inf}
rel#107:UnionExchangePrel.PHYSICAL.SINGLETON([]).[](input=rel#93:Subset#15.PHYSICAL.ANY([]).[]), rowcount=25.0, cumulative cost={inf}
rel#102:Subset#15.PHYSICAL.SINGLETON([]).[], best=null, importance=0.6561
rel#105:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#87:Subset#15.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#106:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#93:Subset#15.PHYSICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#101:LimitPrel.PHYSICAL.SINGLETON([]).[](input=rel#98:Subset#14.PHYSICAL.ANY([]).[],offset=0,fetch=0), rowcount=25.0, cumulative cost={inf}
rel#107:UnionExchangePrel.PHYSICAL.SINGLETON([]).[](input=rel#93:Subset#15.PHYSICAL.ANY([]).[]), rowcount=25.0, cumulative cost={inf}
Set#16, type: RecordType(ANY N_NAME, ANY R_NAME)
rel#89:Subset#16.LOGICAL.ANY([]).[], best=rel#88, importance=0.9
rel#88:DrillScreenRel.LOGICAL.ANY([]).[](input=rel#87:Subset#15.LOGICAL.ANY([]).[]), rowcount=25.0, cumulative cost={65.5 rows, 405.5 cpu, 0.0 io, 0.0 network, 88.0 memory}
rel#91:AbstractConverter.LOGICAL.ANY([]).[](input=rel#90:Subset#16.PHYSICAL.SINGLETON([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#90:Subset#16.PHYSICAL.SINGLETON([]).[], best=null, importance=1.0
rel#92:AbstractConverter.PHYSICAL.SINGLETON([]).[](input=rel#89:Subset#16.LOGICAL.ANY([]).[],convention=PHYSICAL,DrillDistributionTraitDef=SINGLETON([]),sort=[]), rowcount=25.0, cumulative cost={inf}
rel#96:ScreenPrel.PHYSICAL.SINGLETON([]).[](input=rel#93:Subset#15.PHYSICAL.ANY([]).[]), rowcount=25.0, cumulative cost={inf}
{code}
> Update Limit 0 to avoid parallelization
> ---------------------------------------
>
> Key: DRILL-2897
> URL: https://issues.apache.org/jira/browse/DRILL-2897
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Jacques Nadeau
> Assignee: Jacques Nadeau
> Fix For: 1.0.0
>
> Attachments: DRILL-2897.patch
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)