Report Generated on 2020-05-08 Run Description: "0d5ee7604faf87ac569c2e8e057565b3b14f5a5c vs c41db8e360d5b4b2f231c752647443c2279c7631" Cluster Name: UNKNOWN Lab Run Info: UNKNOWN Impala Version: impalad version 4.0.0-SNAPSHOT RELEASE () Baseline Impala Version: impalad version 4.0.0-SNAPSHOT RELEASE () +----------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +----------+-----------------------+---------+------------+------------+----------------+ | TPCH(30) | parquet / none / none | 6.02 | +0.53% | 4.04 | +0.00% | +----------+-----------------------+---------+------------+------------+----------------+ +----------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+--------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Iters | Median Diff(%) | MW Zval | Tval | +----------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+--------+ | TPCH(30) | TPCH-Q3 | parquet / none / none | 5.24 | 5.16 | +1.73% | 1.05% | 1.30% | 30 | +1.90% | 4.88 | 5.64 | | TPCH(30) | TPCH-Q21 | parquet / none / none | 27.59 | 27.10 | +1.80% | 0.32% | 0.29% | 30 | +1.80% | 6.54 | 22.61 | | TPCH(30) | TPCH-Q13 | parquet / none / none | 11.67 | 11.46 | +1.80% | 0.39% | 0.44% | 30 | +1.72% | 6.54 | 16.70 | | TPCH(30) | TPCH-Q2 | parquet / none / none | 1.22 | 1.20 | +1.82% | 2.55% | 3.34% | 30 | +1.38% | 2.14 | 2.36 | | TPCH(30) | TPCH-Q7 | parquet / none / none | 3.82 | 3.79 | +0.89% | 1.24% | 1.49% | 30 | +1.19% | 1.98 | 2.52 | | TPCH(30) | TPCH-Q18 | parquet / none / none | 17.53 | 17.32 | +1.17% | 3.64% | 3.11% | 30 | +0.87% | 1.64 | 1.33 | | TPCH(30) | TPCH-Q16 | parquet / none / none | 2.64 | 2.62 | +0.81% | 1.78% | 1.39% | 30 | +0.61% | 1.69 | 1.97 | | TPCH(30) | TPCH-Q9 | parquet / none / none | 14.43 | 14.39 | +0.29% | 1.72% | 1.60% | 30 | +0.33% | 0.60 | 0.67 | | TPCH(30) | TPCH-Q8 | parquet / none / none | 4.53 | 4.51 | +0.39% | 0.83% | 0.76% | 30 | +0.09% | 1.66 | 1.90 | | TPCH(30) | TPCH-Q11 | parquet / none / none | 1.12 | 1.11 | +0.30% | 2.07% | 1.62% | 30 | -0.01% | -0.04 | 0.63 | | TPCH(30) | TPCH-Q5 | parquet / none / none | 3.48 | 3.48 | +0.24% | 0.82% | 1.04% | 30 | +0.04% | 0.68 | 0.99 | | TPCH(30) | TPCH-Q4 | parquet / none / none | 1.90 | 1.89 | +0.27% | 1.82% | 1.71% | 30 | -0.02% | -0.52 | 0.59 | | TPCH(30) | TPCH-Q1 | parquet / none / none | 9.63 | 9.61 | +0.17% | 1.26% | 1.09% | 30 | +0.03% | 0.41 | 0.56 | | TPCH(30) | TPCH-Q15 | parquet / none / none | 3.33 | 3.33 | -0.02% | 1.15% | 1.11% | 30 | -0.01% | -0.15 | -0.08 | | TPCH(30) | TPCH-Q20 | parquet / none / none | 2.56 | 2.56 | +0.02% | 2.00% | 2.08% | 30 | -0.08% | -0.49 | 0.04 | | TPCH(30) | TPCH-Q10 | parquet / none / none | 4.65 | 4.66 | -0.14% | 0.82% | 0.93% | 30 | -0.02% | -0.47 | -0.62 | | TPCH(30) | TPCH-Q19 | parquet / none / none | 3.19 | 3.20 | -0.17% | 0.72% | 1.09% | 30 | -0.01% | -0.40 | -0.71 | | TPCH(30) | TPCH-Q12 | parquet / none / none | 2.36 | 2.37 | -0.32% | 2.00% | 1.98% | 30 | -0.10% | -1.33 | -0.63 | | TPCH(30) | TPCH-Q22 | parquet / none / none | 3.27 | 3.28 | -0.40% | 2.22% | 1.14% | 30 | -0.19% | -2.48 | -0.88 | | TPCH(30) | TPCH-Q14 | parquet / none / none | 2.58 | 2.61 | -1.19% | 1.19% | 4.31% | 30 | -0.02% | -0.54 | -1.47 | | TPCH(30) | TPCH-Q6 | parquet / none / none | 1.19 | 1.20 | -1.24% | 2.44% | 1.82% | 30 | -0.19% | -1.28 | -2.25 | | TPCH(30) | TPCH-Q17 | parquet / none / none | 4.44 | 4.82 | I -7.86% | 1.94% | 2.34% | 30 | I -8.07% | -6.54 | -14.62 | +----------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+--------+ (I) Improvement: TPCH(30) TPCH-Q17 [parquet / none / none] (4.82s -> 4.44s [-7.86%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 00:SCAN HDFS | 25.59% | 1.70s | 1.70s | -0.38% | 2.46% | 1.81s | 1.79s | +1.60% | 1 | 1 | 182.90K | 180.00M | | 08:AGGREGATE | 19.68% | 1.30s | 1.67s | -21.90% | 5.19% | 1.44s | 1.83s | -21.64% | 1 | 1 | 4.61M | 5.84M | | F00:EXCHANGE SENDER | 6.32% | 419.04ms | 404.56ms | +3.58% | 4.94% | 475.27ms | 452.64ms | +5.00% | 1 | 1 | -1 | -1 | | 03:AGGREGATE | 15.90% | 1.05s | 1.07s | -1.36% | 3.57% | 1.14s | 1.17s | -2.60% | 1 | 1 | 4.61M | 5.84M | | 02:SCAN HDFS | 28.19% | 1.87s | 1.87s | -0.29% | 1.97% | 1.95s | 1.98s | -1.58% | 1 | 1 | 8.91M | 180.00M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ Significant perf change detected