Report Generated on 2017-11-03 Cluster Name: UNKNOWN Lab Run Info: UNKNOWN Impala Version: impalad version 2.11.0-SNAPSHOT RELEASE () Baseline Impala Version: impalad version 2.11.0-SNAPSHOT RELEASE () +-------------------------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +-------------------------+-----------------------+---------+------------+------------+----------------+ | TPCDS-UNMODIFIED(_1000) | parquet / none / none | 14.83 | +0.09% | 5.88 | -1.44% | +-------------------------+-----------------------+---------+------------+------------+----------------+ +-------------------------+-----------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +-------------------------+-----------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ | TPCDS-UNMODIFIED(_1000) | TPCDS-Q73 | parquet / none / none | 2.43 | 1.79 | R +35.72% | * 27.24% * | 1.72% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q83 | parquet / none / none | 2.70 | 2.21 | R +22.13% | * 20.34% * | 0.86% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q69 | parquet / none / none | 3.50 | 3.20 | +9.14% | * 10.79% * | 3.63% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q60 | parquet / none / none | 4.09 | 3.79 | +7.87% | * 14.54% * | 1.49% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q16 | parquet / none / none | 3.18 | 2.96 | +7.41% | * 10.39% * | 4.46% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q68 | parquet / none / none | 2.21 | 2.06 | +7.37% | 4.52% | 7.60% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q20 | parquet / none / none | 1.58 | 1.49 | +6.46% | 3.33% | 0.21% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q46 | parquet / none / none | 2.69 | 2.53 | +6.31% | 0.39% | 1.90% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q22 | parquet / none / none | 61.38 | 58.55 | +4.82% | 3.35% | 0.48% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q72 | parquet / none / none | 55.01 | 52.50 | +4.76% | 1.13% | 2.14% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q28 | parquet / none / none | 7.93 | 7.60 | +4.30% | 1.46% | 1.62% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q81 | parquet / none / none | 3.88 | 3.73 | +4.20% | 1.42% | 5.83% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q99 | parquet / none / none | 7.60 | 7.29 | +4.20% | 3.02% | 0.43% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q30 | parquet / none / none | 2.95 | 2.84 | +3.76% | 1.29% | 1.28% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q53 | parquet / none / none | 2.06 | 1.99 | +3.49% | 3.05% | 0.23% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q78 | parquet / none / none | 205.80 | 198.89 | +3.47% | 0.20% | 0.10% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q39 | parquet / none / none | 9.13 | 8.83 | +3.45% | 0.21% | 0.38% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q51 | parquet / none / none | 34.72 | 33.60 | +3.35% | 1.47% | 0.19% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q35 | parquet / none / none | 5.91 | 5.73 | +3.22% | 0.90% | 0.01% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q57 | parquet / none / none | 18.41 | 17.90 | +2.89% | 3.38% | 0.26% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q31 | parquet / none / none | 6.34 | 6.16 | +2.85% | 3.20% | 0.01% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q94 | parquet / none / none | 2.35 | 2.29 | +2.67% | 0.86% | 1.83% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q9 | parquet / none / none | 4.96 | 4.84 | +2.49% | 0.07% | 0.38% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q49 | parquet / none / none | 6.68 | 6.53 | +2.26% | 0.22% | 0.29% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q65 | parquet / none / none | 35.81 | 35.02 | +2.24% | 0.77% | 0.79% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q38 | parquet / none / none | 39.47 | 38.64 | +2.14% | 1.06% | 1.29% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q87 | parquet / none / none | 20.34 | 19.94 | +1.98% | 1.38% | 0.61% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q95 | parquet / none / none | 3.26 | 3.20 | +1.86% | 3.92% | 3.10% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q75 | parquet / none / none | 25.24 | 24.78 | +1.85% | 1.03% | 0.85% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q74 | parquet / none / none | 19.33 | 19.00 | +1.78% | 1.92% | 1.29% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q56 | parquet / none / none | 2.30 | 2.26 | +1.69% | 0.91% | 0.96% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q12 | parquet / none / none | 1.50 | 1.48 | +1.66% | 1.99% | 1.07% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q45 | parquet / none / none | 1.69 | 1.66 | +1.63% | 1.55% | 0.18% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q64 | parquet / none / none | 42.11 | 41.46 | +1.57% | 0.89% | 0.17% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q93 | parquet / none / none | 66.50 | 65.57 | +1.43% | 1.54% | 0.42% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q4 | parquet / none / none | 33.37 | 32.95 | +1.28% | 2.12% | 1.92% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q71 | parquet / none / none | 5.76 | 5.69 | +1.26% | 0.91% | 0.28% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q10 | parquet / none / none | 3.03 | 3.00 | +1.21% | 0.86% | 5.41% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q25 | parquet / none / none | 5.88 | 5.81 | +1.17% | * 10.21% * | * 12.21% * | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q13 | parquet / none / none | 13.82 | 13.70 | +0.91% | 1.63% | 3.31% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q7 | parquet / none / none | 2.67 | 2.64 | +0.81% | 0.11% | 0.73% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q23 | parquet / none / none | 122.71 | 121.74 | +0.80% | 0.51% | 0.12% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q96 | parquet / none / none | 2.48 | 2.46 | +0.76% | 0.76% | 0.65% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q52 | parquet / none / none | 1.11 | 1.10 | +0.74% | 2.97% | 2.74% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q43 | parquet / none / none | 4.31 | 4.28 | +0.73% | 2.11% | 1.68% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q14 | parquet / none / none | 156.10 | 155.23 | +0.56% | 0.64% | 0.37% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q97 | parquet / none / none | 34.34 | 34.16 | +0.53% | 2.80% | 4.99% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q36 | parquet / none / none | 5.28 | 5.26 | +0.48% | 0.93% | 0.25% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q21 | parquet / none / none | 4.10 | 4.08 | +0.41% | 2.02% | 0.50% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q11 | parquet / none / none | 25.68 | 25.61 | +0.28% | 1.17% | 1.47% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q32 | parquet / none / none | 1.45 | 1.44 | +0.14% | 0.57% | 0.26% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q37 | parquet / none / none | 3.86 | 3.86 | +0.11% | 0.53% | 1.27% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q33 | parquet / none / none | 2.91 | 2.91 | +0.07% | 3.31% | 5.97% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q90 | parquet / none / none | 1.59 | 1.59 | +0.00% | 1.64% | 1.54% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q48 | parquet / none / none | 1.72 | 1.72 | -0.05% | 1.50% | 1.22% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q82 | parquet / none / none | 4.51 | 4.52 | -0.12% | 0.00% | 0.04% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q6 | parquet / none / none | 63.79 | 63.87 | -0.13% | 0.09% | 0.89% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q3 | parquet / none / none | 1.30 | 1.31 | -0.36% | 1.84% | 1.82% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q44 | parquet / none / none | 4.05 | 4.07 | -0.43% | 0.11% | 0.89% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q19 | parquet / none / none | 1.76 | 1.77 | -0.45% | 1.84% | 0.76% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q66 | parquet / none / none | 3.56 | 3.58 | -0.79% | 0.16% | 3.69% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q62 | parquet / none / none | 4.32 | 4.36 | -0.87% | 0.89% | 2.65% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q88 | parquet / none / none | 8.54 | 8.62 | -0.91% | 0.03% | 0.05% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q5 | parquet / none / none | 9.12 | 9.21 | -0.98% | 4.61% | 1.40% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q63 | parquet / none / none | 1.97 | 1.99 | -1.18% | 0.13% | 0.91% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q40 | parquet / none / none | 2.48 | 2.51 | -1.20% | 0.96% | 2.04% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q54 | parquet / none / none | 7.55 | 7.66 | -1.47% | 0.60% | 2.78% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q1 | parquet / none / none | 3.58 | 3.64 | -1.66% | 2.04% | 0.10% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q85 | parquet / none / none | 11.34 | 11.54 | -1.72% | 3.05% | 0.49% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q34 | parquet / none / none | 2.33 | 2.37 | -1.73% | 0.31% | 0.92% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q18 | parquet / none / none | 7.79 | 7.94 | -1.79% | 1.20% | 0.83% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q27 | parquet / none / none | 3.68 | 3.75 | -1.87% | 1.67% | 0.67% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q61 | parquet / none / none | 1.84 | 1.88 | -1.97% | 2.14% | 0.42% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q80 | parquet / none / none | 8.95 | 9.13 | -1.99% | 0.38% | 1.87% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q76 | parquet / none / none | 6.76 | 6.91 | -2.18% | 1.42% | 0.42% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q50 | parquet / none / none | 7.73 | 7.96 | -2.91% | 0.31% | 0.47% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q91 | parquet / none / none | 1.40 | 1.44 | -2.95% | 0.24% | 0.41% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q86 | parquet / none / none | 5.31 | 5.50 | -3.30% | 1.16% | 0.21% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q47 | parquet / none / none | 29.70 | 30.75 | -3.42% | 0.13% | 0.66% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q89 | parquet / none / none | 3.03 | 3.14 | -3.53% | 0.64% | 0.89% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q70 | parquet / none / none | 12.97 | 13.45 | -3.58% | 0.02% | 1.03% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q8 | parquet / none / none | 2.56 | 2.66 | -3.66% | 9.83% | 2.87% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q26 | parquet / none / none | 2.34 | 2.43 | -3.71% | 5.15% | 7.43% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q92 | parquet / none / none | 1.09 | 1.13 | -3.72% | 0.61% | 0.27% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q55 | parquet / none / none | 1.08 | 1.13 | -3.78% | 4.23% | 0.63% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q29 | parquet / none / none | 5.37 | 5.60 | -4.09% | 0.74% | 1.33% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q15 | parquet / none / none | 4.96 | 5.19 | -4.44% | 0.87% | 0.45% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q84 | parquet / none / none | 10.60 | 11.13 | -4.78% | 1.69% | 3.82% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q42 | parquet / none / none | 1.05 | 1.12 | -5.60% | 2.07% | 4.46% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q98 | parquet / none / none | 2.69 | 2.86 | -5.94% | 5.14% | 0.08% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q41 | parquet / none / none | 1.01 | 1.08 | -6.75% | 0.48% | 7.17% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q17 | parquet / none / none | 8.51 | 9.30 | -8.57% | 2.68% | 0.30% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q77 | parquet / none / none | 3.84 | 4.30 | -10.57% | 1.92% | 5.58% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q79 | parquet / none / none | 9.97 | 11.31 | -11.84% | * 14.27% * | * 31.46% * | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q2 | parquet / none / none | 8.82 | 12.72 | I -30.68% | * 48.39% * | 0.17% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q59 | parquet / none / none | 5.70 | 13.99 | I -59.23% | 0.48% | * 57.56% * | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q58 | parquet / none / none | 2.67 | 7.23 | I -63.02% | 0.38% | * 63.22% * | 1 | 3 | +-------------------------+-----------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ (R) Regression: TPCDS-UNMODIFIED(_1000) TPCDS-Q73 [parquet / none / none] (1.79s -> 2.43s [+35.72%]) +---------------------+------------+----------+----------+-------------+------------+----------+----------+-------------+--------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +---------------------+------------+----------+----------+-------------+------------+----------+----------+-------------+--------+---------+-----------+ | 18:MERGING-EXCHANGE | 26.80% | 2.11s | 1.50s | +40.36% | * 30.46% * | 2.75s | 1.55s | +77.14% | 1 | 238 | 8.79M | | 09:HASH JOIN | 2.05% | 161.79ms | 55.08ms | +193.76% | * 66.93% * | 2.63s | 66.15ms | +3875.38% | 12 | 238 | 8.79M | | 17:EXCHANGE | 17.88% | 1.41s | 813.16ms | +73.19% | * 41.52% * | 2.14s | 843.70ms | +153.35% | 12 | 4.86K | 8.79M | | 14:EXCHANGE | 20.62% | 1.62s | 1.02s | +59.80% | * 36.73% * | 2.34s | 1.04s | +124.07% | 14 | 75.01K | 8.79M | | 11:EXCHANGE | 2.61% | 205.53ms | 50.60us | +406058.01% | * 99.97% * | 473.69ms | 70.51us | +671718.20% | 14 | 1.04K | 416 | | 00:SCAN HDFS | 2.07% | 163.29ms | 180.84ms | -9.71% | 3.21% | 226.21ms | 232.12ms | -2.55% | 14 | 778.08K | 2.88B | | 16:EXCHANGE | 13.16% | 1.04s | 1.09s | -4.92% | 3.25% | 1.11s | 1.15s | -4.11% | 12 | 6.37M | 12.00M | | 08:SCAN HDFS | 12.16% | 958.23ms | 960.15ms | -0.20% | 0.11% | 977.40ms | 976.22ms | +0.12% | 12 | 6.37M | 12.00M | +---------------------+------------+----------+----------+-------------+------------+----------+----------+-------------+--------+---------+-----------+ (R) Regression: TPCDS-UNMODIFIED(_1000) TPCDS-Q83 [parquet / none / none] (2.21s -> 2.70s [+22.13%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ | 51:MERGING-EXCHANGE | 19.49% | 1.99s | 1.50s | +32.74% | * 27.62% * | 2.54s | 1.51s | +68.82% | 1 | 100 | 100 | | 49:EXCHANGE | 2.81% | 287.43ms | 180.94ms | +58.85% | * 30.75% * | 457.51ms | 306.79ms | +49.13% | 14 | 964.06K | 39.99K | | 12:SCAN HDFS | 8.82% | 902.57ms | 882.51ms | +2.27% | 1.23% | 913.64ms | 892.11ms | +2.41% | 1 | 21 | 73.05K | | 45:EXCHANGE | 2.14% | 218.55ms | 148.58ms | +47.09% | * 35.79% * | 379.52ms | 237.93ms | +59.51% | 14 | 300.00K | 300.00K | | 43:EXCHANGE | 8.50% | 869.57ms | 285.64ms | +204.43% | * 70.79% * | 1.57s | 390.20ms | +301.29% | 14 | 510.66K | 20.00K | | 22:SCAN HDFS | 8.99% | 919.92ms | 913.54ms | +0.70% | 0.79% | 927.23ms | 935.17ms | -0.85% | 1 | 73.05K | 73.05K | | 26:HASH JOIN | 3.89% | 397.54ms | 81.64ms | +386.97% | * 79.03% * | 852.76ms | 102.68ms | +730.49% | 14 | 68.76M | 71.00M | | 39:EXCHANGE | 3.17% | 324.18ms | 263.12ms | +23.21% | * 26.36% * | 480.11ms | 443.25ms | +8.31% | 14 | 300.00K | 300.00K | | 21:SCAN HDFS | 8.72% | 892.11ms | 912.84ms | -2.27% | 2.40% | 913.56ms | 914.03ms | -0.05% | 1 | 300.00K | 300.00K | | 37:EXCHANGE | 5.12% | 523.77ms | 461.03ms | +13.61% | * 25.44% * | 737.60ms | 595.32ms | +23.90% | 14 | 1.57M | 79.98K | | 02:SCAN HDFS | 8.92% | 912.16ms | 922.70ms | -1.14% | 2.19% | 932.12ms | 933.53ms | -0.15% | 1 | 21 | 73.05K | | 33:EXCHANGE | 3.55% | 363.49ms | 301.49ms | +20.57% | * 26.75% * | 539.80ms | 430.38ms | +25.43% | 14 | 300.00K | 300.00K | | 01:SCAN HDFS | 9.08% | 928.93ms | 854.94ms | +8.66% | 5.80% | 982.84ms | 855.93ms | +14.83% | 1 | 300.00K | 300.00K | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ (I) Improvement: TPCDS-UNMODIFIED(_1000) TPCDS-Q2 [parquet / none / none] (12.72s -> 8.82s [-30.68%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ | 27:MERGING-EXCHANGE | 22.55% | 7.29s | 11.21s | -34.92% | * 59.36% * | 11.63s | 11.25s | +3.30% | 1 | 2.51K | 2.56K | | 26:EXCHANGE | 7.74% | 2.50s | 2.52s | -0.68% | 4.81% | 2.66s | 2.61s | +1.68% | 14 | 365 | 2.56K | | 23:EXCHANGE | 8.62% | 2.79s | 2.80s | -0.24% | 4.36% | 2.95s | 2.88s | +2.19% | 14 | 522 | 10.64K | | 13:AGGREGATE | 4.03% | 1.30s | 1.31s | -0.26% | 1.07% | 1.48s | 1.57s | -5.41% | 14 | 522 | 10.64K | | 12:HASH JOIN | 2.73% | 883.79ms | 875.04ms | +1.00% | 1.20% | 1.04s | 941.21ms | +10.17% | 14 | 433.27M | 2.16B | | 06:SCAN HDFS | 2.87% | 927.83ms | 926.42ms | +0.15% | 0.09% | 928.63ms | 926.51ms | +0.23% | 1 | 365 | 373 | | 19:EXCHANGE | 23.57% | 7.63s | 11.50s | -33.71% | * 56.30% * | 11.96s | 11.60s | +3.13% | 14 | 518 | 10.64K | | 05:AGGREGATE | 11.79% | 3.82s | 6.23s | -38.80% | * 64.95% * | 6.64s | 6.51s | +2.09% | 14 | 518 | 10.64K | | 04:HASH JOIN | 7.65% | 2.48s | 3.91s | -36.74% | * 60.35% * | 4.57s | 4.16s | +9.67% | 14 | 442.29M | 2.16B | | 03:SCAN HDFS | 2.87% | 927.44ms | 927.22ms | +0.02% | 0.02% | 927.67ms | 927.68ms | -0.00% | 1 | 27.00K | 73.05K | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ (I) Improvement: TPCDS-UNMODIFIED(_1000) TPCDS-Q59 [parquet / none / none] (13.99s -> 5.70s [-59.23%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ | 30:MERGING-EXCHANGE | 12.74% | 4.55s | 12.96s | -64.88% | 1.21% | 4.61s | 21.02s | -78.09% | 1 | 100 | 100 | | 29:EXCHANGE | 12.43% | 4.44s | 4.40s | +0.75% | 2.64% | 4.61s | 4.69s | -1.65% | 14 | 183.37K | 3.58M | | 24:EXCHANGE | 12.79% | 4.57s | 4.55s | +0.43% | 2.34% | 4.73s | 4.81s | -1.60% | 14 | 210.34K | 5.21M | | 11:AGGREGATE | 7.16% | 2.56s | 2.56s | -0.02% | 0.05% | 2.99s | 2.89s | +3.66% | 14 | 210.34K | 5.21M | | 10:HASH JOIN | 3.44% | 1.23s | 1.23s | -0.61% | 0.26% | 1.52s | 1.52s | -0.40% | 14 | 562.10M | 2.88B | | 28:EXCHANGE | 12.99% | 4.64s | 12.68s | -63.42% | 0.30% | 4.73s | 21.04s | -77.51% | 14 | 182.87K | 3.58M | | 04:SCAN HDFS | 2.53% | 905.17ms | 895.49ms | +1.08% | 0.01% | 905.28ms | 925.25ms | -2.16% | 1 | 1.00K | 1.00K | | 05:SCAN HDFS | 2.60% | 928.66ms | 929.20ms | -0.06% | 0.13% | 929.90ms | 929.87ms | +0.00% | 1 | 365 | 7.30K | | 19:EXCHANGE | 13.37% | 4.77s | 12.82s | -62.77% | 0.81% | 4.85s | 21.14s | -77.04% | 14 | 202.81K | 5.21M | | 03:AGGREGATE | 7.15% | 2.55s | 8.01s | -68.10% | 0.14% | 2.88s | 14.11s | -79.55% | 14 | 202.81K | 5.21M | | 02:HASH JOIN | 3.42% | 1.22s | 3.11s | -60.81% | 0.10% | 1.34s | 5.78s | -76.74% | 14 | 561.84M | 2.88B | | 01:SCAN HDFS | 2.59% | 923.51ms | 906.59ms | +1.87% | 1.47% | 937.07ms | 926.42ms | +1.15% | 1 | 371 | 73.05K | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ (I) Improvement: TPCDS-UNMODIFIED(_1000) TPCDS-Q58 [parquet / none / none] (7.23s -> 2.67s [-63.02%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ | 51:MERGING-EXCHANGE | 17.26% | 1.24s | 5.76s | -78.44% | 2.47% | 1.27s | 10.38s | -87.75% | 1 | 100 | 100 | | 12:SCAN HDFS | 12.99% | 933.98ms | 903.38ms | +3.39% | 0.20% | 935.88ms | 914.62ms | +2.32% | 1 | 7 | 73.05K | | 45:EXCHANGE | 2.48% | 178.29ms | 172.21ms | +3.53% | * 12.73% * | 304.90ms | 243.24ms | +25.35% | 14 | 300.00K | 300.00K | | 22:SCAN HDFS | 12.57% | 903.72ms | 910.75ms | -0.77% | 3.54% | 935.67ms | 928.32ms | +0.79% | 1 | 7 | 73.05K | | 39:EXCHANGE | 3.59% | 258.18ms | 248.09ms | +4.07% | 1.03% | 323.10ms | 372.55ms | -13.27% | 14 | 300.00K | 300.00K | | 21:SCAN HDFS | 12.70% | 913.16ms | 902.32ms | +1.20% | 0.28% | 915.73ms | 933.09ms | -1.86% | 1 | 300.00K | 300.00K | | 02:SCAN HDFS | 12.42% | 892.91ms | 924.44ms | -3.41% | 4.57% | 933.71ms | 936.27ms | -0.27% | 1 | 7 | 73.05K | | 33:EXCHANGE | 4.01% | 288.20ms | 264.78ms | +8.85% | 0.29% | 381.19ms | 378.81ms | +0.63% | 14 | 300.00K | 300.00K | | 01:SCAN HDFS | 12.06% | 867.04ms | 844.98ms | +2.61% | 3.66% | 898.81ms | 853.65ms | +5.29% | 1 | 300.00K | 300.00K | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ (V) Significant Variability: TPCDS-UNMODIFIED(_1000) TPCDS-Q2 [parquet / none / none] (0.17% -> 48.39%) +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | 27:MERGING-EXCHANGE | 22.55% | 59.36% | 0.40% | +14858.83% | 1 | 2.51K | 2.56K | | 19:EXCHANGE | 23.57% | 56.30% | 0.47% | +11941.34% | 14 | 518 | 10.64K | | 05:AGGREGATE | 11.79% | 64.95% | 0.45% | +14206.36% | 14 | 518 | 10.64K | | 04:HASH JOIN | 7.65% | 60.35% | 0.46% | +13015.38% | 14 | 442.29M | 2.16B | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ (V) Significant Variability: TPCDS-UNMODIFIED(_1000) TPCDS-Q73 [parquet / none / none] (1.72% -> 27.24%) +---------------------+------------+-----------+----------------+------------------+--------+--------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+--------+-----------+ | 18:MERGING-EXCHANGE | 26.80% | 30.46% | 3.37% | +803.39% | 1 | 238 | 8.79M | | 09:HASH JOIN | 2.05% | 66.93% | 4.35% | +1438.60% | 12 | 238 | 8.79M | | 17:EXCHANGE | 17.88% | 41.52% | 0.99% | +4086.81% | 12 | 4.86K | 8.79M | | 14:EXCHANGE | 20.62% | 36.73% | 0.70% | +5132.74% | 14 | 75.01K | 8.79M | | 11:EXCHANGE | 2.61% | 99.97% | 0.29% | +33968.13% | 14 | 1.04K | 416 | +---------------------+------------+-----------+----------------+------------------+--------+--------+-----------+ (V) Significant Variability: TPCDS-UNMODIFIED(_1000) TPCDS-Q83 [parquet / none / none] (0.86% -> 20.34%) +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | 51:MERGING-EXCHANGE | 19.49% | 27.62% | 0.35% | +7792.63% | 1 | 100 | 100 | | 49:EXCHANGE | 2.81% | 30.75% | 19.42% | +58.35% | 14 | 964.06K | 39.99K | | 45:EXCHANGE | 2.14% | 35.79% | 4.97% | +619.78% | 14 | 300.00K | 300.00K | | 43:EXCHANGE | 8.50% | 70.79% | 3.34% | +2016.67% | 14 | 510.66K | 20.00K | | 26:HASH JOIN | 3.89% | 79.03% | 3.37% | +2243.70% | 14 | 68.76M | 71.00M | | 39:EXCHANGE | 3.17% | 26.36% | 2.68% | +883.45% | 14 | 300.00K | 300.00K | | 37:EXCHANGE | 5.12% | 25.44% | 4.74% | +437.16% | 14 | 1.57M | 79.98K | | 33:EXCHANGE | 3.55% | 26.75% | 1.86% | +1337.95% | 14 | 300.00K | 300.00K | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ (V) Significant Variability: TPCDS-UNMODIFIED(_1000) TPCDS-Q60 [parquet / none / none] (1.49% -> 14.54%) +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | 53:MERGING-EXCHANGE | 20.86% | 16.30% | 2.26% | +622.61% | 1 | 100 | 100 | | 51:EXCHANGE | 19.43% | 16.69% | 2.24% | +644.09% | 14 | 28.06K | 465.62K | | 46:EXCHANGE | 2.25% | 21.33% | 2.35% | +808.76% | 14 | 2.19M | 1.00M | | 37:EXCHANGE | 18.19% | 18.58% | 2.01% | +824.93% | 14 | 392.15K | 155.21K | | 34:EXCHANGE | 2.33% | 17.07% | 9.72% | +75.62% | 14 | 2.19M | 1.00M | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ (V) Significant Variability: TPCDS-UNMODIFIED(_1000) TPCDS-Q79 [parquet / none / none] (31.46% -> 14.27%) +---------------------+------------+-----------+----------------+------------------+--------+--------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+--------+-----------+ | 18:MERGING-EXCHANGE | 31.18% | 14.14% | 32.39% | -56.33% | 1 | 100 | 100 | | 17:EXCHANGE | 7.35% | 19.40% | 68.94% | -71.85% | 14 | 12.00M | 12.00M | | 16:EXCHANGE | 28.02% | 13.32% | 35.44% | -62.41% | 14 | 14.80M | 12.71M | | 14:EXCHANGE | 21.25% | 17.54% | 20.06% | -12.57% | 14 | 14.80M | 12.71M | +---------------------+------------+-----------+----------------+------------------+--------+--------+-----------+ (V) Significant Variability: TPCDS-UNMODIFIED(_1000) TPCDS-Q69 [parquet / none / none] (3.63% -> 10.79%) +---------------------+------------+-----------+----------------+------------------+--------+--------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+--------+-----------+ | 31:MERGING-EXCHANGE | 26.00% | 10.99% | 4.03% | +172.82% | 1 | 100 | 100 | | 29:EXCHANGE | 22.32% | 13.67% | 5.09% | +168.44% | 14 | 72.92K | 5.60K | | 25:EXCHANGE | 2.09% | 35.42% | 19.02% | +86.21% | 14 | 13.96M | 186.32M | | 27:EXCHANGE | 2.77% | 15.42% | 4.49% | +243.33% | 14 | 20.73M | 46.58M | | 28:EXCHANGE | 7.00% | 32.71% | 15.88% | +105.99% | 14 | 41.27M | 92.50M | +---------------------+------------+-----------+----------------+------------------+--------+--------+-----------+ (V) Significant Variability: TPCDS-UNMODIFIED(_1000) TPCDS-Q16 [parquet / none / none] (4.46% -> 10.39%) +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ | 20:EXCHANGE | 42.23% | 12.21% | 5.48% | +122.95% | 1 | 14 | 1 | | 17:EXCHANGE | 11.28% | 36.34% | 0.81% | +4401.15% | 14 | 4.94M | 1.44B | +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ (V) Significant Variability: TPCDS-UNMODIFIED(_1000) TPCDS-Q25 [parquet / none / none] (12.21% -> 10.21%) +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | 29:MERGING-EXCHANGE | 20.73% | 11.67% | 14.10% | -17.20% | 1 | 100 | 100 | | 27:EXCHANGE | 19.10% | 12.23% | 14.70% | -16.77% | 14 | 141 | 444.44K | | 24:EXCHANGE | 13.18% | 24.69% | 12.57% | +96.37% | 14 | 1.91M | 6.92M | | 22:EXCHANGE | 2.34% | 54.60% | 10.90% | +401.06% | 14 | 300.00K | 300.00K | | 21:EXCHANGE | 14.53% | 23.32% | 12.00% | +94.26% | 14 | 1.91M | 7.02M | | 19:EXCHANGE | 6.17% | 33.87% | 26.22% | +29.19% | 14 | 26.12M | 170.53M | | 18:EXCHANGE | 4.11% | 31.68% | 1.73% | +1732.30% | 14 | 22.44M | 288.00M | | 23:EXCHANGE | 2.07% | 46.24% | 46.22% | +0.04% | 14 | 27.55M | 1.44B | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ Significant perf change detected