Report Generated on 2016-02-19 Run Description: "Base: 2aad36fadb7ef35385cb44dee4a9883c56d6366b vs Ref: 43388a0556136453df51a60408ccfd6a3fc14a6a" Cluster Name: UNKNOWN Lab Run Info: UNKNOWN Impala Version: impalad version 2.5.0-cdh5.7.0 RELEASE (2016-02-17) Baseline Impala Version: impalad version 2.5.0-cdh5.7.0 RELEASE (2016-02-17) +-----------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +-----------+-----------------------+---------+------------+------------+----------------+ | TPCH(_20) | parquet / none / none | 14.37 | -4.85% | 9.91 | -3.63% | +-----------+-----------------------+---------+------------+------------+----------------+ +-----------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +-----------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | TPCH(_20) | TPCH-Q6 | parquet / none / none | 3.81 | 3.76 | +1.38% | 4.51% | 2.72% | 1 | 10 | | TPCH(_20) | TPCH-Q15 | parquet / none / none | 7.35 | 7.27 | +1.13% | 2.03% | 2.23% | 1 | 10 | | TPCH(_20) | TPCH-Q8 | parquet / none / none | 10.06 | 10.00 | +0.60% | 0.81% | 0.93% | 1 | 10 | | TPCH(_20) | TPCH-Q14 | parquet / none / none | 4.53 | 4.52 | +0.36% | 2.14% | 1.69% | 1 | 10 | | TPCH(_20) | TPCH-Q9 | parquet / none / none | 20.19 | 20.14 | +0.22% | 3.13% | 2.31% | 1 | 10 | | TPCH(_20) | TPCH-Q20 | parquet / none / none | 8.04 | 8.05 | -0.16% | 2.27% | 0.67% | 1 | 10 | | TPCH(_20) | TPCH-Q22 | parquet / none / none | 3.51 | 3.53 | -0.62% | 0.66% | 1.86% | 1 | 10 | | TPCH(_20) | TPCH-Q1 | parquet / none / none | 18.27 | 18.41 | -0.77% | 0.67% | 0.79% | 1 | 10 | | TPCH(_20) | TPCH-Q21 | parquet / none / none | 35.81 | 36.09 | -0.78% | 1.19% | 1.51% | 1 | 10 | | TPCH(_20) | TPCH-Q10 | parquet / none / none | 7.22 | 7.29 | -0.95% | 2.67% | 5.60% | 1 | 10 | | TPCH(_20) | TPCH-Q19 | parquet / none / none | 58.61 | 59.26 | -1.10% | 1.86% | 2.02% | 1 | 10 | | TPCH(_20) | TPCH-Q16 | parquet / none / none | 2.87 | 2.91 | -1.36% | 1.18% | 1.95% | 1 | 10 | | TPCH(_20) | TPCH-Q4 | parquet / none / none | 12.90 | 13.15 | -1.84% | 4.10% | 3.57% | 1 | 10 | | TPCH(_20) | TPCH-Q18 | parquet / none / none | 32.30 | 33.06 | -2.31% | 1.04% | 1.50% | 1 | 10 | | TPCH(_20) | TPCH-Q3 | parquet / none / none | 8.13 | 8.35 | -2.58% | 1.75% | 0.99% | 1 | 10 | | TPCH(_20) | TPCH-Q7 | parquet / none / none | 18.03 | 18.61 | -3.10% | 0.90% | 1.09% | 1 | 10 | | TPCH(_20) | TPCH-Q12 | parquet / none / none | 6.88 | 7.12 | -3.28% | 1.29% | 1.46% | 1 | 10 | | TPCH(_20) | TPCH-Q2 | parquet / none / none | 3.44 | 3.57 | -3.64% | 1.88% | 5.08% | 1 | 10 | | TPCH(_20) | TPCH-Q5 | parquet / none / none | 12.38 | 12.89 | -3.93% | 2.55% | 3.07% | 1 | 10 | | TPCH(_20) | TPCH-Q11 | parquet / none / none | 2.53 | 2.64 | -4.07% | 2.36% | 3.65% | 1 | 10 | | TPCH(_20) | TPCH-Q13 | parquet / none / none | 11.24 | 14.67 | I -23.37% | 2.04% | 2.63% | 1 | 10 | | TPCH(_20) | TPCH-Q17 | parquet / none / none | 27.97 | 36.92 | I -24.23% | 1.76% | 0.56% | 1 | 10 | +-----------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ (I) Improvement: TPCH(_20) TPCH-Q13 [parquet / none / none] (14.67s -> 11.24s [-23.37%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+--------+-----------+ | 09:AGGREGATE | 2.30% | 270.87ms | 271.63ms | -0.28% | 7.68% | 313.27ms | 302.04ms | +3.72% | 1 | 3.00M | 2.98M | | 03:AGGREGATE | 40.81% | 4.81s | 7.49s | -35.73% | 3.55% | 5.16s | 8.07s | -36.05% | 1 | 3.24M | 2.98M | | 02:HASH JOIN | 43.75% | 5.16s | 6.04s | -14.62% | 2.14% | 5.33s | 6.26s | -14.86% | 1 | 30.68M | 3.00M | | 06:EXCHANGE | 2.70% | 318.78ms | 275.48ms | +15.72% | 3.01% | 334.56ms | 279.73ms | +19.60% | 1 | 29.68M | 3.00M | | 01:SCAN HDFS | 7.29% | 859.95ms | 362.39ms | +137.30% | 6.71% | 984.18ms | 473.43ms | +107.88% | 1 | 29.68M | 3.00M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+--------+-----------+ (I) Improvement: TPCH(_20) TPCH-Q17 [parquet / none / none] (36.92s -> 27.97s [-24.23%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ | 04:HASH JOIN | 2.11% | 654.20ms | 716.65ms | -8.71% | 4.45% | 697.75ms | 759.96ms | -8.19% | 1 | 122.22K | 599.97K | | 00:SCAN HDFS | 6.78% | 2.10s | 1.98s | +6.09% | 3.64% | 2.27s | 2.16s | +4.94% | 1 | 14.40M | 119.99M | | 08:AGGREGATE | 3.71% | 1.15s | 1.17s | -1.99% | 0.59% | 1.16s | 1.19s | -3.10% | 1 | 4.00M | 3.91M | | 03:AGGREGATE | 83.76% | 25.96s | 34.90s | -25.63% | 1.84% | 26.80s | 35.25s | -23.97% | 1 | 4.00M | 3.91M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ Significant perf change detected