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_NESTED(_300) | parquet / none / none | 28.49 | +1.67% | 11.47 | +1.19% | +-------------------+-----------------------+---------+------------+------------+----------------+ +-------------------+----------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +-------------------+----------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ | TPCH_NESTED(_300) | TPCH-Q17 | parquet / none / none | 76.69 | 70.28 | +9.12% | 5.28% | 1.53% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q2 | parquet / none / none | 6.54 | 6.04 | +8.21% | * 13.06% * | 1.84% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q14 | parquet / none / none | 5.39 | 5.03 | +7.18% | 2.35% | 2.67% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q15 | parquet / none / none | 4.85 | 4.66 | +3.98% | 0.17% | 0.76% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q22 | parquet / none / none | 1.34 | 1.29 | +3.97% | 3.69% | 0.14% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q12 | parquet / none / none | 5.20 | 5.02 | +3.51% | 0.04% | 1.56% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q13 | parquet / none / none | 10.85 | 10.50 | +3.33% | 1.88% | 0.49% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q6 | parquet / none / none | 1.92 | 1.87 | +2.75% | 0.49% | 3.04% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q9 | parquet / none / none | 227.48 | 222.83 | +2.09% | 1.36% | 0.21% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q3 | parquet / none / none | 5.84 | 5.79 | +0.80% | 1.35% | 0.33% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q16 | parquet / none / none | 15.76 | 15.66 | +0.66% | 1.22% | 0.69% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q7 | parquet / none / none | 53.14 | 52.79 | +0.66% | 0.33% | 0.01% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q21 | parquet / none / none | 51.14 | 50.96 | +0.36% | 2.24% | 0.55% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q1 | parquet / none / none | 14.28 | 14.26 | +0.14% | 0.31% | 0.82% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q8 | parquet / none / none | 9.86 | 9.88 | -0.21% | 2.27% | 0.46% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q4 | parquet / none / none | 5.02 | 5.05 | -0.43% | 2.46% | 1.01% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q11 | parquet / none / none | 2.01 | 2.03 | -0.94% | 0.29% | 1.37% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q10 | parquet / none / none | 9.43 | 9.56 | -1.32% | 2.42% | 1.64% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q19 | parquet / none / none | 32.00 | 32.52 | -1.58% | 1.47% | 0.51% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q18 | parquet / none / none | 72.18 | 73.67 | -2.02% | 0.33% | 1.04% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q5 | parquet / none / none | 6.80 | 7.21 | -5.72% | 2.15% | 2.91% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q20 | parquet / none / none | 9.13 | 9.69 | -5.76% | 1.73% | 0.98% | 1 | 3 | +-------------------+----------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ (V) Significant Variability: TPCH_NESTED(_300) TPCH-Q2 [parquet / none / none] (1.84% -> 13.06%) +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | 34:MERGING-EXCHANGE | 28.21% | 13.44% | 4.79% | +180.34% | 1 | 100 | 100 | | 33:EXCHANGE | 20.46% | 13.66% | 0.30% | +4491.49% | 14 | 35.46M | 11.84M | | 30:EXCHANGE | 16.10% | 14.66% | 3.19% | +359.71% | 14 | 47.04M | 11.84M | | 32:EXCHANGE | 7.41% | 12.78% | 17.47% | -26.82% | 14 | 765.73K | 11.84M | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+