Report Generated on 2019-09-11 Run Description: "bb5d3c255e12478e30405bccaa4fd202393471c1 vs 444c2660c84aed026b39c02307b9bb9902ff6035" Cluster Name: UNKNOWN Lab Run Info: UNKNOWN Impala Version: impalad version 3.4.0-SNAPSHOT RELEASE () Baseline Impala Version: impalad version 3.4.0-SNAPSHOT RELEASE (2019-09-11) +----------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +----------+-----------------------+---------+------------+------------+----------------+ | TPCH(30) | parquet / none / none | 5.56 | -11.15% | 4.15 | -5.88% | +----------+-----------------------+---------+------------+------------+----------------+ +----------+----------+-----------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+---------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Iters | Median Diff(%) | MW Zval | Tval | +----------+----------+-----------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+---------+ | TPCH(30) | TPCH-Q17 | parquet / none / none | 4.56 | 4.53 | +0.69% | 3.81% | 4.14% | 30 | +0.96% | 0.94 | 0.67 | | TPCH(30) | TPCH-Q20 | parquet / none / none | 2.62 | 2.60 | +0.92% | 1.99% | 1.34% | 30 | +0.68% | 1.73 | 2.09 | | TPCH(30) | TPCH-Q11 | parquet / none / none | 1.46 | 1.45 | +1.03% | 2.42% | 2.03% | 30 | +0.42% | 2.28 | 1.77 | | TPCH(30) | TPCH-Q6 | parquet / none / none | 1.24 | 1.23 | +0.33% | 3.00% | 3.51% | 30 | +0.03% | 0.19 | 0.39 | | TPCH(30) | TPCH-Q2 | parquet / none / none | 2.38 | 2.38 | +0.05% | 3.57% | 2.74% | 30 | +0.20% | 0.74 | 0.06 | | TPCH(30) | TPCH-Q22 | parquet / none / none | 2.04 | 2.04 | -0.10% | 2.22% | 2.42% | 30 | +0.01% | 0.10 | -0.17 | | TPCH(30) | TPCH-Q1 | parquet / none / none | 4.69 | 4.69 | -0.10% | 1.73% | 1.50% | 30 | -0.09% | -0.44 | -0.23 | | TPCH(30) | TPCH-Q16 | parquet / none / none | 2.14 | 2.15 | -0.23% | 2.04% | 2.51% | 30 | -0.05% | -0.12 | -0.39 | | TPCH(30) | TPCH-Q19 | parquet / none / none | 3.80 | 3.81 | -0.21% | 1.87% | 1.22% | 30 | -0.20% | -1.21 | -0.53 | | TPCH(30) | TPCH-Q15 | parquet / none / none | 3.73 | 3.75 | -0.56% | 1.49% | 1.09% | 30 | -0.54% | -1.55 | -1.67 | | TPCH(30) | TPCH-Q18 | parquet / none / none | 13.29 | 13.38 | -0.69% | 1.29% | 1.60% | 30 | -0.70% | -2.18 | -1.83 | | TPCH(30) | TPCH-Q3 | parquet / none / none | 5.49 | 5.56 | -1.25% | 1.04% | 0.95% | 30 | -1.05% | -3.90 | -4.87 | | TPCH(30) | TPCH-Q5 | parquet / none / none | 4.17 | 4.23 | -1.57% | 1.40% | 1.22% | 30 | -1.42% | -4.22 | -4.67 | | TPCH(30) | TPCH-Q14 | parquet / none / none | 2.83 | 2.88 | -1.70% | 3.19% | 1.99% | 30 | -1.93% | -3.09 | -2.50 | | TPCH(30) | TPCH-Q8 | parquet / none / none | 5.11 | 5.23 | -2.18% | 4.29% | 4.37% | 30 | -2.22% | -1.80 | -1.97 | | TPCH(30) | TPCH-Q12 | parquet / none / none | 2.56 | 2.69 | -4.84% | 1.92% | 2.02% | 30 | -5.33% | -6.12 | -9.74 | | TPCH(30) | TPCH-Q7 | parquet / none / none | 15.46 | 17.13 | I -9.77% | 0.58% | 0.64% | 30 | I -10.79% | -6.54 | -64.96 | | TPCH(30) | TPCH-Q10 | parquet / none / none | 4.28 | 4.81 | I -10.91% | 2.78% | 5.28% | 30 | I -10.77% | -6.24 | -10.25 | | TPCH(30) | TPCH-Q4 | parquet / none / none | 2.17 | 2.59 | I -16.24% | 2.85% | 1.44% | 30 | I -19.04% | -6.54 | -31.89 | | TPCH(30) | TPCH-Q9 | parquet / none / none | 14.12 | 16.93 | I -16.58% | 0.58% | 0.37% | 30 | I -19.91% | -6.54 | -148.97 | | TPCH(30) | TPCH-Q21 | parquet / none / none | 17.80 | 24.74 | I -28.07% | * 14.36% * | * 18.27% * | 30 | I -37.14% | -5.17 | -7.33 | | TPCH(30) | TPCH-Q13 | parquet / none / none | 6.47 | 8.98 | I -27.90% | 1.62% | 0.74% | 30 | I -38.74% | -6.54 | -110.24 | +----------+----------+-----------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+---------+ (I) Improvement: TPCH(30) TPCH-Q7 [parquet / none / none] (17.13s -> 15.46s [-9.77%]) Execution summary structures are different Execution Summary: +------------------------+--------+----------+----------+----------+---------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------+--------+----------+----------+----------+---------+-----------+ | F08:ROOT | 1 | 30.23us | 14.26us | 56.54us | -1 | -1 | | 21:MERGING-EXCHANGE | 1 | 24.89us | 3.09us | 31.79us | 4 | 1.64M | | F07:EXCHANGE SENDER | 3 | 37.52us | 3.88us | 74.33us | -1 | -1 | | 12:SORT | 3 | 86.96us | 14.96us | 206.58us | 4 | 1.64M | | 20:AGGREGATE | 3 | 754.04us | 122.19us | 2.11ms | 4 | 1.64M | | 19:EXCHANGE | 3 | 12.49us | 1.99us | 28.75us | 12 | 1.64M | | F03:EXCHANGE SENDER | 3 | 92.88us | 12.21us | 160.61us | -1 | -1 | | 11:AGGREGATE | 3 | 43.92ms | 12.51ms | 235.28ms | 12 | 1.64M | | 10:HASH JOIN | 3 | 1.56s | 19.19ms | 1.67s | 175.45K | 17.75M | | |--18:EXCHANGE | 3 | 9.98us | 8.45us | 147.78us | 25 | 25 | | | F06:EXCHANGE SENDER | 1 | 113.12us | 67.31us | 393.75us | -1 | -1 | | | 05:SCAN HDFS | 1 | 11.74ms | 8.11ms | 33.27ms | 25 | 25 | | 09:HASH JOIN | 3 | 899.36ms | 14.07ms | 960.79ms | 54.69M | 17.75M | | |--17:EXCHANGE | 3 | 46.23us | 206.60us | 3.40ms | 25 | 25 | | | F05:EXCHANGE SENDER | 1 | 128.19us | 86.35us | 518.98us | -1 | -1 | | | 04:SCAN HDFS | 1 | 15.52ms | 7.87ms | 36.48ms | 25 | 25 | | 08:HASH JOIN | 3 | 2.09s | 58.37ms | 2.35s | 54.69M | 17.75M | | |--16:EXCHANGE | 3 | 141.60ms | 27.07ms | 369.90ms | 4.50M | 4.50M | | | F04:EXCHANGE SENDER | 3 | 188.63ms | 44.57ms | 414.47ms | -1 | -1 | | | 03:SCAN HDFS | 3 | 739.49ms | 28.26ms | 899.43ms | 4.50M | 4.50M | | 07:HASH JOIN | 3 | 4.84s | 96.24ms | 5.15s | 54.69M | 17.75M | | |--15:EXCHANGE | 3 | 221.09ms | 8.97ms | 256.21ms | 45.00M | 45.00M | | | F02:EXCHANGE SENDER | 3 | 1.89s | 59.98ms | 2.58s | -1 | -1 | | | 02:SCAN HDFS | 3 | 1.05s | 55.30ms | 1.26s | 45.00M | 45.00M | | 14:EXCHANGE | 3 | 411.17ms | 6.06ms | 453.70ms | 54.69M | 17.75M | | F00:EXCHANGE SENDER | 3 | 5.36s | 48.35ms | 5.84s | -1 | -1 | | 22:PROJECT | 3 | 811.84ms | 17.84ms | 922.23ms | 54.69M | 17.75M | | 06:HASH JOIN | 3 | 3.53s | 27.52ms | 3.81s | 54.69M | 17.75M | | |--13:EXCHANGE | 3 | 6.37ms | 3.12ms | 49.88ms | 300.00K | 300.00K | | | F01:EXCHANGE SENDER | 1 | 25.38ms | 7.54ms | 48.40ms | -1 | -1 | | | 00:SCAN HDFS | 1 | 741.11ms | 41.46ms | 826.62ms | 300.00K | 300.00K | | 01:SCAN HDFS | 3 | 405.49ms | 36.61ms | 664.60ms | 54.69M | 18.00M | +------------------------+--------+----------+----------+----------+---------+-----------+ Reference Execution Summary: +------------------------+--------+----------+----------+----------+---------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------+--------+----------+----------+----------+---------+-----------+ | F08:ROOT | 1 | 30.32us | 14.77us | 56.06us | -1 | -1 | | 21:MERGING-EXCHANGE | 1 | 25.74us | 3.65us | 35.33us | 4 | 1.64M | | F07:EXCHANGE SENDER | 3 | 37.79us | 3.62us | 60.45us | -1 | -1 | | 12:SORT | 3 | 125.48us | 205.87us | 3.38ms | 4 | 1.64M | | 20:AGGREGATE | 3 | 751.97us | 80.67us | 1.05ms | 4 | 1.64M | | 19:EXCHANGE | 3 | 11.67us | 1.47us | 24.05us | 12 | 1.64M | | F03:EXCHANGE SENDER | 3 | 101.33us | 15.03us | 177.46us | -1 | -1 | | 11:AGGREGATE | 3 | 44.60ms | 4.88ms | 79.68ms | 12 | 1.64M | | 10:HASH JOIN | 3 | 1.50s | 14.22ms | 1.54s | 175.45K | 17.75M | | |--18:EXCHANGE | 3 | 17.93us | 30.70us | 439.36us | 25 | 25 | | | F06:EXCHANGE SENDER | 1 | 114.56us | 75.24us | 409.51us | -1 | -1 | | | 05:SCAN HDFS | 1 | 14.81ms | 9.87ms | 51.35ms | 25 | 25 | | 09:HASH JOIN | 3 | 898.67ms | 10.59ms | 963.63ms | 54.69M | 17.75M | | |--17:EXCHANGE | 3 | 7.97us | 3.21us | 59.61us | 25 | 25 | | | F05:EXCHANGE SENDER | 1 | 123.05us | 73.65us | 409.30us | -1 | -1 | | | 04:SCAN HDFS | 1 | 13.86ms | 8.01ms | 34.69ms | 25 | 25 | | 08:HASH JOIN | 3 | 2.09s | 51.47ms | 2.36s | 54.69M | 17.75M | | |--16:EXCHANGE | 3 | 141.23ms | 26.37ms | 400.66ms | 4.50M | 4.50M | | | F04:EXCHANGE SENDER | 3 | 218.86ms | 36.92ms | 438.55ms | -1 | -1 | | | 03:SCAN HDFS | 3 | 725.66ms | 24.33ms | 818.00ms | 4.50M | 4.50M | | 07:HASH JOIN | 3 | 4.77s | 67.56ms | 5.07s | 54.69M | 17.75M | | |--15:EXCHANGE | 3 | 223.46ms | 9.22ms | 277.32ms | 45.00M | 45.00M | | | F02:EXCHANGE SENDER | 3 | 1.87s | 44.95ms | 2.57s | -1 | -1 | | | 02:SCAN HDFS | 3 | 1.06s | 45.41ms | 1.22s | 45.00M | 45.00M | | 14:EXCHANGE | 3 | 521.87ms | 6.24ms | 548.47ms | 54.69M | 17.75M | | F00:EXCHANGE SENDER | 3 | 7.62s | 78.65ms | 8.24s | -1 | -1 | | 06:HASH JOIN | 3 | 3.35s | 38.41ms | 3.63s | 54.69M | 17.75M | | |--13:EXCHANGE | 3 | 5.69ms | 1.17ms | 11.34ms | 300.00K | 300.00K | | | F01:EXCHANGE SENDER | 1 | 23.91ms | 5.70ms | 42.91ms | -1 | -1 | | | 00:SCAN HDFS | 1 | 716.84ms | 31.50ms | 786.94ms | 300.00K | 300.00K | | 01:SCAN HDFS | 3 | 418.80ms | 30.04ms | 567.40ms | 54.69M | 18.00M | +------------------------+--------+----------+----------+----------+---------+-----------+ (I) Improvement: TPCH(30) TPCH-Q10 [parquet / none / none] (4.81s -> 4.28s [-10.91%]) Execution summary structures are different Execution Summary: +---------------------------+--------+----------+----------+----------+-------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +---------------------------+--------+----------+----------+----------+-------+-----------+ | F06:ROOT | 1 | 64.45us | 23.29us | 122.94us | -1 | -1 | | 15:MERGING-EXCHANGE | 1 | 30.52us | 5.13us | 47.41us | 20 | 20 | | F05:EXCHANGE SENDER | 3 | 67.04us | 5.33us | 91.45us | -1 | -1 | | 08:TOP-N | 3 | 28.43ms | 4.71ms | 41.88ms | 60 | 20 | | 14:AGGREGATE | 3 | 179.52ms | 9.56ms | 249.83ms | 1.15M | 6.09M | | 13:EXCHANGE | 3 | 8.84ms | 527.86us | 12.37ms | 1.15M | 6.09M | | F03:EXCHANGE SENDER | 3 | 383.26ms | 6.27ms | 422.09ms | -1 | -1 | | 07:AGGREGATE | 3 | 447.43ms | 20.61ms | 539.81ms | 1.15M | 6.09M | | 06:HASH JOIN | 3 | 59.20ms | 9.42ms | 138.38ms | 3.43M | 6.09M | | |--12:EXCHANGE | 3 | 11.31us | 2.73us | 32.39us | 25 | 25 | | | F04:EXCHANGE SENDER | 1 | 135.68us | 95.52us | 452.17us | -1 | -1 | | | 03:SCAN HDFS | 1 | 18.76ms | 9.60ms | 48.70ms | 25 | 25 | | 05:HASH JOIN | 3 | 327.32ms | 16.97ms | 409.68ms | 3.43M | 6.09M | | |--11:EXCHANGE | 3 | 15.17ms | 1.15ms | 28.27ms | 3.43M | 6.00M | | | F01:EXCHANGE SENDER | 3 | 141.23ms | 2.73ms | 176.58ms | -1 | -1 | | | 17:PROJECT | 3 | 19.75ms | 1.43ms | 27.25ms | 3.43M | 6.00M | | | 04:HASH JOIN | 3 | 441.19ms | 29.09ms | 577.47ms | 3.43M | 6.00M | | | |--09:EXCHANGE | 3 | 26.11ms | 6.26ms | 75.30ms | 1.72M | 4.50M | | | | F02:EXCHANGE SENDER | 3 | 63.67ms | 19.47ms | 212.75ms | -1 | -1 | | | | 16:PROJECT | 3 | 6.46ms | 1.88ms | 29.36ms | 1.72M | 4.50M | | | | 01:SCAN HDFS | 3 | 367.10ms | 44.58ms | 621.85ms | 1.72M | 4.50M | | | 02:SCAN HDFS | 3 | 1.47s | 63.49ms | 1.84s | 4.02M | 60.00M | | 10:EXCHANGE | 3 | 10.86ms | 1.72ms | 25.94ms | 1.37M | 4.50M | | F00:EXCHANGE SENDER | 3 | 624.11ms | 46.33ms | 797.20ms | -1 | -1 | | 00:SCAN HDFS | 3 | 944.64ms | 56.07ms | 1.16s | 1.37M | 4.50M | +---------------------------+--------+----------+----------+----------+-------+-----------+ Reference Execution Summary: +---------------------------+--------+----------+----------+----------+-------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +---------------------------+--------+----------+----------+----------+-------+-----------+ | F06:ROOT | 1 | 64.08us | 23.86us | 138.03us | -1 | -1 | | 15:MERGING-EXCHANGE | 1 | 32.99us | 5.42us | 46.57us | 20 | 20 | | F05:EXCHANGE SENDER | 3 | 66.39us | 4.47us | 91.18us | -1 | -1 | | 08:TOP-N | 3 | 28.31ms | 5.16ms | 42.87ms | 60 | 20 | | 14:AGGREGATE | 3 | 173.60ms | 7.22ms | 235.46ms | 1.15M | 6.00M | | 13:EXCHANGE | 3 | 8.63ms | 595.79us | 11.92ms | 1.15M | 6.00M | | F03:EXCHANGE SENDER | 3 | 380.44ms | 7.03ms | 426.70ms | -1 | -1 | | 07:AGGREGATE | 3 | 516.77ms | 98.14ms | 1.57s | 1.15M | 6.00M | | 06:HASH JOIN | 3 | 54.52ms | 4.99ms | 91.61ms | 3.43M | 6.00M | | |--12:EXCHANGE | 3 | 10.99us | 2.01us | 22.67us | 25 | 25 | | | F04:EXCHANGE SENDER | 1 | 119.41us | 66.63us | 408.18us | -1 | -1 | | | 03:SCAN HDFS | 1 | 17.70ms | 9.74ms | 40.78ms | 25 | 25 | | 05:HASH JOIN | 3 | 435.38ms | 19.73ms | 691.45ms | 3.43M | 6.00M | | |--11:EXCHANGE | 3 | 23.73ms | 598.22us | 28.31ms | 3.43M | 6.00M | | | F01:EXCHANGE SENDER | 3 | 625.08ms | 111.82ms | 1.14s | -1 | -1 | | | 04:HASH JOIN | 3 | 602.69ms | 47.38ms | 840.68ms | 3.43M | 6.00M | | | |--09:EXCHANGE | 3 | 33.94ms | 9.50ms | 147.67ms | 1.72M | 4.50M | | | | F02:EXCHANGE SENDER | 3 | 124.74ms | 28.82ms | 355.35ms | -1 | -1 | | | | 01:SCAN HDFS | 3 | 292.44ms | 54.84ms | 533.71ms | 1.72M | 4.50M | | | 02:SCAN HDFS | 3 | 1.01s | 135.21ms | 1.57s | 4.02M | 60.00M | | 10:EXCHANGE | 3 | 12.87ms | 2.74ms | 37.09ms | 1.37M | 4.50M | | F00:EXCHANGE SENDER | 3 | 645.10ms | 29.42ms | 810.86ms | -1 | -1 | | 00:SCAN HDFS | 3 | 903.63ms | 54.32ms | 1.16s | 1.37M | 4.50M | +---------------------------+--------+----------+----------+----------+-------+-----------+ (I) Improvement: TPCH(30) TPCH-Q4 [parquet / none / none] (2.59s -> 2.17s [-16.24%]) Execution summary structures are different Execution Summary: +------------------------+--------+----------+----------+----------+-------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------+--------+----------+----------+----------+-------+-----------+ | F04:ROOT | 1 | 23.26us | 13.49us | 48.49us | -1 | -1 | | 09:MERGING-EXCHANGE | 1 | 23.11us | 5.16us | 40.63us | 5 | 5 | | F03:EXCHANGE SENDER | 3 | 89.51us | 209.57us | 2.72ms | -1 | -1 | | 04:SORT | 3 | 74.92us | 21.97us | 364.61us | 5 | 5 | | 08:AGGREGATE | 3 | 545.98us | 44.47us | 741.03us | 5 | 5 | | 07:EXCHANGE | 3 | 10.08us | 1.26us | 26.94us | 15 | 5 | | F02:EXCHANGE SENDER | 3 | 141.65us | 276.50us | 2.88ms | -1 | -1 | | 03:AGGREGATE | 3 | 38.65ms | 8.99ms | 60.39ms | 15 | 5 | | 02:HASH JOIN | 3 | 148.22ms | 17.67ms | 270.74ms | 1.58M | 4.50M | | |--06:EXCHANGE | 3 | 6.24ms | 782.94us | 14.92ms | 1.72M | 4.50M | | | F01:EXCHANGE SENDER | 3 | 129.89ms | 18.68ms | 291.14ms | -1 | -1 | | | 10:PROJECT | 3 | 12.51ms | 1.84ms | 33.04ms | 1.72M | 4.50M | | | 00:SCAN HDFS | 3 | 116.10ms | 23.50ms | 218.26ms | 1.72M | 4.50M | | 05:EXCHANGE | 3 | 23.13ms | 1.52ms | 44.76ms | 5.94M | 18.00M | | F00:EXCHANGE SENDER | 3 | 166.07ms | 9.78ms | 299.06ms | -1 | -1 | | 11:PROJECT | 3 | 17.67ms | 1.96ms | 35.52ms | 5.94M | 18.00M | | 01:SCAN HDFS | 3 | 1.73s | 66.56ms | 1.89s | 5.94M | 18.00M | +------------------------+--------+----------+----------+----------+-------+-----------+ Reference Execution Summary: +------------------------+--------+----------+---------+----------+-------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------+--------+----------+---------+----------+-------+-----------+ | F04:ROOT | 1 | 27.55us | 14.64us | 48.25us | -1 | -1 | | 09:MERGING-EXCHANGE | 1 | 21.94us | 3.45us | 31.15us | 5 | 5 | | F03:EXCHANGE SENDER | 3 | 31.16us | 4.66us | 51.19us | -1 | -1 | | 04:SORT | 3 | 71.26us | 9.15us | 131.29us | 5 | 5 | | 08:AGGREGATE | 3 | 517.84us | 43.56us | 912.81us | 5 | 5 | | 07:EXCHANGE | 3 | 9.46us | 1.07us | 23.70us | 15 | 5 | | F02:EXCHANGE SENDER | 3 | 80.56us | 15.18us | 221.39us | -1 | -1 | | 03:AGGREGATE | 3 | 45.15ms | 10.02ms | 67.65ms | 15 | 5 | | 02:HASH JOIN | 3 | 194.31ms | 27.15ms | 321.91ms | 1.58M | 4.50M | | |--06:EXCHANGE | 3 | 8.15ms | 1.25ms | 15.26ms | 1.72M | 4.50M | | | F01:EXCHANGE SENDER | 3 | 197.79ms | 13.39ms | 334.23ms | -1 | -1 | | | 00:SCAN HDFS | 3 | 73.31ms | 16.10ms | 130.88ms | 1.72M | 4.50M | | 05:EXCHANGE | 3 | 31.68ms | 1.38ms | 46.42ms | 5.94M | 18.00M | | F00:EXCHANGE SENDER | 3 | 973.88ms | 63.21ms | 1.26s | -1 | -1 | | 01:SCAN HDFS | 3 | 1.03s | 62.25ms | 1.56s | 5.94M | 18.00M | +------------------------+--------+----------+---------+----------+-------+-----------+ (I) Improvement: TPCH(30) TPCH-Q9 [parquet / none / none] (16.93s -> 14.12s [-16.58%]) Execution summary structures are different Execution Summary: +------------------------+--------+----------+----------+----------+---------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------+--------+----------+----------+----------+---------+-----------+ | F09:ROOT | 1 | 199.72us | 76.09us | 489.98us | -1 | -1 | | 22:MERGING-EXCHANGE | 1 | 39.82us | 5.27us | 55.11us | 175 | 61.70K | | F08:EXCHANGE SENDER | 3 | 49.06us | 4.83us | 72.67us | -1 | -1 | | 12:SORT | 3 | 120.36us | 12.60us | 179.74us | 175 | 61.70K | | 21:AGGREGATE | 3 | 835.40us | 97.59us | 1.99ms | 175 | 61.70K | | 20:EXCHANGE | 3 | 18.02us | 12.27us | 203.43us | 525 | 61.70K | | F06:EXCHANGE SENDER | 3 | 138.60us | 28.26us | 555.05us | -1 | -1 | | 11:AGGREGATE | 3 | 1.23s | 85.97ms | 1.71s | 525 | 61.70K | | 10:HASH JOIN | 3 | 189.05ms | 14.90ms | 307.65ms | 9.79M | 17.75M | | |--19:EXCHANGE | 3 | 33.74us | 105.06us | 1.72ms | 25 | 25 | | | F07:EXCHANGE SENDER | 1 | 160.09us | 119.15us | 610.94us | -1 | -1 | | | 05:SCAN HDFS | 1 | 20.45ms | 11.23ms | 54.58ms | 25 | 25 | | 09:HASH JOIN | 3 | 3.13s | 128.60ms | 3.70s | 9.79M | 17.75M | | |--18:EXCHANGE | 3 | 263.75ms | 16.30ms | 354.82ms | 45.00M | 45.00M | | | F05:EXCHANGE SENDER | 3 | 3.87s | 90.38ms | 5.23s | -1 | -1 | | | 04:SCAN HDFS | 3 | 220.19ms | 45.75ms | 514.27ms | 45.00M | 45.00M | | 17:EXCHANGE | 3 | 90.49ms | 9.73ms | 155.37ms | 9.79M | 17.75M | | F04:EXCHANGE SENDER | 3 | 2.12s | 153.84ms | 2.81s | -1 | -1 | | 25:PROJECT | 3 | 239.45ms | 22.85ms | 354.45ms | 9.79M | 17.75M | | 08:HASH JOIN | 3 | 3.74s | 133.55ms | 4.37s | 9.79M | 17.75M | | |--16:EXCHANGE | 3 | 251.94ms | 26.51ms | 464.73ms | 24.00M | 24.00M | | | F03:EXCHANGE SENDER | 3 | 2.44s | 116.68ms | 2.83s | -1 | -1 | | | 03:SCAN HDFS | 3 | 218.11ms | 44.62ms | 548.73ms | 24.00M | 24.00M | | 15:EXCHANGE | 3 | 116.72ms | 16.35ms | 270.99ms | 9.79M | 17.75M | | F00:EXCHANGE SENDER | 3 | 2.42s | 182.43ms | 3.30s | -1 | -1 | | 24:PROJECT | 3 | 220.75ms | 24.40ms | 322.63ms | 9.79M | 17.75M | | 07:HASH JOIN | 3 | 910.71ms | 51.15ms | 1.19s | 9.79M | 17.75M | | |--14:EXCHANGE | 3 | 7.48ms | 1.97ms | 22.95ms | 300.00K | 300.00K | | | F02:EXCHANGE SENDER | 1 | 25.03ms | 8.25ms | 58.26ms | -1 | -1 | | | 01:SCAN HDFS | 1 | 801.88ms | 62.05ms | 930.41ms | 300.00K | 300.00K | | 06:HASH JOIN | 3 | 1.23s | 53.79ms | 1.53s | 9.79M | 18.00M | | |--13:EXCHANGE | 3 | 4.76ms | 628.66us | 10.04ms | 326.31K | 600.00K | | | F01:EXCHANGE SENDER | 3 | 6.68ms | 178.91us | 8.43ms | -1 | -1 | | | 23:PROJECT | 3 | 4.45ms | 955.28us | 17.28ms | 326.31K | 600.00K | | | 00:SCAN HDFS | 3 | 1.40s | 66.35ms | 1.64s | 326.31K | 600.00K | | 02:SCAN HDFS | 3 | 2.22s | 324.98ms | 4.82s | 9.82M | 180.00M | +------------------------+--------+----------+----------+----------+---------+-----------+ Reference Execution Summary: +------------------------+--------+----------+----------+----------+---------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------+--------+----------+----------+----------+---------+-----------+ | F09:ROOT | 1 | 186.57us | 64.52us | 457.65us | -1 | -1 | | 22:MERGING-EXCHANGE | 1 | 42.94us | 5.71us | 55.96us | 175 | 61.70K | | F08:EXCHANGE SENDER | 3 | 51.00us | 11.98us | 177.63us | -1 | -1 | | 12:SORT | 3 | 115.42us | 6.49us | 143.77us | 175 | 61.70K | | 21:AGGREGATE | 3 | 795.51us | 86.89us | 1.59ms | 175 | 61.70K | | 20:EXCHANGE | 3 | 18.76us | 9.28us | 109.80us | 525 | 61.70K | | F06:EXCHANGE SENDER | 3 | 138.93us | 19.83us | 445.24us | -1 | -1 | | 11:AGGREGATE | 3 | 1.11s | 24.90ms | 1.26s | 525 | 61.70K | | 10:HASH JOIN | 3 | 211.22ms | 7.65ms | 256.12ms | 9.79M | 17.75M | | |--19:EXCHANGE | 3 | 16.27us | 24.84us | 373.92us | 25 | 25 | | | F07:EXCHANGE SENDER | 1 | 158.45us | 235.91us | 1.32ms | -1 | -1 | | | 05:SCAN HDFS | 1 | 20.76ms | 20.34ms | 103.91ms | 25 | 25 | | 09:HASH JOIN | 3 | 3.09s | 93.81ms | 3.37s | 9.79M | 17.75M | | |--18:EXCHANGE | 3 | 266.00ms | 13.89ms | 339.06ms | 45.00M | 45.00M | | | F05:EXCHANGE SENDER | 3 | 3.59s | 101.92ms | 4.83s | -1 | -1 | | | 04:SCAN HDFS | 3 | 202.91ms | 34.10ms | 386.13ms | 45.00M | 45.00M | | 17:EXCHANGE | 3 | 136.19ms | 5.86ms | 170.55ms | 9.79M | 17.75M | | F04:EXCHANGE SENDER | 3 | 5.98s | 61.33ms | 6.37s | -1 | -1 | | 08:HASH JOIN | 3 | 3.68s | 100.33ms | 4.08s | 9.79M | 17.75M | | |--16:EXCHANGE | 3 | 232.33ms | 16.88ms | 346.89ms | 24.00M | 24.00M | | | F03:EXCHANGE SENDER | 3 | 2.36s | 92.99ms | 2.74s | -1 | -1 | | | 03:SCAN HDFS | 3 | 209.72ms | 35.97ms | 496.10ms | 24.00M | 24.00M | | 15:EXCHANGE | 3 | 148.05ms | 8.07ms | 177.65ms | 9.79M | 17.75M | | F00:EXCHANGE SENDER | 3 | 5.21s | 99.05ms | 5.87s | -1 | -1 | | 07:HASH JOIN | 3 | 945.67ms | 21.19ms | 1.10s | 9.79M | 17.75M | | |--14:EXCHANGE | 3 | 7.25ms | 2.04ms | 18.01ms | 300.00K | 300.00K | | | F02:EXCHANGE SENDER | 1 | 36.42ms | 18.28ms | 87.65ms | -1 | -1 | | | 01:SCAN HDFS | 1 | 806.17ms | 48.42ms | 899.95ms | 300.00K | 300.00K | | 06:HASH JOIN | 3 | 1.29s | 44.61ms | 1.47s | 9.79M | 18.00M | | |--13:EXCHANGE | 3 | 5.03ms | 1.32ms | 18.09ms | 326.31K | 600.00K | | | F01:EXCHANGE SENDER | 3 | 26.72ms | 660.10us | 31.66ms | -1 | -1 | | | 00:SCAN HDFS | 3 | 1.39s | 92.89ms | 1.73s | 326.31K | 600.00K | | 02:SCAN HDFS | 3 | 861.00ms | 84.33ms | 1.23s | 9.82M | 180.00M | +------------------------+--------+----------+----------+----------+---------+-----------+ (I) Improvement: TPCH(30) TPCH-Q21 [parquet / none / none] (24.74s -> 17.80s [-28.07%]) Execution summary structures are different Execution Summary: +------------------------------+--------+----------+----------+----------+---------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------------+--------+----------+----------+----------+---------+-----------+ | F08:ROOT | 1 | 57.52us | 26.02us | 120.08us | -1 | -1 | | 21:MERGING-EXCHANGE | 1 | 41.24us | 3.97us | 52.82us | 100 | 100 | | F07:EXCHANGE SENDER | 3 | 43.47us | 3.39us | 57.58us | -1 | -1 | | 12:TOP-N | 3 | 220.78us | 19.34us | 338.23us | 300 | 100 | | 20:AGGREGATE | 3 | 1.71ms | 81.17us | 2.02ms | 11.96K | 236.69K | | 19:EXCHANGE | 3 | 127.03us | 8.20us | 165.06us | 34.60K | 236.69K | | F04:EXCHANGE SENDER | 3 | 1.86ms | 200.56us | 3.94ms | -1 | -1 | | 11:AGGREGATE | 3 | 13.91ms | 1.66ms | 25.19ms | 34.60K | 236.69K | | 10:HASH JOIN | 3 | 2.49s | 56.37ms | 2.69s | 118.66K | 236.69K | | |--09:HASH JOIN | 3 | 1.60s | 112.39ms | 1.88s | 2.11M | 236.69K | | | |--08:HASH JOIN | 3 | 450.59ms | 275.34ms | 850.80ms | 2.19M | 236.69K | | | | |--16:EXCHANGE | 3 | 10.32us | 4.93us | 69.01us | 1 | 1 | | | | | F06:EXCHANGE SENDER | 1 | 253.76us | 340.79us | 1.33ms | -1 | -1 | | | | | 22:PROJECT | 1 | 26.21us | 31.75us | 127.15us | 1 | 1 | | | | | 03:SCAN HDFS | 1 | 21.96ms | 17.74ms | 92.73ms | 1 | 1 | | | | 07:HASH JOIN | 3 | 2.13s | 1.44s | 4.18s | 11.19M | 5.92M | | | | |--15:EXCHANGE | 3 | 1.54ms | 847.05us | 4.83ms | 61.09K | 300.00K | | | | | F05:EXCHANGE SENDER | 1 | 30.73ms | 28.21ms | 130.29ms | -1 | -1 | | | | | 00:SCAN HDFS | 1 | 915.97ms | 43.59ms | 1.00s | 61.09K | 300.00K | | | | 06:HASH JOIN | 3 | 3.34s | 1.03s | 4.68s | 11.39M | 6.00M | | | | |--14:EXCHANGE | 3 | 94.95ms | 24.28ms | 252.55ms | 21.92M | 15.00M | | | | | F03:EXCHANGE SENDER | 3 | 709.15ms | 67.75ms | 1.24s | -1 | -1 | | | | | 23:PROJECT | 3 | 63.26ms | 5.63ms | 137.98ms | 21.92M | 15.00M | | | | | 02:SCAN HDFS | 3 | 145.58ms | 41.55ms | 606.35ms | 21.92M | 15.00M | | | | 13:EXCHANGE | 3 | 327.69ms | 214.53ms | 871.60ms | 18.44M | 18.00M | | | | F02:EXCHANGE SENDER | 3 | 2.85s | 2.22s | 6.67s | -1 | -1 | | | | 24:PROJECT | 3 | 421.09ms | 284.24ms | 899.14ms | 18.44M | 18.00M | | | | 01:SCAN HDFS | 3 | 3.18s | 1.05s | 4.87s | 18.44M | 18.00M | | | 17:EXCHANGE | 3 | 386.38ms | 17.94ms | 462.73ms | 65.77M | 180.00M | | | F01:EXCHANGE SENDER | 3 | 3.00s | 36.03ms | 3.32s | -1 | -1 | | | 04:SCAN HDFS | 3 | 998.63ms | 37.80ms | 1.14s | 65.77M | 180.00M | | 18:EXCHANGE | 3 | 679.15ms | 11.61ms | 742.73ms | 113.80M | 18.00M | | F00:EXCHANGE SENDER | 3 | 4.24s | 25.03ms | 4.61s | -1 | -1 | | 25:PROJECT | 3 | 460.21ms | 4.28ms | 519.00ms | 113.80M | 18.00M | | 05:SCAN HDFS | 3 | 257.84ms | 20.45ms | 348.03ms | 113.80M | 18.00M | +------------------------------+--------+----------+----------+----------+---------+-----------+ Reference Execution Summary: +------------------------------+--------+----------+----------+----------+---------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------------+--------+----------+----------+----------+---------+-----------+ | F08:ROOT | 1 | 59.26us | 9.79us | 91.42us | -1 | -1 | | 21:MERGING-EXCHANGE | 1 | 42.27us | 4.32us | 57.09us | 100 | 100 | | F07:EXCHANGE SENDER | 3 | 44.16us | 7.16us | 145.64us | -1 | -1 | | 12:TOP-N | 3 | 315.31us | 504.90us | 8.47ms | 300 | 100 | | 20:AGGREGATE | 3 | 1.76ms | 104.11us | 2.13ms | 11.96K | 236.69K | | 19:EXCHANGE | 3 | 133.46us | 9.55us | 186.82us | 34.60K | 236.69K | | F04:EXCHANGE SENDER | 3 | 1.89ms | 145.71us | 3.02ms | -1 | -1 | | 11:AGGREGATE | 3 | 25.99ms | 2.41ms | 38.23ms | 34.60K | 236.69K | | 10:HASH JOIN | 3 | 2.47s | 53.06ms | 2.64s | 118.66K | 236.69K | | |--09:HASH JOIN | 3 | 1.76s | 171.77ms | 2.09s | 2.11M | 236.69K | | | |--08:HASH JOIN | 3 | 343.51ms | 320.57ms | 1.01s | 2.19M | 236.69K | | | | |--16:EXCHANGE | 3 | 9.40us | 2.43us | 28.74us | 1 | 1 | | | | | F06:EXCHANGE SENDER | 1 | 159.68us | 135.03us | 735.95us | -1 | -1 | | | | | 03:SCAN HDFS | 1 | 22.30ms | 15.77ms | 76.32ms | 1 | 1 | | | | 07:HASH JOIN | 3 | 1.49s | 1.50s | 4.27s | 15.34M | 5.92M | | | | |--15:EXCHANGE | 3 | 1.45ms | 1.72ms | 19.53ms | 83.71K | 300.00K | | | | | F05:EXCHANGE SENDER | 1 | 28.07ms | 33.34ms | 121.65ms | -1 | -1 | | | | | 00:SCAN HDFS | 1 | 885.25ms | 53.26ms | 978.90ms | 83.71K | 300.00K | | | | 06:HASH JOIN | 3 | 3.19s | 1.34s | 5.42s | 15.45M | 6.00M | | | | |--14:EXCHANGE | 3 | 109.00ms | 20.17ms | 360.17ms | 21.92M | 15.00M | | | | | F03:EXCHANGE SENDER | 3 | 1.10s | 73.63ms | 1.67s | -1 | -1 | | | | | 02:SCAN HDFS | 3 | 111.41ms | 24.22ms | 226.08ms | 21.92M | 15.00M | | | | 13:EXCHANGE | 3 | 257.60ms | 251.11ms | 727.39ms | 24.71M | 18.00M | | | | F02:EXCHANGE SENDER | 3 | 4.92s | 4.46s | 12.85s | -1 | -1 | | | | 01:SCAN HDFS | 3 | 1.93s | 807.43ms | 3.56s | 24.71M | 18.00M | | | 17:EXCHANGE | 3 | 394.68ms | 9.82ms | 454.02ms | 65.77M | 180.00M | | | F01:EXCHANGE SENDER | 3 | 3.06s | 44.12ms | 3.35s | -1 | -1 | | | 04:SCAN HDFS | 3 | 1.01s | 31.28ms | 1.13s | 65.77M | 180.00M | | 18:EXCHANGE | 3 | 738.93ms | 5.71ms | 767.08ms | 113.80M | 18.00M | | F00:EXCHANGE SENDER | 3 | 9.96s | 66.49ms | 10.75s | -1 | -1 | | 05:SCAN HDFS | 3 | 243.46ms | 20.63ms | 319.43ms | 113.80M | 18.00M | +------------------------------+--------+----------+----------+----------+---------+-----------+ (I) Improvement: TPCH(30) TPCH-Q13 [parquet / none / none] (8.98s -> 6.47s [-27.90%]) Execution summary structures are different Execution Summary: +------------------------+--------+----------+----------+----------+--------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------+--------+----------+----------+----------+--------+-----------+ | F04:ROOT | 1 | 46.25us | 20.18us | 101.08us | -1 | -1 | | 10:MERGING-EXCHANGE | 1 | 22.81us | 1.72us | 26.46us | 45 | 4.43M | | F03:EXCHANGE SENDER | 3 | 36.93us | 7.46us | 72.39us | -1 | -1 | | 05:SORT | 3 | 90.65us | 47.05us | 771.32us | 45 | 4.43M | | 09:AGGREGATE | 3 | 600.45us | 62.52us | 898.29us | 45 | 4.43M | | 08:EXCHANGE | 3 | 14.96us | 2.66us | 34.53us | 132 | 4.43M | | F02:EXCHANGE SENDER | 3 | 95.15us | 11.71us | 150.42us | -1 | -1 | | 04:AGGREGATE | 3 | 23.76ms | 3.11ms | 37.47ms | 132 | 4.43M | | 03:AGGREGATE | 3 | 2.13s | 56.67ms | 2.34s | 4.50M | 4.43M | | 02:HASH JOIN | 3 | 3.26s | 74.89ms | 3.48s | 46.01M | 4.50M | | |--07:EXCHANGE | 3 | 12.77ms | 710.34us | 19.72ms | 4.50M | 4.50M | | | F01:EXCHANGE SENDER | 3 | 122.64ms | 10.55ms | 166.91ms | -1 | -1 | | | 00:SCAN HDFS | 3 | 23.25ms | 8.03ms | 78.19ms | 4.50M | 4.50M | | 06:EXCHANGE | 3 | 319.72ms | 19.29ms | 582.45ms | 44.51M | 4.50M | | F00:EXCHANGE SENDER | 3 | 1.98s | 89.53ms | 3.13s | -1 | -1 | | 11:PROJECT | 3 | 150.17ms | 6.74ms | 232.01ms | 44.51M | 4.50M | | 01:SCAN HDFS | 3 | 1.28s | 181.34ms | 2.25s | 44.51M | 4.50M | +------------------------+--------+----------+----------+----------+--------+-----------+ Reference Execution Summary: +------------------------+--------+----------+----------+----------+--------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------+--------+----------+----------+----------+--------+-----------+ | F04:ROOT | 1 | 44.54us | 17.69us | 85.66us | -1 | -1 | | 10:MERGING-EXCHANGE | 1 | 23.68us | 2.71us | 34.34us | 45 | 4.43M | | F03:EXCHANGE SENDER | 3 | 37.56us | 6.78us | 73.42us | -1 | -1 | | 05:SORT | 3 | 76.23us | 9.57us | 138.58us | 45 | 4.43M | | 09:AGGREGATE | 3 | 606.44us | 52.63us | 1.06ms | 45 | 4.43M | | 08:EXCHANGE | 3 | 15.32us | 6.54us | 112.88us | 132 | 4.43M | | F02:EXCHANGE SENDER | 3 | 101.14us | 38.01us | 621.45us | -1 | -1 | | 04:AGGREGATE | 3 | 24.15ms | 2.76ms | 38.07ms | 132 | 4.43M | | 03:AGGREGATE | 3 | 2.62s | 29.83ms | 2.74s | 4.50M | 4.43M | | 02:HASH JOIN | 3 | 3.95s | 51.69ms | 4.11s | 46.01M | 4.57M | | |--07:EXCHANGE | 3 | 13.09ms | 749.46us | 17.36ms | 4.50M | 4.50M | | | F01:EXCHANGE SENDER | 3 | 126.54ms | 11.04ms | 185.71ms | -1 | -1 | | | 00:SCAN HDFS | 3 | 20.74ms | 5.14ms | 48.94ms | 4.50M | 4.50M | | 06:EXCHANGE | 3 | 267.01ms | 4.01ms | 302.78ms | 44.51M | 4.50M | | F00:EXCHANGE SENDER | 3 | 5.33s | 49.29ms | 7.54s | -1 | -1 | | 01:SCAN HDFS | 3 | 1.01s | 30.02ms | 1.22s | 44.51M | 4.50M | +------------------------+--------+----------+----------+----------+--------+-----------+ (V) Significant Variability: TPCH(30) TPCH-Q21 [parquet / none / none] (18.27% -> 14.36%) Execution summary structures are different Execution Summary: +------------------------------+--------+----------+----------+----------+---------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------------+--------+----------+----------+----------+---------+-----------+ | F08:ROOT | 1 | 57.52us | 26.02us | 120.08us | -1 | -1 | | 21:MERGING-EXCHANGE | 1 | 41.24us | 3.97us | 52.82us | 100 | 100 | | F07:EXCHANGE SENDER | 3 | 43.47us | 3.39us | 57.58us | -1 | -1 | | 12:TOP-N | 3 | 220.78us | 19.34us | 338.23us | 300 | 100 | | 20:AGGREGATE | 3 | 1.71ms | 81.17us | 2.02ms | 11.96K | 236.69K | | 19:EXCHANGE | 3 | 127.03us | 8.20us | 165.06us | 34.60K | 236.69K | | F04:EXCHANGE SENDER | 3 | 1.86ms | 200.56us | 3.94ms | -1 | -1 | | 11:AGGREGATE | 3 | 13.91ms | 1.66ms | 25.19ms | 34.60K | 236.69K | | 10:HASH JOIN | 3 | 2.49s | 56.37ms | 2.69s | 118.66K | 236.69K | | |--09:HASH JOIN | 3 | 1.60s | 112.39ms | 1.88s | 2.11M | 236.69K | | | |--08:HASH JOIN | 3 | 450.59ms | 275.34ms | 850.80ms | 2.19M | 236.69K | | | | |--16:EXCHANGE | 3 | 10.32us | 4.93us | 69.01us | 1 | 1 | | | | | F06:EXCHANGE SENDER | 1 | 253.76us | 340.79us | 1.33ms | -1 | -1 | | | | | 22:PROJECT | 1 | 26.21us | 31.75us | 127.15us | 1 | 1 | | | | | 03:SCAN HDFS | 1 | 21.96ms | 17.74ms | 92.73ms | 1 | 1 | | | | 07:HASH JOIN | 3 | 2.13s | 1.44s | 4.18s | 11.19M | 5.92M | | | | |--15:EXCHANGE | 3 | 1.54ms | 847.05us | 4.83ms | 61.09K | 300.00K | | | | | F05:EXCHANGE SENDER | 1 | 30.73ms | 28.21ms | 130.29ms | -1 | -1 | | | | | 00:SCAN HDFS | 1 | 915.97ms | 43.59ms | 1.00s | 61.09K | 300.00K | | | | 06:HASH JOIN | 3 | 3.34s | 1.03s | 4.68s | 11.39M | 6.00M | | | | |--14:EXCHANGE | 3 | 94.95ms | 24.28ms | 252.55ms | 21.92M | 15.00M | | | | | F03:EXCHANGE SENDER | 3 | 709.15ms | 67.75ms | 1.24s | -1 | -1 | | | | | 23:PROJECT | 3 | 63.26ms | 5.63ms | 137.98ms | 21.92M | 15.00M | | | | | 02:SCAN HDFS | 3 | 145.58ms | 41.55ms | 606.35ms | 21.92M | 15.00M | | | | 13:EXCHANGE | 3 | 327.69ms | 214.53ms | 871.60ms | 18.44M | 18.00M | | | | F02:EXCHANGE SENDER | 3 | 2.85s | 2.22s | 6.67s | -1 | -1 | | | | 24:PROJECT | 3 | 421.09ms | 284.24ms | 899.14ms | 18.44M | 18.00M | | | | 01:SCAN HDFS | 3 | 3.18s | 1.05s | 4.87s | 18.44M | 18.00M | | | 17:EXCHANGE | 3 | 386.38ms | 17.94ms | 462.73ms | 65.77M | 180.00M | | | F01:EXCHANGE SENDER | 3 | 3.00s | 36.03ms | 3.32s | -1 | -1 | | | 04:SCAN HDFS | 3 | 998.63ms | 37.80ms | 1.14s | 65.77M | 180.00M | | 18:EXCHANGE | 3 | 679.15ms | 11.61ms | 742.73ms | 113.80M | 18.00M | | F00:EXCHANGE SENDER | 3 | 4.24s | 25.03ms | 4.61s | -1 | -1 | | 25:PROJECT | 3 | 460.21ms | 4.28ms | 519.00ms | 113.80M | 18.00M | | 05:SCAN HDFS | 3 | 257.84ms | 20.45ms | 348.03ms | 113.80M | 18.00M | +------------------------------+--------+----------+----------+----------+---------+-----------+ Reference Execution Summary: +------------------------------+--------+----------+----------+----------+---------+-----------+ | Operator | #Hosts | Avg Time | Std Dev | Max Time | #Rows | Est #Rows | +------------------------------+--------+----------+----------+----------+---------+-----------+ | F08:ROOT | 1 | 59.26us | 9.79us | 91.42us | -1 | -1 | | 21:MERGING-EXCHANGE | 1 | 42.27us | 4.32us | 57.09us | 100 | 100 | | F07:EXCHANGE SENDER | 3 | 44.16us | 7.16us | 145.64us | -1 | -1 | | 12:TOP-N | 3 | 315.31us | 504.90us | 8.47ms | 300 | 100 | | 20:AGGREGATE | 3 | 1.76ms | 104.11us | 2.13ms | 11.96K | 236.69K | | 19:EXCHANGE | 3 | 133.46us | 9.55us | 186.82us | 34.60K | 236.69K | | F04:EXCHANGE SENDER | 3 | 1.89ms | 145.71us | 3.02ms | -1 | -1 | | 11:AGGREGATE | 3 | 25.99ms | 2.41ms | 38.23ms | 34.60K | 236.69K | | 10:HASH JOIN | 3 | 2.47s | 53.06ms | 2.64s | 118.66K | 236.69K | | |--09:HASH JOIN | 3 | 1.76s | 171.77ms | 2.09s | 2.11M | 236.69K | | | |--08:HASH JOIN | 3 | 343.51ms | 320.57ms | 1.01s | 2.19M | 236.69K | | | | |--16:EXCHANGE | 3 | 9.40us | 2.43us | 28.74us | 1 | 1 | | | | | F06:EXCHANGE SENDER | 1 | 159.68us | 135.03us | 735.95us | -1 | -1 | | | | | 03:SCAN HDFS | 1 | 22.30ms | 15.77ms | 76.32ms | 1 | 1 | | | | 07:HASH JOIN | 3 | 1.49s | 1.50s | 4.27s | 15.34M | 5.92M | | | | |--15:EXCHANGE | 3 | 1.45ms | 1.72ms | 19.53ms | 83.71K | 300.00K | | | | | F05:EXCHANGE SENDER | 1 | 28.07ms | 33.34ms | 121.65ms | -1 | -1 | | | | | 00:SCAN HDFS | 1 | 885.25ms | 53.26ms | 978.90ms | 83.71K | 300.00K | | | | 06:HASH JOIN | 3 | 3.19s | 1.34s | 5.42s | 15.45M | 6.00M | | | | |--14:EXCHANGE | 3 | 109.00ms | 20.17ms | 360.17ms | 21.92M | 15.00M | | | | | F03:EXCHANGE SENDER | 3 | 1.10s | 73.63ms | 1.67s | -1 | -1 | | | | | 02:SCAN HDFS | 3 | 111.41ms | 24.22ms | 226.08ms | 21.92M | 15.00M | | | | 13:EXCHANGE | 3 | 257.60ms | 251.11ms | 727.39ms | 24.71M | 18.00M | | | | F02:EXCHANGE SENDER | 3 | 4.92s | 4.46s | 12.85s | -1 | -1 | | | | 01:SCAN HDFS | 3 | 1.93s | 807.43ms | 3.56s | 24.71M | 18.00M | | | 17:EXCHANGE | 3 | 394.68ms | 9.82ms | 454.02ms | 65.77M | 180.00M | | | F01:EXCHANGE SENDER | 3 | 3.06s | 44.12ms | 3.35s | -1 | -1 | | | 04:SCAN HDFS | 3 | 1.01s | 31.28ms | 1.13s | 65.77M | 180.00M | | 18:EXCHANGE | 3 | 738.93ms | 5.71ms | 767.08ms | 113.80M | 18.00M | | F00:EXCHANGE SENDER | 3 | 9.96s | 66.49ms | 10.75s | -1 | -1 | | 05:SCAN HDFS | 3 | 243.46ms | 20.63ms | 319.43ms | 113.80M | 18.00M | +------------------------------+--------+----------+----------+----------+---------+-----------+ Significant perf change detected