Report Generated on 2020-05-18 Run Description: "bb1c051a8c9d1272fb40d0f3406b92863ff3836b vs f0e1c8319d87e9239592328710ca4517eb44c566" 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) | +-------------------+-----------------------+---------+------------+------------+----------------+ | TARGETED-PERF(10) | parquet / none / none | 2.97 | -3.98% | 0.97 | -2.01% | +-------------------+-----------------------+---------+------------+------------+----------------+ +-------------------+--------------------------------------------------------+-----------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+--------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Iters | Median Diff(%) | MW Zval | Tval | +-------------------+--------------------------------------------------------+-----------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+--------+ | TARGETED-PERF(10) | primitive_cancel_union | parquet / none / none | 0.21 | 0.20 | +5.21% | * 13.52% * | 8.42% | 30 | +0.37% | 2.01 | 1.73 | | TARGETED-PERF(10) | primitive_groupby_decimal_highndv | parquet / none / none | 2.35 | 2.30 | +2.11% | 2.55% | 1.98% | 30 | +2.05% | 2.93 | 3.54 | | TARGETED-PERF(10) | PERF_AGG-Q1 | parquet / none / none | 0.27 | 0.27 | +2.74% | 8.64% | 4.93% | 30 | +0.04% | 0.24 | 1.47 | | TARGETED-PERF(10) | primitive_broadcast_join_1 | parquet / none / none | 0.22 | 0.22 | +2.59% | * 10.79% * | 9.66% | 30 | +0.17% | 0.85 | 0.97 | | TARGETED-PERF(10) | PERF_AGG-Q7 | parquet / none / none | 0.32 | 0.32 | +2.16% | 7.29% | 5.78% | 30 | +0.18% | 0.94 | 1.26 | | TARGETED-PERF(10) | primitive_filter_in_predicate | parquet / none / none | 0.44 | 0.43 | +2.12% | 7.11% | 8.93% | 30 | -0.06% | -0.19 | 1.01 | | TARGETED-PERF(10) | primitive_filter_string_selective | parquet / none / none | 0.12 | 0.12 | +1.79% | * 22.46% * | * 18.86% * | 30 | +0.11% | 0.52 | 0.33 | | TARGETED-PERF(10) | primitive_conjunct_ordering_2 | parquet / none / none | 2.31 | 2.29 | +0.82% | 2.01% | 2.00% | 30 | +0.60% | 1.75 | 1.58 | | TARGETED-PERF(10) | primitive_min_max_runtime_filter | parquet / none / none | 0.48 | 0.47 | +1.02% | 5.76% | 5.57% | 30 | +0.06% | 0.32 | 0.70 | | TARGETED-PERF(10) | primitive_orderby_bigint | parquet / none / none | 0.58 | 0.58 | +0.94% | 6.72% | 5.23% | 30 | -0.14% | -0.54 | 0.60 | | TARGETED-PERF(10) | primitive_filter_bigint_in_list | parquet / none / none | 0.18 | 0.18 | +0.26% | * 13.81% * | * 14.59% * | 30 | +0.48% | 1.42 | 0.07 | | TARGETED-PERF(10) | primitive_broadcast_join_3 | parquet / none / none | 1.32 | 1.31 | +0.57% | 3.44% | 2.69% | 30 | +0.10% | 0.99 | 0.71 | | TARGETED-PERF(10) | primitive_many_fragments | parquet / none / none | 19.16 | 19.12 | +0.23% | 0.31% | 0.45% | 30 | +0.29% | 2.28 | 2.31 | | TARGETED-PERF(10) | PERF_AGG-Q4 | parquet / none / none | 1.39 | 1.38 | +0.36% | 3.57% | 2.91% | 30 | +0.00% | 0.01 | 0.42 | | TARGETED-PERF(10) | PERF_STRING-Q3 | parquet / none / none | 0.76 | 0.76 | +0.24% | 3.64% | 4.64% | 30 | +0.02% | 0.12 | 0.22 | | TARGETED-PERF(10) | PERF_STRING-Q2 | parquet / none / none | 0.69 | 0.69 | +0.16% | 3.88% | 4.68% | 30 | -0.01% | -0.07 | 0.14 | | TARGETED-PERF(10) | primitive_count_star | parquet / none / none | 0.06 | 0.06 | +0.20% | 1.99% | 1.75% | 30 | -0.07% | -0.38 | 0.42 | | TARGETED-PERF(10) | PERF_AGG-Q5 | parquet / none / none | 0.46 | 0.46 | +0.17% | 2.06% | 0.70% | 30 | -0.10% | -0.94 | 0.42 | | TARGETED-PERF(10) | PERF_STRING-Q7 | parquet / none / none | 1.50 | 1.50 | -0.30% | 3.00% | 3.04% | 30 | -0.08% | -0.33 | -0.39 | | TARGETED-PERF(10) | PERF_LIMIT-Q1 | parquet / none / none | 0.06 | 0.06 | -1.64% | * 13.59% * | 2.47% | 30 | +0.78% | 1.08 | -0.66 | | TARGETED-PERF(10) | primitive_conjunct_ordering_1 | parquet / none / none | 0.11 | 0.11 | -0.76% | * 14.31% * | * 15.76% * | 30 | -0.27% | -1.77 | -0.20 | | TARGETED-PERF(10) | PERF_STRING-Q5 | parquet / none / none | 0.90 | 0.91 | -0.74% | 4.16% | 3.71% | 30 | -0.31% | -1.22 | -0.73 | | TARGETED-PERF(10) | primitive_orderby_all | parquet / none / none | 2.89 | 2.90 | -0.58% | 1.73% | 1.83% | 30 | -0.62% | -1.45 | -1.27 | | TARGETED-PERF(10) | primitive_groupby_decimal_lowndv.test | parquet / none / none | 0.43 | 0.43 | -1.18% | * 11.17% * | 7.46% | 30 | -0.04% | -0.40 | -0.49 | | TARGETED-PERF(10) | PERF_STRING-Q1 | parquet / none / none | 0.64 | 0.65 | -1.30% | 5.79% | 5.75% | 30 | -0.24% | -0.96 | -0.88 | | TARGETED-PERF(10) | string_filter_in_predicate | parquet / none / none | 0.43 | 0.44 | -1.49% | 5.23% | 9.27% | 30 | -0.13% | -0.58 | -0.77 | | TARGETED-PERF(10) | primitive_intrinsic_appx_median | parquet / none / none | 4.89 | 4.93 | -0.80% | 1.42% | 0.99% | 30 | -1.01% | -2.26 | -2.53 | | TARGETED-PERF(10) | primitive_empty_build_join_1 | parquet / none / none | 0.80 | 0.82 | -1.61% | 2.22% | 3.04% | 30 | -0.22% | -2.20 | -2.36 | | TARGETED-PERF(10) | primitive_groupby_bigint_lowndv | parquet / none / none | 0.45 | 0.46 | -1.84% | 9.68% | * 11.79% * | 30 | -0.08% | -0.69 | -0.67 | | TARGETED-PERF(10) | PERF_AGG-Q2 | parquet / none / none | 0.80 | 0.82 | -1.79% | 5.55% | 4.84% | 30 | -0.26% | -1.64 | -1.35 | | TARGETED-PERF(10) | primitive_intrinsic_to_date | parquet / none / none | 7.59 | 7.65 | -0.79% | 2.22% | 1.04% | 30 | -1.33% | -1.73 | -1.77 | | TARGETED-PERF(10) | primitive_filter_bigint_selective | parquet / none / none | 0.11 | 0.11 | -2.11% | 0.81% | 9.28% | 30 | -0.17% | -1.47 | -1.24 | | TARGETED-PERF(10) | PERF_AGG-Q3 | parquet / none / none | 0.81 | 0.83 | -2.25% | 7.53% | 9.99% | 30 | -0.11% | -0.88 | -0.99 | | TARGETED-PERF(10) | primitive_small_join_1 | parquet / none / none | 0.19 | 0.19 | -2.76% | * 13.83% * | * 12.42% * | 30 | -0.12% | -0.54 | -0.83 | | TARGETED-PERF(10) | primitive_shuffle_join_union_all_with_groupby | parquet / none / none | 6.17 | 6.25 | -1.34% | 0.73% | 0.82% | 30 | -1.56% | -4.94 | -6.74 | | TARGETED-PERF(10) | primitive_filter_decimal_non_selective | parquet / none / none | 0.33 | 0.34 | -2.88% | * 10.23% * | * 12.74% * | 30 | -0.20% | -0.97 | -0.98 | | TARGETED-PERF(10) | primitive_filter_string_like | parquet / none / none | 3.10 | 3.16 | -1.82% | 2.10% | 1.82% | 30 | -1.62% | -2.68 | -3.62 | | TARGETED-PERF(10) | PERF_STRING-Q4 | parquet / none / none | 0.77 | 0.79 | -2.70% | 3.63% | 4.44% | 30 | -0.75% | -3.55 | -2.61 | | TARGETED-PERF(10) | primitive_long_predicate | parquet / none / none | 13.48 | 13.72 | -1.74% | 0.47% | 0.40% | 30 | -1.80% | -6.51 | -15.63 | | TARGETED-PERF(10) | primitive_conjunct_ordering_4 | parquet / none / none | 0.24 | 0.25 | -3.50% | * 10.72% * | * 11.20% * | 30 | -0.13% | -0.44 | -1.26 | | TARGETED-PERF(10) | primitive_groupby_bigint_highndv | parquet / none / none | 1.89 | 1.92 | -1.83% | 2.42% | 3.29% | 30 | -2.54% | -1.70 | -2.47 | | TARGETED-PERF(10) | primitive_conjunct_ordering_3 | parquet / none / none | 0.21 | 0.22 | -4.48% | 4.84% | * 10.56% * | 30 | -0.08% | -0.88 | -2.13 | | TARGETED-PERF(10) | primitive_orderby_bigint_expression | parquet / none / none | 3.55 | 3.63 | -2.30% | 0.68% | 0.73% | 30 | -2.39% | -6.35 | -12.78 | | TARGETED-PERF(10) | PERF_AGG-Q6 | parquet / none / none | 0.32 | 0.34 | -5.06% | 5.98% | * 25.32% * | 30 | +0.27% | 1.56 | -1.07 | | TARGETED-PERF(10) | primitive_broadcast_join_2 | parquet / none / none | 0.44 | 0.46 | -3.80% | 7.50% | 9.28% | 30 | -1.00% | -1.52 | -1.77 | | TARGETED-PERF(10) | PERF_STRING-Q6 | parquet / none / none | 2.27 | 2.33 | -2.68% | 1.84% | 1.88% | 30 | -2.34% | -4.36 | -5.65 | | TARGETED-PERF(10) | primitive_filter_string_non_selective | parquet / none / none | 0.26 | 0.27 | -4.78% | 9.23% | 8.64% | 30 | -0.29% | -1.31 | -2.12 | | TARGETED-PERF(10) | primitive_groupby_bigint_pk | parquet / none / none | 9.40 | 9.69 | -3.03% | 0.86% | 0.94% | 30 | -3.21% | -6.45 | -13.21 | | TARGETED-PERF(10) | primitive_filter_bigint_non_selective | parquet / none / none | 0.22 | 0.23 | -5.33% | 9.45% | * 11.61% * | 30 | -1.16% | -2.01 | -1.99 | | TARGETED-PERF(10) | primitive_filter_decimal_selective | parquet / none / none | 0.17 | 0.18 | -6.27% | * 11.74% * | * 14.74% * | 30 | -0.35% | -1.02 | -1.87 | | TARGETED-PERF(10) | PERF_AGG-Q8 | parquet / none / none | 4.19 | 4.41 | I -5.02% | 1.83% | 5.72% | 30 | I -3.83% | -5.11 | -4.60 | | TARGETED-PERF(10) | primitive_exchange_shuffle | parquet / none / none | 6.50 | 6.80 | -4.37% | 4.01% | 4.17% | 30 | -4.58% | -5.31 | -4.22 | | TARGETED-PERF(10) | primitive_exchange_broadcast | parquet / none / none | 4.63 | 4.92 | I -5.91% | 9.35% | * 14.60% * | 30 | I -3.40% | -4.13 | -1.90 | | TARGETED-PERF(10) | PERF_AGG-Q9 | parquet / none / none | 19.76 | 20.84 | I -5.19% | 3.24% | 2.80% | 30 | I -5.57% | -5.79 | -6.84 | | TARGETED-PERF(10) | primitive_top-n_all | parquet / none / none | 14.22 | 15.05 | I -5.54% | 0.32% | 0.31% | 30 | I -5.78% | -6.54 | -70.30 | | TARGETED-PERF(10) | primitive_topn_bigint | parquet / none / none | 1.25 | 1.37 | I -8.64% | 2.07% | 1.65% | 30 | I -8.06% | -6.54 | -18.84 | | TARGETED-PERF(10) | primitive_decimal_arithmetic | parquet / none / none | 9.88 | 10.65 | I -7.25% | 0.35% | 4.11% | 30 | I -10.63% | -6.54 | -9.62 | | TARGETED-PERF(10) | primitive_conjunct_ordering_5 | parquet / none / none | 2.59 | 2.89 | I -10.25% | 2.45% | 2.28% | 30 | I -11.66% | -6.54 | -17.74 | | TARGETED-PERF(10) | primitive_shuffle_join_one_to_many_string_with_groupby | parquet / none / none | 15.51 | 17.87 | I -13.19% | 1.02% | 0.92% | 30 | I -15.20% | -6.54 | -56.64 | +-------------------+--------------------------------------------------------+-----------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+--------+ (I) Improvement: TARGETED-PERF(10) PERF_AGG-Q8 [parquet / none / none] (4.41s -> 4.19s [-5.02%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 05:AGGREGATE | 14.90% | 653.53ms | 694.20ms | -5.86% | 1.25% | 718.09ms | 1.18s | -39.09% | 3 | 3 | 17.00M | 16.90M | | 04:EXCHANGE | 2.37% | 103.91ms | 106.75ms | -2.66% | 1.49% | 114.94ms | 119.25ms | -3.61% | 3 | 3 | 21.00M | 16.90M | | F00:EXCHANGE SENDER | 20.65% | 905.79ms | 886.93ms | +2.13% | 1.14% | 990.24ms | 1.05s | -5.60% | 3 | 3 | -1 | -1 | | 01:AGGREGATE | 59.22% | 2.60s | 2.80s | -7.07% | 2.05% | 3.32s | 3.93s | -15.47% | 3 | 3 | 21.00M | 16.90M | | 00:SCAN HDFS | 2.16% | 94.64ms | 99.79ms | -5.16% | 5.29% | 132.46ms | 136.13ms | -2.69% | 3 | 3 | 59.99M | 59.99M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TARGETED-PERF(10) primitive_exchange_broadcast [parquet / none / none] (4.92s -> 4.63s [-5.91%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 02:HASH JOIN | 59.04% | 3.71s | 3.98s | -6.81% | * 11.61% * | 5.36s | 6.43s | -16.69% | 1 | 1 | 0 | 12 | | 04:EXCHANGE | 9.82% | 616.86ms | 613.52ms | +0.54% | 2.24% | 660.77ms | 726.61ms | -9.06% | 1 | 1 | 59.99M | 6.00M | | F01:EXCHANGE SENDER | 29.19% | 1.83s | 1.78s | +3.23% | 0.60% | 2.02s | 1.95s | +3.40% | 3 | 3 | -1 | -1 | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TARGETED-PERF(10) PERF_AGG-Q9 [parquet / none / none] (20.84s -> 19.76s [-5.19%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 02:AGGREGATE | 3.82% | 817.93ms | 824.78ms | -0.83% | 0.92% | 844.25ms | 865.31ms | -2.43% | 3 | 3 | 49 | 21 | | 05:AGGREGATE | 19.76% | 4.23s | 4.42s | -4.29% | 6.85% | 6.88s | 5.21s | +32.01% | 3 | 3 | 59.41M | 73.97M | | 04:EXCHANGE | 2.63% | 564.12ms | 571.93ms | -1.37% | 0.79% | 585.57ms | 605.19ms | -3.24% | 3 | 3 | 79.90M | 73.97M | | F00:EXCHANGE SENDER | 35.03% | 7.50s | 7.52s | -0.23% | 0.58% | 8.06s | 8.09s | -0.46% | 3 | 3 | -1 | -1 | | 01:AGGREGATE | 38.03% | 8.15s | 8.94s | -8.89% | 4.80% | 11.64s | 12.80s | -9.00% | 3 | 3 | 79.90M | 73.97M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TARGETED-PERF(10) primitive_top-n_all [parquet / none / none] (15.05s -> 14.22s [-5.54%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | F00:EXCHANGE SENDER | 3.05% | 415.01ms | 412.65ms | +0.57% | 3.35% | 449.10ms | 449.89ms | -0.18% | 3 | 3 | -1 | -1 | | 01:TOP-N | 95.11% | 12.96s | 13.84s | -6.36% | 0.27% | 13.48s | 14.29s | -5.66% | 3 | 3 | 1.06M | 1.00M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TARGETED-PERF(10) primitive_topn_bigint [parquet / none / none] (1.37s -> 1.25s [-8.64%]) +----------+------------+----------+----------+------------+-----------+-------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +----------+------------+----------+----------+------------+-----------+-------+----------+------------+--------+-------+-------+-----------+ | 01:TOP-N | 90.35% | 859.33ms | 955.32ms | -10.05% | 2.47% | 1.09s | 1.19s | -7.72% | 3 | 3 | 2.44M | 1.00M | +----------+------------+----------+----------+------------+-----------+-------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TARGETED-PERF(10) primitive_decimal_arithmetic [parquet / none / none] (10.65s -> 9.88s [-7.25%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+-------+-----------+ | 01:AGGREGATE | 99.37% | 8.61s | 8.96s | -3.89% | 0.14% | 9.44s | 10.54s | -10.43% | 3 | 3 | 3 | 1 | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TARGETED-PERF(10) primitive_conjunct_ordering_5 [parquet / none / none] (2.89s -> 2.59s [-10.25%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | 02:SCAN HDFS | 64.32% | 2.22s | 2.50s | -11.24% | 1.87% | 2.56s | 2.84s | -9.89% | 2 | 2 | 120.27K | 37.95K | | 00:SCAN HDFS | 32.40% | 1.12s | 1.12s | -0.13% | 1.15% | 1.19s | 1.22s | -2.12% | 3 | 3 | 110.25K | 1.50M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TARGETED-PERF(10) primitive_shuffle_join_one_to_many_string_with_groupby [parquet / none / none] (17.87s -> 15.51s [-13.19%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 07:AGGREGATE | 3.17% | 701.73ms | 720.91ms | -2.66% | 1.83% | 753.72ms | 773.21ms | -2.52% | 3 | 3 | 0 | 14.90M | | F02:EXCHANGE SENDER | 5.03% | 1.11s | 1.12s | -0.28% | 1.60% | 1.17s | 1.18s | -0.22% | 3 | 3 | -1 | -1 | | 03:AGGREGATE | 18.13% | 4.01s | 4.63s | -13.30% | 1.30% | 4.20s | 4.78s | -12.24% | 3 | 3 | 15.00M | 14.90M | | 02:HASH JOIN | 39.92% | 8.84s | 10.56s | -16.31% | 1.24% | 9.28s | 10.94s | -15.16% | 3 | 3 | 59.99M | 59.99M | | F01:EXCHANGE SENDER | 5.96% | 1.32s | 1.52s | -13.42% | 2.66% | 1.56s | 1.78s | -12.45% | 3 | 3 | -1 | -1 | | F00:EXCHANGE SENDER | 22.81% | 5.05s | 5.81s | -13.16% | 1.28% | 5.60s | 6.54s | -14.36% | 3 | 3 | -1 | -1 | | 00:SCAN HDFS | 3.59% | 793.44ms | 752.30ms | +5.47% | 4.07% | 935.88ms | 882.61ms | +6.04% | 3 | 3 | 59.99M | 59.99M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_filter_string_selective [parquet / none / none] (18.86% -> 22.46%) +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | 01:AGGREGATE | 3.37% | 35.36% | 11.37% | +211.05% | 3 | 3 | 3 | 1 | | 00:SCAN HDFS | 95.90% | 12.47% | 16.33% | -23.63% | 3 | 3 | 196 | 6.00M | +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_conjunct_ordering_1 [parquet / none / none] (15.76% -> 14.31%) +---------------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | F00:EXCHANGE SENDER | 3.15% | 11.39% | 38.15% | -70.14% | 3 | 3 | -1 | -1 | | 00:SCAN HDFS | 95.51% | 14.33% | 12.98% | +10.35% | 3 | 3 | 0 | 1 | +---------------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_small_join_1 [parquet / none / none] (12.42% -> 13.83%) No Nodes with significant StdDev % (V) Significant Variability: TARGETED-PERF(10) primitive_filter_bigint_in_list [parquet / none / none] (14.59% -> 13.81%) No Nodes with significant StdDev % (V) Significant Variability: TARGETED-PERF(10) PERF_LIMIT-Q1 [parquet / none / none] (2.47% -> 13.59%) +-------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Inst | #Rows | Est #Rows | +-------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | F00:ROOT | 59.06% | 24.94% | 37.75% | -33.93% | 1 | 1 | -1 | -1 | | 00:EMPTYSET | 40.94% | 23.84% | 103.60% | -76.99% | 1 | 1 | 0 | 0 | +-------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_cancel_union [parquet / none / none] (8.42% -> 13.52%) +--------------+------------+-----------+----------------+------------------+--------+-------+---------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-----------+----------------+------------------+--------+-------+---------+-----------+ | 07:EXCHANGE | 26.82% | 36.40% | 40.51% | -10.14% | 3 | 3 | 119.34K | 1.56M | | 04:AGGREGATE | 48.56% | 30.88% | 37.58% | -17.82% | 3 | 3 | 122.14K | 1.56M | | 03:SCAN HDFS | 13.13% | 41.54% | 37.26% | +11.46% | 3 | 3 | 4.51M | 6.00M | | 01:SCAN HDFS | 9.86% | 164.88% | 50.78% | +224.69% | 1 | 1 | 10 | 15.00K | +--------------+------------+-----------+----------------+------------------+--------+-------+---------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_filter_decimal_selective [parquet / none / none] (14.74% -> 11.74%) +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | 00:SCAN HDFS | 99.60% | 12.94% | 13.18% | -1.83% | 3 | 3 | 70 | 6.00M | +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_groupby_decimal_lowndv.test [parquet / none / none] (7.46% -> 11.17%) No Nodes with significant StdDev % (V) Significant Variability: TARGETED-PERF(10) primitive_broadcast_join_1 [parquet / none / none] (9.66% -> 10.79%) +---------------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | 06:AGGREGATE | 5.72% | 28.87% | 34.48% | -16.28% | 1 | 1 | 1 | 1 | | F00:EXCHANGE SENDER | 2.51% | 24.18% | 23.16% | +4.38% | 3 | 3 | -1 | -1 | | 02:HASH JOIN | 28.43% | 24.36% | 29.67% | -17.90% | 3 | 3 | 0 | 600 | | F01:EXCHANGE SENDER | 3.01% | 51.16% | 43.54% | +17.52% | 1 | 1 | -1 | -1 | | 01:SCAN HDFS | 42.98% | 85.06% | 129.84% | -34.49% | 1 | 1 | 0 | 1 | | 00:SCAN HDFS | 15.33% | 31.16% | 30.57% | +1.93% | 3 | 3 | 0 | 59.99M | +---------------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ (V) Significant Variability: TARGETED-PERF(10) primitive_conjunct_ordering_4 [parquet / none / none] (11.20% -> 10.72%) No Nodes with significant StdDev % (V) Significant Variability: TARGETED-PERF(10) primitive_filter_decimal_non_selective [parquet / none / none] (12.74% -> 10.23%) No Nodes with significant StdDev % Significant perf change detected