Report Generated on 2017-10-28 Run Description: "4592ed445e5cd946efbec8e40c73ed3e8162f3b2 vs 68b7a2c2b3cbbf3920f04ef548d00c6db0004991" 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 (2017-10-27) +-------------------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +-------------------+-----------------------+---------+------------+------------+----------------+ | TARGETED-PERF(10) | parquet / none / none | 2.98 | -0.15% | 0.84 | +0.62% | +-------------------+-----------------------+---------+------------+------------+----------------+ +-------------------+--------------------------------------------------------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +-------------------+--------------------------------------------------------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ | TARGETED-PERF(10) | primitive_conjunct_ordering_1 | parquet / none / none | 0.10 | 0.09 | +11.63% | * 30.72% * | * 31.33% * | 1 | 30 | | TARGETED-PERF(10) | primitive_conjunct_ordering_3 | parquet / none / none | 0.20 | 0.19 | +8.75% | * 18.31% * | * 18.98% * | 1 | 30 | | TARGETED-PERF(10) | PERF_STRING-Q1 | parquet / none / none | 0.61 | 0.58 | +4.92% | 6.29% | 6.11% | 1 | 30 | | TARGETED-PERF(10) | primitive_broadcast_join_1 | parquet / none / none | 0.20 | 0.19 | +4.88% | * 19.42% * | * 14.86% * | 1 | 30 | | TARGETED-PERF(10) | primitive_groupby_decimal_lowndv.test | parquet / none / none | 0.40 | 0.38 | +4.56% | 8.29% | 9.58% | 1 | 30 | | TARGETED-PERF(10) | primitive_filter_string_non_selective | parquet / none / none | 0.29 | 0.28 | +4.33% | * 10.57% * | 7.41% | 1 | 30 | | TARGETED-PERF(10) | primitive_filter_decimal_non_selective | parquet / none / none | 0.35 | 0.33 | +3.54% | * 10.66% * | 7.62% | 1 | 30 | | TARGETED-PERF(10) | PERF_AGG-Q1 | parquet / none / none | 0.39 | 0.38 | +2.13% | 7.63% | 4.95% | 1 | 30 | | TARGETED-PERF(10) | PERF_STRING-Q2 | parquet / none / none | 0.65 | 0.64 | +1.72% | 6.65% | 6.73% | 1 | 30 | | TARGETED-PERF(10) | PERF_STRING-Q3 | parquet / none / none | 0.70 | 0.69 | +1.64% | 5.21% | 5.14% | 1 | 30 | | TARGETED-PERF(10) | primitive_filter_bigint_non_selective | parquet / none / none | 0.23 | 0.23 | +1.44% | 7.32% | 8.61% | 1 | 30 | | TARGETED-PERF(10) | primitive_empty_build_join_1 | parquet / none / none | 0.91 | 0.90 | +1.21% | 3.04% | 2.59% | 1 | 30 | | TARGETED-PERF(10) | primitive_filter_string_selective | parquet / none / none | 0.26 | 0.26 | +1.12% | * 14.58% * | * 13.05% * | 1 | 30 | | TARGETED-PERF(10) | primitive_filter_string_like | parquet / none / none | 2.72 | 2.69 | +1.06% | 2.64% | 2.22% | 1 | 30 | | TARGETED-PERF(10) | PERF_STRING-Q7 | parquet / none / none | 1.41 | 1.39 | +1.03% | 3.77% | 3.67% | 1 | 30 | | TARGETED-PERF(10) | primitive_filter_decimal_selective | parquet / none / none | 0.30 | 0.30 | +0.99% | * 13.11% * | * 12.94% * | 1 | 30 | | TARGETED-PERF(10) | primitive_filter_in_predicate | parquet / none / none | 0.45 | 0.45 | +0.92% | 8.35% | 6.76% | 1 | 30 | | TARGETED-PERF(10) | PERF_AGG-Q5 | parquet / none / none | 0.54 | 0.53 | +0.70% | 5.47% | 4.56% | 1 | 30 | | TARGETED-PERF(10) | primitive_conjunct_ordering_2 | parquet / none / none | 1.68 | 1.67 | +0.70% | 2.25% | 2.72% | 1 | 30 | | TARGETED-PERF(10) | PERF_STRING-Q6 | parquet / none / none | 1.83 | 1.82 | +0.57% | 2.41% | 2.48% | 1 | 30 | | TARGETED-PERF(10) | PERF_AGG-Q3 | parquet / none / none | 0.76 | 0.75 | +0.46% | 5.90% | 7.39% | 1 | 30 | | TARGETED-PERF(10) | primitive_filter_bigint_selective | parquet / none / none | 0.12 | 0.12 | +0.45% | 5.53% | 6.04% | 1 | 30 | | TARGETED-PERF(10) | primitive_orderby_all | parquet / none / none | 3.54 | 3.52 | +0.40% | 1.54% | 1.66% | 1 | 30 | | TARGETED-PERF(10) | primitive_long_predicate | parquet / none / none | 43.05 | 42.89 | +0.36% | 0.58% | 0.74% | 1 | 30 | | TARGETED-PERF(10) | PERF_STRING-Q4 | parquet / none / none | 0.71 | 0.70 | +0.23% | 5.64% | 5.89% | 1 | 30 | | TARGETED-PERF(10) | primitive_small_join_1 | parquet / none / none | 0.18 | 0.18 | +0.22% | 3.08% | 5.70% | 1 | 30 | | TARGETED-PERF(10) | primitive_exchange_shuffle | parquet / none / none | 6.36 | 6.35 | +0.17% | 2.64% | 2.49% | 1 | 30 | | TARGETED-PERF(10) | PERF_AGG-Q2 | parquet / none / none | 0.77 | 0.77 | -0.02% | 4.88% | 5.99% | 1 | 30 | | TARGETED-PERF(10) | PERF_STRING-Q5 | parquet / none / none | 0.83 | 0.84 | -0.08% | 5.79% | 4.72% | 1 | 30 | | TARGETED-PERF(10) | primitive_conjunct_ordering_5 | parquet / none / none | 2.31 | 2.32 | -0.15% | 1.79% | 1.98% | 1 | 30 | | TARGETED-PERF(10) | primitive_exchange_broadcast | parquet / none / none | 4.65 | 4.67 | -0.30% | 1.09% | 2.07% | 1 | 30 | | TARGETED-PERF(10) | primitive_top-n_all | parquet / none / none | 16.67 | 16.72 | -0.30% | 0.85% | 0.44% | 1 | 30 | | TARGETED-PERF(10) | PERF_AGG-Q4 | parquet / none / none | 1.33 | 1.34 | -0.42% | 3.02% | 3.75% | 1 | 30 | | TARGETED-PERF(10) | primitive_conjunct_ordering_4 | parquet / none / none | 0.24 | 0.24 | -0.50% | 9.69% | * 11.62% * | 1 | 30 | | TARGETED-PERF(10) | primitive_broadcast_join_3 | parquet / none / none | 1.36 | 1.36 | -0.58% | 2.56% | 2.70% | 1 | 30 | | TARGETED-PERF(10) | primitive_shuffle_join_union_all_with_groupby | parquet / none / none | 6.62 | 6.66 | -0.59% | 1.14% | 1.10% | 1 | 30 | | TARGETED-PERF(10) | primitive_groupby_bigint_pk | parquet / none / none | 9.91 | 9.98 | -0.71% | 0.88% | 1.09% | 1 | 30 | | TARGETED-PERF(10) | primitive_groupby_bigint_highndv | parquet / none / none | 2.39 | 2.42 | -1.03% | 2.01% | 2.26% | 1 | 30 | | TARGETED-PERF(10) | primitive_shuffle_join_one_to_many_string_with_groupby | parquet / none / none | 18.07 | 18.30 | -1.24% | 1.27% | 1.65% | 1 | 30 | | TARGETED-PERF(10) | primitive_topn_bigint | parquet / none / none | 1.33 | 1.35 | -1.52% | 2.05% | 2.00% | 1 | 30 | | TARGETED-PERF(10) | primitive_broadcast_join_2 | parquet / none / none | 0.41 | 0.42 | -2.00% | 7.52% | 7.55% | 1 | 30 | | TARGETED-PERF(10) | PERF_AGG-Q7 | parquet / none / none | 0.36 | 0.37 | -2.78% | * 11.21% * | 7.64% | 1 | 30 | | TARGETED-PERF(10) | primitive_groupby_decimal_highndv | parquet / none / none | 2.48 | 2.56 | -2.98% | 2.46% | 3.36% | 1 | 30 | | TARGETED-PERF(10) | PERF_LIMIT-Q1 | parquet / none / none | 0.01 | 0.01 | -2.98% | * 10.61% * | * 33.54% * | 1 | 30 | | TARGETED-PERF(10) | primitive_groupby_bigint_lowndv | parquet / none / none | 0.41 | 0.42 | -3.55% | * 10.76% * | * 11.22% * | 1 | 30 | | TARGETED-PERF(10) | PERF_AGG-Q6 | parquet / none / none | 0.36 | 0.37 | -4.17% | * 10.01% * | 6.90% | 1 | 30 | | TARGETED-PERF(10) | primitive_orderby_bigint | parquet / none / none | 0.68 | 0.71 | -5.07% | 6.96% | 6.31% | 1 | 30 | +-------------------+--------------------------------------------------------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ (V) Significant Variability: TARGETED-PERF(10) primitive_conjunct_ordering_1 [parquet / none / none] (31.33% -> 30.72%) +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ | 01:EXCHANGE | 98.64% | 24.84% | 19.84% | +25.18% | 1 | 0 | 1 | +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_broadcast_join_1 [parquet / none / none] (14.86% -> 19.42%) +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ | 05:EXCHANGE | 98.88% | 10.22% | 7.97% | +28.13% | 1 | 3 | 1 | +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_conjunct_ordering_3 [parquet / none / none] (18.98% -> 18.31%) +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ | 03:EXCHANGE | 34.99% | 13.97% | 13.85% | +0.86% | 3 | 0 | 1.29M | +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_filter_string_selective [parquet / none / none] (13.05% -> 14.58%) +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ | 02:EXCHANGE | 57.32% | 10.97% | 9.45% | +16.07% | 1 | 3 | 1 | +-------------+------------+-----------+----------------+------------------+--------+-------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_filter_decimal_selective [parquet / none / none] (12.94% -> 13.11%) No Nodes with significant StdDev % (V) Significant Variability: TARGETED-PERF(10) PERF_AGG-Q7 [parquet / none / none] (7.64% -> 11.21%) No Nodes with significant StdDev % (V) Significant Variability: TARGETED-PERF(10) primitive_groupby_bigint_lowndv [parquet / none / none] (11.22% -> 10.76%) +--------------+------------+-----------+----------------+------------------+--------+--------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Rows | Est #Rows | +--------------+------------+-----------+----------------+------------------+--------+--------+-----------+ | 04:EXCHANGE | 38.19% | 10.27% | 10.45% | -1.69% | 1 | 0 | 1 | | 02:EXCHANGE | 32.94% | 12.12% | 11.89% | +1.89% | 3 | 21 | 7 | | 00:SCAN HDFS | 2.78% | 11.41% | 12.03% | -5.18% | 3 | 59.99M | 59.99M | +--------------+------------+-----------+----------------+------------------+--------+--------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_filter_decimal_non_selective [parquet / none / none] (7.62% -> 10.66%) No Nodes with significant StdDev % (V) Significant Variability: TARGETED-PERF(10) PERF_LIMIT-Q1 [parquet / none / none] (33.54% -> 10.61%) No Nodes with significant StdDev % (V) Significant Variability: TARGETED-PERF(10) primitive_filter_string_non_selective [parquet / none / none] (7.41% -> 10.57%) No Nodes with significant StdDev % (V) Significant Variability: TARGETED-PERF(10) PERF_AGG-Q6 [parquet / none / none] (6.90% -> 10.01%) No Nodes with significant StdDev %