[
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)
