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(_1000) | parquet / none / none | 13.68 | +0.65% | 4.54 | +1.36% | +--------------+-----------------------+---------+------------+------------+----------------+ +--------------+------------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +--------------+------------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ | TPCDS(_1000) | TPCDS-Q46 | parquet / none / none | 2.87 | 2.47 | +16.30% | 2.78% | 0.20% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q73 | parquet / none / none | 2.03 | 1.85 | +9.79% | 3.89% | 3.39% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q7 | parquet / none / none | 3.19 | 2.96 | +7.55% | 7.47% | * 11.54% * | 1 | 3 | | TPCDS(_1000) | TPCDS-Q47 | parquet / none / none | 32.22 | 30.64 | +5.14% | 3.74% | 0.94% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q19 | parquet / none / none | 1.85 | 1.76 | +5.09% | 4.02% | 2.34% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q5 | parquet / none / none | 9.79 | 9.53 | +2.79% | 3.03% | 0.90% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q65 | parquet / none / none | 34.23 | 33.30 | +2.78% | 0.18% | 3.01% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q52 | parquet / none / none | 0.90 | 0.88 | +2.71% | 3.24% | 0.08% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q53 | parquet / none / none | 1.71 | 1.67 | +2.69% | 1.55% | 1.91% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q34 | parquet / none / none | 2.31 | 2.25 | +2.56% | 1.54% | 2.19% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q68 | parquet / none / none | 1.60 | 1.57 | +1.92% | 0.49% | 3.09% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q42 | parquet / none / none | 1.10 | 1.08 | +1.71% | 1.88% | 2.66% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q27a | parquet / none / none | 3.39 | 3.34 | +1.55% | 1.27% | 1.96% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q64 | parquet / none / none | 42.46 | 42.05 | +0.96% | 0.46% | 0.34% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q59 | parquet / none / none | 5.69 | 5.64 | +0.89% | 1.83% | 1.79% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q27 | parquet / none / none | 2.47 | 2.45 | +0.67% | 1.05% | 0.07% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q28 | parquet / none / none | 7.79 | 7.75 | +0.45% | 0.38% | 0.06% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q3 | parquet / none / none | 1.13 | 1.12 | +0.36% | 2.37% | 1.91% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q61 | parquet / none / none | 2.17 | 2.16 | +0.35% | 2.90% | 1.95% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q88 | parquet / none / none | 8.57 | 8.55 | +0.18% | 0.44% | 0.51% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q6 | parquet / none / none | 64.50 | 64.47 | +0.05% | 0.55% | 0.05% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q1 | parquet / none / none | 4.00 | 4.01 | -0.17% | 1.98% | 0.32% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q63 | parquet / none / none | 1.64 | 1.64 | -0.23% | 3.23% | 0.00% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q23 | parquet / none / none | 153.40 | 154.13 | -0.48% | 1.71% | 1.36% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q4 | parquet / none / none | 33.19 | 33.35 | -0.49% | 1.34% | 2.14% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q98 | parquet / none / none | 2.24 | 2.25 | -0.54% | 2.75% | 1.04% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q8 | parquet / none / none | 1.37 | 1.38 | -0.59% | 1.76% | 1.94% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q2 | parquet / none / none | 8.68 | 8.75 | -0.83% | * 48.05% * | * 49.62% * | 1 | 3 | | TPCDS(_1000) | TPCDS-Q43 | parquet / none / none | 4.24 | 4.28 | -1.06% | 0.63% | 0.49% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q55 | parquet / none / none | 1.04 | 1.06 | -1.61% | 2.12% | 4.43% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q89 | parquet / none / none | 2.68 | 2.80 | -4.09% | 1.23% | 0.15% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q96 | parquet / none / none | 2.43 | 2.56 | -4.98% | 0.02% | 0.88% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q79 | parquet / none / none | 4.53 | 4.78 | -5.24% | 0.89% | 0.03% | 1 | 3 | +--------------+------------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ (V) Significant Variability: TPCDS(_1000) TPCDS-Q2 [parquet / none / none] (49.62% -> 48.05%) +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+ | 27:MERGING-EXCHANGE | 22.71% | 57.24% | 59.12% | -3.17% | 1 | 2.51K | 2.56K | | 19:EXCHANGE | 23.52% | 55.71% | 57.11% | -2.46% | 14 | 518 | 10.64K | | 05:AGGREGATE | 11.85% | 64.86% | 64.98% | -0.19% | 14 | 518 | 10.64K | | 04:HASH JOIN | 7.63% | 61.13% | 61.33% | -0.33% | 14 | 442.29M | 2.16B | +---------------------+------------+-----------+----------------+------------------+--------+---------+-----------+