Full Perf Run Report ==================================================================================================================================== Report Generated on 2016-09-03 Run Description: Nightly Perf Run - 16 Node CDH5 Cluster - tpch_300_decimal_parquet (Query Iterations: 3 Workload Iterations: 1 Num Clients: 1) Cluster Name: 16 Node CDH5 (vb0202) Lab Run Info: Private run [IMPALA-4026] Impala Version: impalad version 2.8.0-cdh5-INTERNAL RELEASE () Baseline Impala Version: impalad version 2.8.0-cdh5-INTERNAL RELEASE (2016-09-01) +------------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +------------+-----------------------+---------+------------+------------+----------------+ | TPCH(_300) | parquet / none / none | 33.67 | +3.37% | 17.02 | +1.28% | +------------+-----------------------+---------+------------+------------+----------------+ +------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | TPCH(_300) | TPCH-Q3 | parquet / none / none | 35.72 | 29.63 | R +20.56% | 0.88% | 0.44% | 1 | 3 | | TPCH(_300) | TPCH-Q4 | parquet / none / none | 28.43 | 24.40 | R +16.49% | 0.50% | 0.03% | 1 | 3 | | TPCH(_300) | TPCH-Q21 | parquet / none / none | 123.60 | 113.42 | +8.97% | 2.08% | 3.83% | 1 | 3 | | TPCH(_300) | TPCH-Q7 | parquet / none / none | 71.77 | 67.00 | +7.12% | 1.32% | 0.67% | 1 | 3 | | TPCH(_300) | TPCH-Q18 | parquet / none / none | 59.28 | 56.84 | +4.30% | 2.77% | 1.05% | 1 | 3 | | TPCH(_300) | TPCH-Q1 | parquet / none / none | 20.52 | 19.84 | +3.38% | 0.26% | 1.24% | 1 | 3 | | TPCH(_300) | TPCH-Q8 | parquet / none / none | 10.21 | 9.94 | +2.71% | 0.05% | 0.76% | 1 | 3 | | TPCH(_300) | TPCH-Q9 | parquet / none / none | 33.85 | 33.23 | +1.87% | 1.12% | 3.64% | 1 | 3 | | TPCH(_300) | TPCH-Q10 | parquet / none / none | 20.62 | 20.26 | +1.79% | 0.44% | 0.60% | 1 | 3 | | TPCH(_300) | TPCH-Q12 | parquet / none / none | 14.06 | 13.85 | +1.51% | 1.09% | 0.36% | 1 | 3 | | TPCH(_300) | TPCH-Q6 | parquet / none / none | 2.02 | 2.00 | +1.23% | 0.01% | 1.26% | 1 | 3 | | TPCH(_300) | TPCH-Q5 | parquet / none / none | 49.39 | 48.91 | +0.98% | 0.68% | 1.48% | 1 | 3 | | TPCH(_300) | TPCH-Q19 | parquet / none / none | 130.66 | 129.95 | +0.54% | 3.19% | 2.55% | 1 | 3 | | TPCH(_300) | TPCH-Q22 | parquet / none / none | 6.91 | 6.90 | +0.26% | 0.62% | 1.24% | 1 | 3 | | TPCH(_300) | TPCH-Q20 | parquet / none / none | 4.41 | 4.43 | -0.47% | 0.69% | 1.42% | 1 | 3 | | TPCH(_300) | TPCH-Q14 | parquet / none / none | 5.03 | 5.08 | -1.01% | 1.98% | 0.10% | 1 | 3 | | TPCH(_300) | TPCH-Q13 | parquet / none / none | 23.94 | 24.47 | -2.14% | 3.98% | 0.08% | 1 | 3 | | TPCH(_300) | TPCH-Q11 | parquet / none / none | 2.40 | 2.46 | -2.39% | 0.09% | 0.19% | 1 | 3 | | TPCH(_300) | TPCH-Q17 | parquet / none / none | 83.22 | 87.87 | -5.29% | 0.92% | 2.82% | 1 | 3 | | TPCH(_300) | TPCH-Q2 | parquet / none / none | 4.21 | 4.46 | -5.63% | 1.71% | 0.65% | 1 | 3 | | TPCH(_300) | TPCH-Q16 | parquet / none / none | 6.11 | 6.58 | -7.16% | 0.41% | 0.79% | 1 | 3 | | TPCH(_300) | TPCH-Q15 | parquet / none / none | 4.45 | 5.17 | -13.89% | 2.74% | 0.40% | 1 | 3 | +------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ (R) Regression: TPCH(_300) TPCH-Q3 [parquet / none / none] (29.63s -> 35.72s [+20.56%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ | 03:HASH JOIN | 46.23% | 7.84s | 7.94s | -1.32% | 1.36% | 8.91s | 8.54s | +4.25% | 15 | 22.69M | 18.00M | | 08:EXCHANGE | 2.55% | 431.74ms | 500.33ms | -13.71% | 5.18% | 980.01ms | 978.60ms | +0.14% | 15 | 110.51M | 45.00M | | 01:SCAN HDFS | 4.98% | 844.58ms | 859.79ms | -1.77% | 0.89% | 887.33ms | 890.30ms | -0.33% | 15 | 110.51M | 45.00M | | 07:EXCHANGE | 32.80% | 5.56s | 6.03s | -7.70% | 0.97% | 8.07s | 8.66s | -6.72% | 15 | 970.33M | 180.00M | | 02:SCAN HDFS | 7.35% | 1.25s | 1.32s | -5.79% | 0.24% | 1.27s | 1.40s | -9.24% | 15 | 970.33M | 180.00M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ (R) Regression: TPCH(_300) TPCH-Q4 [parquet / none / none] (24.40s -> 28.43s [+16.49%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+---------+-----------+ | 03:AGGREGATE | 9.03% | 1.17s | 1.28s | -8.64% | 0.61% | 1.33s | 1.43s | -6.65% | 15 | 75 | 5 | | 02:HASH JOIN | 37.66% | 4.87s | 5.36s | -9.13% | 0.26% | 5.69s | 6.11s | -6.77% | 15 | 15.78M | 45.00M | | 05:EXCHANGE | 42.23% | 5.46s | 7.39s | -26.10% | 5.08% | 9.19s | 10.69s | -14.02% | 15 | 810.75M | 180.00M | | 01:SCAN HDFS | 9.24% | 1.19s | 1.38s | -13.68% | 0.21% | 1.22s | 1.60s | -24.22% | 15 | 810.75M | 180.00M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+---------+-----------+ Significant perf change detected ==================================================================================================================================== Report Generated on 2016-09-03 Run Description: Nightly Perf Run - 16 Node CDH5 Cluster - Primitives tpch_300_decimal_parquet (Query Iterations: 3 Workload Iterations: 1 Num Clients: 1) Cluster Name: 16 Node CDH5 (vb0202) Lab Run Info: Private run [IMPALA-4026] Impala Version: impalad version 2.8.0-cdh5-INTERNAL RELEASE () Baseline Impala Version: impalad version 2.8.0-cdh5-INTERNAL RELEASE (2016-09-01) +---------------------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +---------------------+-----------------------+---------+------------+------------+----------------+ | TARGETED-PERF(_300) | parquet / none / none | 35.03 | -3.77% | 9.71 | -4.94% | +---------------------+-----------------------+---------+------------+------------+----------------+ +---------------------+--------------------------------------------------------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +---------------------+--------------------------------------------------------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | TARGETED-PERF(_300) | primitive_conjunct_ordering_1 | parquet / none / none | 10.68 | 9.84 | +8.47% | 0.76% | 0.53% | 1 | 3 | | TARGETED-PERF(_300) | primitive_filter_string_selective | parquet / none / none | 1.09 | 1.01 | +7.43% | 2.34% | 4.91% | 1 | 3 | | TARGETED-PERF(_300) | primitive_filter_bigint_selective | parquet / none / none | 0.69 | 0.67 | +3.78% | 3.54% | 0.09% | 1 | 3 | | TARGETED-PERF(_300) | primitive_broadcast_join_2 | parquet / none / none | 5.91 | 5.71 | +3.56% | 0.04% | 0.96% | 1 | 3 | | TARGETED-PERF(_300) | primitive_empty_build_join_1 | parquet / none / none | 13.48 | 13.07 | +3.11% | 1.28% | 0.98% | 1 | 3 | | TARGETED-PERF(_300) | primitive_exchange_shuffle | parquet / none / none | 82.37 | 80.02 | +2.93% | 2.38% | 1.07% | 1 | 3 | | TARGETED-PERF(_300) | primitive_filter_string_like | parquet / none / none | 5.81 | 5.74 | +1.31% | 3.01% | 1.76% | 1 | 3 | | TARGETED-PERF(_300) | primitive_conjunct_ordering_3 | parquet / none / none | 1.55 | 1.53 | +1.23% | 1.27% | 0.07% | 1 | 3 | | TARGETED-PERF(_300) | primitive_broadcast_join_1 | parquet / none / none | 1.68 | 1.66 | +1.13% | 0.20% | 1.43% | 1 | 3 | | TARGETED-PERF(_300) | primitive_filter_decimal_selective | parquet / none / none | 0.89 | 0.88 | +1.04% | 2.89% | 2.69% | 1 | 3 | | TARGETED-PERF(_300) | primitive_broadcast_join_3 | parquet / none / none | 59.21 | 58.73 | +0.81% | 0.68% | 0.27% | 1 | 3 | | TARGETED-PERF(_300) | primitive_filter_string_non_selective | parquet / none / none | 0.99 | 0.99 | +0.60% | 2.60% | 2.46% | 1 | 3 | | TARGETED-PERF(_300) | primitive_conjunct_ordering_4 | parquet / none / none | 1.19 | 1.18 | +0.22% | 0.24% | 0.01% | 1 | 3 | | TARGETED-PERF(_300) | primitive_groupby_bigint_pk | parquet / none / none | 88.72 | 89.41 | -0.77% | 0.73% | 1.74% | 1 | 3 | | TARGETED-PERF(_300) | primitive_top-n_all | parquet / none / none | 35.53 | 35.89 | -0.99% | 1.28% | 0.26% | 1 | 3 | | TARGETED-PERF(_300) | primitive_groupby_bigint_highndv | parquet / none / none | 23.49 | 23.78 | -1.22% | 1.72% | 1.27% | 1 | 3 | | TARGETED-PERF(_300) | primitive_orderby_all | parquet / none / none | 114.11 | 116.47 | -2.03% | 0.07% | 2.14% | 1 | 3 | | TARGETED-PERF(_300) | primitive_exchange_broadcast | parquet / none / none | 85.26 | 88.32 | -3.46% | 2.03% | 1.02% | 1 | 3 | | TARGETED-PERF(_300) | primitive_groupby_decimal_lowndv.test | parquet / none / none | 3.47 | 3.62 | -4.16% | 0.69% | 0.72% | 1 | 3 | | TARGETED-PERF(_300) | primitive_orderby_bigint | parquet / none / none | 31.17 | 32.55 | -4.24% | 0.01% | 0.94% | 1 | 3 | | TARGETED-PERF(_300) | primitive_groupby_bigint_lowndv | parquet / none / none | 3.42 | 3.59 | -4.87% | 0.74% | 0.04% | 1 | 3 | | TARGETED-PERF(_300) | primitive_groupby_decimal_highndv | parquet / none / none | 25.33 | 26.76 | -5.34% | 2.68% | 4.73% | 1 | 3 | | TARGETED-PERF(_300) | primitive_shuffle_join_one_to_many_string_with_groupby | parquet / none / none | 231.20 | 244.67 | -5.51% | 0.83% | 0.74% | 1 | 3 | | TARGETED-PERF(_300) | primitive_topn_bigint | parquet / none / none | 4.96 | 5.28 | -6.09% | 0.93% | 0.98% | 1 | 3 | | TARGETED-PERF(_300) | primitive_conjunct_ordering_2 | parquet / none / none | 74.16 | 78.98 | -6.11% | 1.56% | 2.23% | 1 | 3 | | TARGETED-PERF(_300) | primitive_shuffle_join_union_all_with_groupby | parquet / none / none | 76.48 | 83.63 | -8.55% | 0.37% | 1.21% | 1 | 3 | | TARGETED-PERF(_300) | primitive_conjunct_ordering_5 | parquet / none / none | 31.39 | 38.93 | -19.37% | 2.87% | 1.02% | 1 | 3 | | TARGETED-PERF(_300) | primitive_filter_decimal_non_selective | parquet / none / none | 0.87 | 1.12 | I -22.34% | 5.72% | 0.08% | 1 | 3 | | TARGETED-PERF(_300) | primitive_filter_bigint_non_selective | parquet / none / none | 0.72 | 1.60 | I -55.10% | 0.01% | 1.53% | 1 | 3 | +---------------------+--------------------------------------------------------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ (I) Improvement: TARGETED-PERF(_300) primitive_filter_decimal_non_selective [parquet / none / none] (1.12s -> 0.87s [-22.34%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-----------+ | 01:AGGREGATE | 29.95% | 215.90ms | 212.45ms | +1.62% | 2.37% | 283.94ms | 289.32ms | -1.86% | 15 | 15 | 1 | | 00:SCAN HDFS | 63.80% | 459.98ms | 554.36ms | -17.03% | 1.76% | 521.24ms | 778.23ms | -33.02% | 15 | 1.80B | 180.00M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-----------+ (I) Improvement: TARGETED-PERF(_300) primitive_filter_bigint_non_selective [parquet / none / none] (1.60s -> 0.72s [-55.10%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-----------+ | 01:AGGREGATE | 38.53% | 230.42ms | 294.13ms | -21.66% | 2.46% | 285.66ms | 332.22ms | -14.02% | 15 | 15 | 1 | | 00:SCAN HDFS | 54.07% | 323.42ms | 1.09s | -70.34% | 0.90% | 367.06ms | 1.20s | -69.36% | 15 | 1.80B | 180.00M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-----------+ Significant perf change detected ==================================================================================================================================== Report Generated on 2016-09-03 Run Description: Nightly Perf Run - 16 Node CDH5 Cluster - tpcds_1000_decimal_parquet (Query Iterations: 3 Workload Iterations: 1 Num Clients: 1) Cluster Name: 16 Node CDH5 (vb0202) Lab Run Info: Private run [IMPALA-4026] Impala Version: impalad version 2.8.0-cdh5-INTERNAL RELEASE () Baseline Impala Version: impalad version 2.8.0-cdh5-INTERNAL RELEASE (2016-09-01) +--------------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +--------------+-----------------------+---------+------------+------------+----------------+ | TPCDS(_1000) | parquet / none / none | 8.68 | +2.11% | 3.62 | +1.29% | +--------------+-----------------------+---------+------------+------------+----------------+ +--------------+-----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +--------------+-----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | TPCDS(_1000) | TPCDS-Q59 | parquet / none / none | 6.80 | 5.98 | +13.86% | 0.40% | 0.96% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q47 | parquet / none / none | 37.41 | 34.04 | +9.90% | 0.63% | 0.36% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q5 | parquet / none / none | 12.77 | 11.71 | +9.07% | 8.09% | 0.98% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q64 | parquet / none / none | 27.30 | 25.89 | +5.46% | 0.19% | 0.52% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q53 | parquet / none / none | 1.57 | 1.49 | +5.18% | 1.92% | 0.28% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q61 | parquet / none / none | 2.34 | 2.26 | +3.17% | 0.26% | 1.03% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q55 | parquet / none / none | 0.95 | 0.93 | +2.34% | 0.06% | 1.83% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q42 | parquet / none / none | 0.92 | 0.90 | +2.33% | 2.74% | 0.47% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q3 | parquet / none / none | 1.17 | 1.15 | +2.23% | 0.09% | 2.03% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q89 | parquet / none / none | 2.55 | 2.50 | +1.84% | 0.95% | 0.91% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q46 | parquet / none / none | 3.18 | 3.13 | +1.69% | 1.05% | 0.63% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q88 | parquet / none / none | 15.59 | 15.44 | +0.96% | 1.71% | 3.25% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q19 | parquet / none / none | 3.22 | 3.19 | +0.90% | 0.82% | 0.05% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q96 | parquet / none / none | 3.24 | 3.21 | +0.87% | 0.94% | 0.38% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q8 | parquet / none / none | 1.80 | 1.79 | +0.74% | 0.06% | 3.84% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q98 | parquet / none / none | 1.62 | 1.62 | -0.02% | 0.11% | 0.06% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q43 | parquet / none / none | 4.12 | 4.12 | -0.05% | 1.24% | 1.18% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q7 | parquet / none / none | 1.93 | 1.93 | -0.10% | 1.44% | 1.02% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q65 | parquet / none / none | 29.01 | 29.05 | -0.16% | 1.02% | 0.68% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q52 | parquet / none / none | 0.95 | 0.95 | -0.21% | 0.01% | 0.11% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q27 | parquet / none / none | 1.95 | 1.97 | -0.97% | 1.55% | 0.08% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q68 | parquet / none / none | 2.08 | 2.12 | -2.06% | 1.54% | 0.50% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q6 | parquet / none / none | 63.28 | 65.13 | -2.84% | 0.41% | 0.92% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q63 | parquet / none / none | 1.50 | 1.55 | -2.94% | 0.06% | 0.05% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q73 | parquet / none / none | 1.30 | 1.36 | -4.16% | 1.82% | 1.42% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q34 | parquet / none / none | 2.88 | 3.01 | -4.25% | 0.81% | 2.16% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q79 | parquet / none / none | 2.98 | 3.16 | -5.44% | 0.78% | 3.57% | 1 | 3 | +--------------+-----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ ==================================================================================================================================== Report Generated on 2016-09-03 Run Description: Nightly Perf Run - 16 Node CDH5 Cluster - tpch_nested_300_parquet (Query Iterations: 3 Workload Iterations: 1 Num Clients: 1) Cluster Name: 16 Node CDH5 (vb0202) Lab Run Info: Private run [IMPALA-4026] Impala Version: impalad version 2.8.0-cdh5-INTERNAL RELEASE () Baseline Impala Version: impalad version 2.8.0-cdh5-INTERNAL RELEASE (2016-09-01) +-------------------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +-------------------+-----------------------+---------+------------+------------+----------------+ | TPCH_NESTED(_300) | parquet / none / none | 34.31 | -4.12% | 13.76 | -3.43% | +-------------------+-----------------------+---------+------------+------------+----------------+ +-------------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +-------------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | TPCH_NESTED(_300) | TPCH-Q5 | parquet / none / none | 8.05 | 7.81 | +2.96% | 0.31% | 0.65% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q12 | parquet / none / none | 7.57 | 7.39 | +2.43% | 4.32% | 1.37% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q3 | parquet / none / none | 8.41 | 8.23 | +2.16% | 0.09% | 0.94% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q1 | parquet / none / none | 20.85 | 20.52 | +1.57% | 0.12% | 1.62% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q4 | parquet / none / none | 6.59 | 6.51 | +1.16% | 1.54% | 0.36% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q14 | parquet / none / none | 5.49 | 5.49 | +0.05% | 0.40% | 2.29% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q19 | parquet / none / none | 137.71 | 137.92 | -0.15% | 0.78% | 1.32% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q6 | parquet / none / none | 2.98 | 2.98 | -0.17% | 5.09% | 0.09% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q22 | parquet / none / none | 1.30 | 1.30 | -0.54% | 2.19% | 1.34% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q20 | parquet / none / none | 14.79 | 15.02 | -1.54% | 0.32% | 1.87% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q9 | parquet / none / none | 202.79 | 206.23 | -1.67% | 0.35% | 0.06% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q11 | parquet / none / none | 2.57 | 2.63 | -2.36% | 1.04% | 0.00% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q21 | parquet / none / none | 45.37 | 46.67 | -2.79% | 2.23% | 3.48% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q15 | parquet / none / none | 6.44 | 6.66 | -3.36% | 0.59% | 0.11% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q10 | parquet / none / none | 9.53 | 9.97 | -4.41% | 0.01% | 3.02% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q16 | parquet / none / none | 14.47 | 15.39 | -6.00% | 1.52% | 1.17% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q17 | parquet / none / none | 121.89 | 129.79 | -6.09% | 1.73% | 1.42% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q8 | parquet / none / none | 10.25 | 11.06 | -7.33% | 1.22% | 4.13% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q2 | parquet / none / none | 5.11 | 5.60 | -8.90% | 0.35% | 0.73% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q7 | parquet / none / none | 46.17 | 52.15 | -11.47% | 2.41% | 2.75% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q18 | parquet / none / none | 67.63 | 77.67 | -12.92% | 0.62% | 3.07% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q13 | parquet / none / none | 8.94 | 10.33 | -13.44% | 1.47% | 0.53% | 1 | 3 | +-------------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ ==================================================================================================================================== Report Generated on 2016-09-03 Run Description: Nightly Perf Run - 16 Node CDH5 Cluster - tpcds_1000_decimal_parquet un-modified queries (Query Iterations: 3 Workload Iterations: 1 Num Clients: 1) Cluster Name: 16 Node CDH5 (vb0202) Lab Run Info: Private run [IMPALA-4026] Impala Version: impalad version 2.8.0-cdh5-INTERNAL RELEASE () Baseline Impala Version: impalad version 2.8.0-cdh5-INTERNAL RELEASE (2016-09-01) +-------------------------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +-------------------------+-----------------------+---------+------------+------------+----------------+ | TPCDS-UNMODIFIED(_1000) | parquet / none / none | 20.91 | -1.28% | 7.27 | +0.03% | +-------------------------+-----------------------+---------+------------+------------+----------------+ +-------------------------+-----------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +-------------------------+-----------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ | TPCDS-UNMODIFIED(_1000) | TPCDS-Q74 | parquet / none / none | 24.25 | 21.16 | +14.57% | 1.88% | 2.51% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q59 | parquet / none / none | 6.86 | 6.00 | +14.34% | 3.08% | 0.21% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q25 | parquet / none / none | 10.54 | 9.30 | +13.29% | 0.93% | 1.14% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q20 | parquet / none / none | 1.80 | 1.59 | R +13.08% | 0.02% | 0.00% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q13 | parquet / none / none | 23.05 | 20.38 | +13.07% | 0.99% | 3.57% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q43 | parquet / none / none | 5.48 | 4.84 | +13.05% | 0.89% | 3.73% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q32 | parquet / none / none | 2.10 | 1.87 | +12.07% | 0.05% | 1.43% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q33 | parquet / none / none | 3.08 | 2.82 | +9.37% | 0.89% | 1.04% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q89 | parquet / none / none | 3.64 | 3.33 | +9.36% | 1.01% | 1.49% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q90 | parquet / none / none | 2.28 | 2.09 | +8.92% | * 10.13% * | 1.14% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q99 | parquet / none / none | 9.37 | 8.62 | +8.71% | 0.02% | 1.12% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q39 | parquet / none / none | 9.57 | 8.87 | +7.94% | 1.85% | 1.21% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q77 | parquet / none / none | 4.65 | 4.31 | +7.91% | 3.85% | 2.41% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q47 | parquet / none / none | 41.24 | 38.35 | +7.53% | 0.56% | 0.25% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q31 | parquet / none / none | 7.36 | 6.88 | +7.00% | 0.36% | 0.91% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q1 | parquet / none / none | 4.11 | 3.86 | +6.46% | 2.75% | 2.76% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q57 | parquet / none / none | 22.30 | 21.08 | +5.81% | 2.39% | 2.41% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q42 | parquet / none / none | 1.12 | 1.07 | +4.74% | 0.34% | 0.30% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q7 | parquet / none / none | 2.82 | 2.70 | +4.45% | 0.91% | 0.10% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q21 | parquet / none / none | 6.64 | 6.39 | +3.95% | 0.01% | 0.02% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q58 | parquet / none / none | 2.67 | 2.57 | +3.89% | 0.21% | 0.33% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q81 | parquet / none / none | 4.12 | 3.99 | +3.35% | 1.89% | 0.94% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q23 | parquet / none / none | 129.54 | 125.90 | +2.89% | 2.26% | 0.82% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q64 | parquet / none / none | 20.99 | 20.43 | +2.77% | 0.78% | 0.36% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q44 | parquet / none / none | 6.38 | 6.21 | +2.73% | 0.32% | 0.60% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q69 | parquet / none / none | 4.58 | 4.47 | +2.38% | 0.59% | 4.15% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q54 | parquet / none / none | 8.95 | 8.74 | +2.37% | 0.87% | 0.69% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q22 | parquet / none / none | 61.69 | 60.26 | +2.36% | 1.73% | 3.98% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q86 | parquet / none / none | 6.09 | 5.95 | +2.29% | 6.28% | 4.43% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q52 | parquet / none / none | 1.12 | 1.10 | +2.03% | 4.22% | 2.76% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q92 | parquet / none / none | 1.52 | 1.49 | +1.94% | 1.48% | 0.52% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q78 | parquet / none / none | 182.34 | 178.89 | +1.93% | 0.43% | 0.05% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q38 | parquet / none / none | 45.63 | 44.79 | +1.86% | 1.16% | 0.00% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q37 | parquet / none / none | 5.77 | 5.67 | +1.62% | 0.87% | 0.09% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q80 | parquet / none / none | 9.61 | 9.47 | +1.54% | 2.06% | 0.49% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q19 | parquet / none / none | 1.81 | 1.78 | +1.52% | 0.34% | 0.19% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q82 | parquet / none / none | 6.00 | 5.92 | +1.45% | 1.33% | 0.94% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q41 | parquet / none / none | 1.42 | 1.40 | +1.21% | 1.21% | 0.06% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q94 | parquet / none / none | 4.18 | 4.14 | +0.92% | 0.48% | 0.04% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q66 | parquet / none / none | 4.24 | 4.20 | +0.92% | 1.77% | 0.14% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q35 | parquet / none / none | 6.53 | 6.48 | +0.79% | 1.47% | 3.32% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q40 | parquet / none / none | 2.68 | 2.67 | +0.63% | 1.03% | 1.94% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q3 | parquet / none / none | 1.48 | 1.47 | +0.63% | 0.26% | 0.08% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q49 | parquet / none / none | 7.15 | 7.11 | +0.55% | 1.54% | 1.58% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q91 | parquet / none / none | 1.38 | 1.38 | +0.53% | 1.91% | 1.56% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q12 | parquet / none / none | 1.57 | 1.56 | +0.48% | 0.00% | 0.62% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q95 | parquet / none / none | 10.38 | 10.33 | +0.47% | 2.47% | 2.54% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q61 | parquet / none / none | 2.11 | 2.10 | +0.46% | 0.13% | 0.15% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q28 | parquet / none / none | 9.90 | 9.86 | +0.39% | 0.34% | 1.51% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q83 | parquet / none / none | 2.09 | 2.08 | +0.36% | 1.56% | 0.13% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q96 | parquet / none / none | 3.26 | 3.26 | +0.13% | 0.38% | 0.54% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q93 | parquet / none / none | 62.54 | 62.49 | +0.09% | 0.83% | 1.15% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q63 | parquet / none / none | 2.02 | 2.02 | -0.10% | 1.53% | 1.31% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q76 | parquet / none / none | 7.67 | 7.69 | -0.19% | 0.98% | 0.71% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q27 | parquet / none / none | 4.27 | 4.29 | -0.48% | 1.60% | 0.60% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q56 | parquet / none / none | 2.14 | 2.15 | -0.54% | 0.83% | 0.73% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q16 | parquet / none / none | 6.55 | 6.60 | -0.67% | 2.45% | 0.60% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q84 | parquet / none / none | 34.61 | 34.90 | -0.84% | 2.35% | 0.00% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q79 | parquet / none / none | 6.05 | 6.10 | -0.87% | 1.77% | 2.31% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q62 | parquet / none / none | 4.70 | 4.74 | -0.89% | 0.58% | 0.55% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q46 | parquet / none / none | 2.54 | 2.57 | -1.07% | 0.43% | 0.01% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q8 | parquet / none / none | 2.59 | 2.62 | -1.15% | 0.26% | 0.68% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q30 | parquet / none / none | 2.87 | 2.90 | -1.20% | 3.02% | 4.03% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q5 | parquet / none / none | 12.58 | 12.76 | -1.41% | 5.39% | 9.13% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q4 | parquet / none / none | 36.03 | 36.65 | -1.69% | 0.54% | 0.63% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q65 | parquet / none / none | 33.83 | 34.49 | -1.90% | 1.02% | 4.18% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q26 | parquet / none / none | 2.32 | 2.37 | -1.99% | 1.13% | 1.44% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q75 | parquet / none / none | 28.26 | 28.88 | -2.14% | 0.16% | 2.35% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q48 | parquet / none / none | 1.83 | 1.87 | -2.15% | 1.41% | 0.13% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q15 | parquet / none / none | 6.34 | 6.48 | -2.17% | 2.03% | 0.02% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q14 | parquet / none / none | 168.88 | 172.83 | -2.29% | 0.06% | 0.45% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q98 | parquet / none / none | 3.78 | 3.87 | -2.33% | 0.32% | 0.30% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q2 | parquet / none / none | 7.89 | 8.09 | -2.48% | 0.66% | 0.10% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q53 | parquet / none / none | 2.10 | 2.15 | -2.57% | 4.58% | 2.73% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q68 | parquet / none / none | 2.05 | 2.10 | -2.69% | 1.11% | 0.38% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q6 | parquet / none / none | 63.18 | 64.94 | -2.72% | 1.36% | 0.57% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q50 | parquet / none / none | 10.84 | 11.19 | -3.06% | 1.57% | 0.15% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q72 | parquet / none / none | 486.57 | 502.05 | -3.08% | 1.30% | 0.73% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q70 | parquet / none / none | 16.46 | 16.99 | -3.13% | 0.96% | 2.57% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q9 | parquet / none / none | 6.27 | 6.48 | -3.26% | 0.60% | 0.76% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q85 | parquet / none / none | 13.09 | 13.62 | -3.89% | 2.28% | 1.76% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q45 | parquet / none / none | 1.69 | 1.76 | -4.00% | 1.42% | 5.36% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q55 | parquet / none / none | 1.07 | 1.12 | -4.00% | 0.55% | 0.00% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q97 | parquet / none / none | 35.26 | 36.84 | -4.30% | 0.34% | 4.79% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q17 | parquet / none / none | 20.56 | 21.55 | -4.61% | 2.04% | 0.38% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q88 | parquet / none / none | 15.03 | 15.85 | -5.21% | 1.23% | 2.66% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q51 | parquet / none / none | 37.26 | 39.41 | -5.45% | 0.53% | 0.43% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q11 | parquet / none / none | 30.06 | 31.92 | -5.84% | 0.19% | 2.63% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q71 | parquet / none / none | 5.83 | 6.23 | -6.38% | 7.30% | 0.41% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q18 | parquet / none / none | 8.04 | 8.59 | -6.44% | 0.19% | 1.37% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q73 | parquet / none / none | 2.32 | 2.48 | -6.81% | 0.29% | 0.80% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q34 | parquet / none / none | 2.80 | 3.02 | -7.27% | 0.15% | 1.92% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q87 | parquet / none / none | 21.07 | 22.89 | -7.93% | 0.13% | 2.16% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q29 | parquet / none / none | 12.38 | 13.45 | -7.97% | 0.90% | 1.42% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q60 | parquet / none / none | 4.09 | 4.59 | -11.02% | 0.51% | 0.82% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q10 | parquet / none / none | 33.05 | 40.95 | I -19.29% | 0.13% | 1.15% | 1 | 3 | | TPCDS-UNMODIFIED(_1000) | TPCDS-Q36 | parquet / none / none | 7.05 | 15.47 | I -54.44% | 4.34% | * 61.82% * | 1 | 3 | +-------------------------+-----------+-----------------------+--------+-------------+------------+------------+----------------+-------------+-------+ (R) Regression: TPCDS-UNMODIFIED(_1000) TPCDS-Q20 [parquet / none / none] (1.59s -> 1.80s [+13.08%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ | 12:AGGREGATE | 11.66% | 65.02ms | 65.82ms | -1.21% | 0.25% | 125.70ms | 97.65ms | +28.72% | 15 | 44.88K | 387.30M | | 05:AGGREGATE | 36.29% | 202.34ms | 202.18ms | +0.08% | 0.27% | 514.20ms | 372.83ms | +37.92% | 15 | 576.16K | 387.30M | | 03:HASH JOIN | 16.85% | 93.98ms | 94.87ms | -0.93% | 0.14% | 179.54ms | 139.27ms | +28.91% | 15 | 4.07M | 387.30M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+---------+-----------+ (I) Improvement: TPCDS-UNMODIFIED(_1000) TPCDS-Q10 [parquet / none / none] (40.95s -> 33.05s [-19.29%]) +--------------+------------+----------+----------+------------+-----------+--------+----------+------------+--------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+--------+----------+------------+--------+---------+-----------+ | 16:HASH JOIN | 9.30% | 3.17s | 3.56s | -10.91% | 1.29% | 3.87s | 4.03s | -4.18% | 13 | 8.79M | 2.41K | | 27:EXCHANGE | 2.62% | 892.27ms | 731.17ms | +22.03% | 4.58% | 1.15s | 1.02s | +13.24% | 13 | 117.90M | 2.43K | | 14:HASH JOIN | 45.52% | 15.51s | 19.93s | -22.20% | 1.45% | 17.19s | 23.35s | -26.38% | 13 | 9.08M | 744.36K | | 13:HASH JOIN | 24.85% | 8.47s | 10.29s | -17.70% | 0.83% | 9.04s | 11.06s | -18.21% | 13 | 1.01B | 773.86K | | 12:HASH JOIN | 5.76% | 1.96s | 2.34s | -16.14% | 0.68% | 2.15s | 2.49s | -13.85% | 13 | 451.43M | 11.97M | | 00:SCAN HDFS | 3.13% | 1.07s | 1.08s | -0.80% | 0.50% | 1.10s | 1.10s | -0.70% | 13 | 108.79K | 12.00M | +--------------+------------+----------+----------+------------+-----------+--------+----------+------------+--------+---------+-----------+ (I) Improvement: TPCDS-UNMODIFIED(_1000) TPCDS-Q36 [parquet / none / none] (15.47s -> 7.05s [-54.44%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+--------+-----------+ | 16:AGGREGATE | 14.19% | 1.62s | 1.45s | +12.24% | 2.86% | 2.41s | 2.08s | +15.93% | 15 | 2.76K | 1.10K | | 15:HASH JOIN | 9.82% | 1.12s | 1.10s | +2.32% | 5.02% | 1.52s | 1.70s | -10.43% | 15 | 98.12M | 412.09M | | 14:HASH JOIN | 2.34% | 267.93ms | 252.59ms | +6.07% | 0.85% | 421.03ms | 314.13ms | +34.03% | 15 | 98.12M | 417.85M | | 13:HASH JOIN | 3.39% | 388.72ms | 364.96ms | +6.51% | 0.53% | 603.53ms | 486.12ms | +24.15% | 15 | 98.12M | 588.94M | | 25:AGGREGATE | 14.40% | 1.65s | 1.47s | +12.17% | 2.97% | 2.81s | 2.07s | +35.58% | 15 | 2.76K | 1.10K | | 24:HASH JOIN | 9.95% | 1.14s | 1.10s | +3.19% | 5.00% | 2.14s | 1.81s | +18.12% | 15 | 98.12M | 412.09M | | 23:HASH JOIN | 2.37% | 271.49ms | 259.19ms | +4.74% | 0.92% | 438.24ms | 349.38ms | +25.44% | 15 | 98.12M | 417.85M | | 22:HASH JOIN | 3.39% | 388.50ms | 367.87ms | +5.61% | 0.76% | 630.12ms | 493.96ms | +27.56% | 15 | 98.12M | 588.94M | | 08:AGGREGATE | 14.25% | 1.63s | 2.08s | -21.70% | 0.10% | 2.44s | 21.39s | -88.58% | 15 | 2.76K | 1.10K | | 07:HASH JOIN | 9.99% | 1.14s | 1.06s | +7.49% | 0.13% | 1.67s | 1.75s | -4.30% | 15 | 98.12M | 412.09M | | 06:HASH JOIN | 2.36% | 269.81ms | 254.32ms | +6.09% | 0.50% | 432.93ms | 323.60ms | +33.79% | 15 | 98.12M | 417.85M | | 05:HASH JOIN | 3.38% | 386.74ms | 372.99ms | +3.68% | 1.13% | 616.63ms | 497.24ms | +24.01% | 15 | 98.12M | 588.94M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+--------+-----------+ (V) Significant Variability: TPCDS-UNMODIFIED(_1000) TPCDS-Q90 [parquet / none / none] (1.14% -> 10.13%) No Nodes with significant StdDev % Significant perf change detected