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) | +------------+-----------------------+---------+------------+------------+----------------+ | TPCH(_300) | parquet / none / none | 19.11 | -0.33% | 10.19 | -1.78% | +------------+-----------------------+---------+------------+------------+----------------+ +------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | TPCH(_300) | TPCH-Q8 | parquet / none / none | 8.00 | 7.38 | +8.38% | 0.64% | 4.06% | 1 | 3 | | TPCH(_300) | TPCH-Q18 | parquet / none / none | 36.35 | 33.83 | +7.46% | 1.12% | 0.57% | 1 | 3 | | TPCH(_300) | TPCH-Q19 | parquet / none / none | 29.63 | 28.66 | +3.38% | 1.31% | 0.35% | 1 | 3 | | TPCH(_300) | TPCH-Q13 | parquet / none / none | 26.60 | 25.74 | +3.37% | 2.30% | 1.30% | 1 | 3 | | TPCH(_300) | TPCH-Q17 | parquet / none / none | 5.47 | 5.31 | +2.99% | 7.78% | 1.30% | 1 | 3 | | TPCH(_300) | TPCH-Q22 | parquet / none / none | 6.58 | 6.46 | +1.91% | 1.96% | 1.43% | 1 | 3 | | TPCH(_300) | TPCH-Q5 | parquet / none / none | 48.15 | 47.48 | +1.39% | 0.24% | 9.34% | 1 | 3 | | TPCH(_300) | TPCH-Q6 | parquet / none / none | 1.31 | 1.29 | +1.25% | 3.64% | 1.85% | 1 | 3 | | TPCH(_300) | TPCH-Q15 | parquet / none / none | 4.51 | 4.47 | +0.69% | 2.21% | 1.61% | 1 | 3 | | TPCH(_300) | TPCH-Q1 | parquet / none / none | 14.01 | 13.93 | +0.55% | 0.12% | 0.72% | 1 | 3 | | TPCH(_300) | TPCH-Q7 | parquet / none / none | 45.34 | 45.29 | +0.12% | 0.19% | 1.83% | 1 | 3 | | TPCH(_300) | TPCH-Q3 | parquet / none / none | 29.38 | 29.40 | -0.05% | 1.11% | 0.95% | 1 | 3 | | TPCH(_300) | TPCH-Q16 | parquet / none / none | 7.49 | 7.58 | -1.30% | 0.80% | 2.36% | 1 | 3 | | TPCH(_300) | TPCH-Q14 | parquet / none / none | 4.58 | 4.66 | -1.62% | 0.53% | 0.16% | 1 | 3 | | TPCH(_300) | TPCH-Q12 | parquet / none / none | 3.43 | 3.50 | -1.87% | 0.07% | 0.68% | 1 | 3 | | TPCH(_300) | TPCH-Q9 | parquet / none / none | 30.38 | 30.96 | -1.87% | 0.41% | 0.84% | 1 | 3 | | TPCH(_300) | TPCH-Q4 | parquet / none / none | 5.00 | 5.16 | -3.03% | 0.43% | 0.40% | 1 | 3 | | TPCH(_300) | TPCH-Q21 | parquet / none / none | 96.12 | 100.21 | -4.08% | 0.79% | 0.19% | 1 | 3 | | TPCH(_300) | TPCH-Q2 | parquet / none / none | 2.75 | 2.92 | -5.85% | 2.08% | 7.11% | 1 | 3 | | TPCH(_300) | TPCH-Q10 | parquet / none / none | 9.72 | 10.38 | -6.33% | 1.57% | 2.73% | 1 | 3 | | TPCH(_300) | TPCH-Q20 | parquet / none / none | 3.49 | 4.24 | -17.74% | 8.18% | * 20.44% * | 1 | 3 | | TPCH(_300) | TPCH-Q11 | parquet / none / none | 2.16 | 2.99 | I -27.62% | 5.95% | * 34.36% * | 1 | 3 | +------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ (I) Improvement: TPCH(_300) TPCH-Q11 [parquet / none / none] (2.99s -> 2.16s [-27.62%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ | 23:MERGING-EXCHANGE | 24.41% | 2.02s | 2.85s | -28.91% | 5.55% | 2.14s | 3.87s | -44.77% | 1 | 0 | 9.60M | | 22:EXCHANGE | 11.36% | 941.74ms | 963.75ms | -2.28% | 0.25% | 1.08s | 1.23s | -12.05% | 14 | 1 | 1 | | 20:EXCHANGE | 17.74% | 1.47s | 1.53s | -3.64% | 0.18% | 1.47s | 1.62s | -8.81% | 1 | 14 | 1 | | 07:SCAN HDFS | 6.53% | 541.49ms | 711.02ms | -23.84% | 1.57% | 579.30ms | 905.34ms | -36.01% | 9 | 120.07K | 3.00M | | 06:SCAN HDFS | 3.90% | 323.06ms | 307.01ms | +5.23% | 0.38% | 409.25ms | 372.43ms | +9.89% | 14 | 9.61M | 240.00M | | 16:EXCHANGE | 14.77% | 1.22s | 2.01s | -39.12% | 9.38% | 1.53s | 3.23s | -52.72% | 14 | 9.04M | 9.60M | | 05:AGGREGATE | 2.40% | 198.99ms | 194.66ms | +2.23% | 0.96% | 285.08ms | 244.77ms | +16.47% | 14 | 9.04M | 9.60M | | 01:SCAN HDFS | 8.67% | 719.08ms | 772.24ms | -6.88% | * 17.48% * | 863.90ms | 965.43ms | -10.52% | 9 | 120.07K | 3.00M | | 00:SCAN HDFS | 2.70% | 223.75ms | 159.60ms | +40.20% | 1.34% | 299.82ms | 281.27ms | +6.59% | 14 | 9.61M | 240.00M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+---------+-----------+ Significant perf change detected