Report Generated on 2022-03-15 Run Description: "ca48b940ec6281d492ad525418f234308a82eedf vs c2dda6ee3b05fbae5d0ad3510e711409ee1baa7f" Cluster Name: UNKNOWN Lab Run Info: UNKNOWN Impala Version: impalad version 4.1.0-SNAPSHOT RELEASE (2022-03-15) Baseline Impala Version: impalad version 4.1.0-SNAPSHOT RELEASE (2022-03-14) +-----------+--------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +-----------+--------------------+---------+------------+------------+----------------+ | TPCDS(42) | orc / snap / block | 8.43 | -1.89% | 4.08 | -1.58% | +-----------+--------------------+---------+------------+------------+----------------+ +-----------+-------------+--------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+--------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Iters | Median Diff(%) | MW Zval | Tval | +-----------+-------------+--------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+--------+ | TPCDS(42) | TPCDS-Q42 | orc / snap / block | 0.85 | 0.82 | +3.39% | 2.98% | 4.91% | 20 | +5.41% | 2.15 | 2.62 | | TPCDS(42) | TPCDS-Q27 | orc / snap / block | 2.72 | 2.63 | +3.47% | 0.86% | 1.30% | 20 | +3.64% | 5.15 | 9.82 | | TPCDS(42) | TPCDS-Q43 | orc / snap / block | 1.37 | 1.34 | +2.36% | 2.68% | 3.06% | 20 | +3.48% | 2.70 | 2.57 | | TPCDS(42) | TPCDS-Q44 | orc / snap / block | 12.41 | 12.09 | +2.65% | 2.23% | 3.08% | 20 | +2.92% | 2.58 | 3.08 | | TPCDS(42) | TPCDS-Q32 | orc / snap / block | 1.69 | 1.65 | +2.47% | 2.00% | 1.62% | 20 | +2.74% | 2.96 | 4.22 | | TPCDS(42) | TPCDS-Q52 | orc / snap / block | 0.87 | 0.84 | +3.28% | 5.55% | 4.21% | 20 | +1.62% | 2.06 | 2.06 | | TPCDS(42) | TPCDS-Q33 | orc / snap / block | 2.50 | 2.43 | +2.51% | 1.66% | 1.45% | 20 | +2.17% | 4.07 | 5.01 | | TPCDS(42) | TPCDS-Q86A | orc / snap / block | 2.73 | 2.68 | +1.93% | 1.14% | 0.84% | 20 | +1.92% | 4.16 | 6.01 | | TPCDS(42) | TPCDS-Q54 | orc / snap / block | 4.38 | 4.29 | +2.22% | 2.69% | 3.54% | 20 | +1.55% | 2.20 | 2.21 | | TPCDS(42) | TPCDS-Q92 | orc / snap / block | 1.25 | 1.22 | +2.40% | 1.15% | 1.98% | 20 | +1.33% | 4.16 | 4.66 | | TPCDS(42) | TPCDS-Q4 | orc / snap / block | 14.21 | 13.99 | +1.58% | 1.28% | 1.48% | 20 | +1.81% | 2.99 | 3.59 | | TPCDS(42) | TPCDS-Q69 | orc / snap / block | 2.13 | 2.07 | +2.81% | 9.15% | 1.96% | 20 | +0.39% | 1.36 | 1.31 | | TPCDS(42) | TPCDS-Q50 | orc / snap / block | 4.79 | 4.79 | -0.12% | 6.62% | 1.87% | 20 | +2.53% | 1.12 | -0.08 | | TPCDS(42) | TPCDS-Q28 | orc / snap / block | 27.30 | 26.79 | +1.90% | 2.99% | 7.44% | 20 | +0.08% | 0.01 | 1.06 | | TPCDS(42) | TPCDS-Q34 | orc / snap / block | 1.59 | 1.57 | +1.13% | 2.09% | 2.98% | 20 | +0.72% | 2.09 | 1.39 | | TPCDS(42) | TPCDS-Q6 | orc / snap / block | 1.95 | 1.92 | +1.37% | 1.78% | 0.95% | 20 | +0.45% | 2.82 | 3.02 | | TPCDS(42) | TPCDS-Q12 | orc / snap / block | 1.61 | 1.58 | +1.47% | 3.31% | 2.27% | 20 | +0.31% | 0.77 | 1.62 | | TPCDS(42) | TPCDS-Q58 | orc / snap / block | 8.07 | 8.00 | +0.78% | 0.80% | 0.88% | 20 | +0.72% | 2.70 | 2.94 | | TPCDS(42) | TPCDS-Q94 | orc / snap / block | 1.68 | 1.67 | +0.98% | 1.71% | 1.75% | 20 | +0.43% | 1.71 | 1.79 | | TPCDS(42) | TPCDS-Q20 | orc / snap / block | 1.76 | 1.74 | +1.16% | 3.10% | 2.53% | 20 | +0.21% | 1.24 | 1.29 | | TPCDS(42) | TPCDS-Q71 | orc / snap / block | 2.42 | 2.40 | +0.80% | 1.75% | 1.63% | 20 | +0.35% | 2.03 | 1.49 | | TPCDS(42) | TPCDS-Q57 | orc / snap / block | 6.55 | 6.52 | +0.49% | 1.63% | 1.24% | 20 | +0.52% | 0.83 | 1.06 | | TPCDS(42) | TPCDS-Q56 | orc / snap / block | 2.66 | 2.65 | +0.54% | 1.23% | 1.10% | 20 | +0.42% | 1.39 | 1.46 | | TPCDS(42) | TPCDS-Q70A | orc / snap / block | 12.46 | 12.39 | +0.58% | 2.48% | 1.88% | 20 | +0.14% | 0.34 | 0.83 | | TPCDS(42) | TPCDS-Q3 | orc / snap / block | 1.05 | 1.05 | +0.40% | 0.35% | 0.99% | 20 | +0.24% | 1.94 | 1.73 | | TPCDS(42) | TPCDS-Q36 | orc / snap / block | 2.64 | 2.63 | +0.31% | 3.33% | 1.83% | 20 | +0.15% | 0.57 | 0.37 | | TPCDS(42) | TPCDS-Q93 | orc / snap / block | 6.17 | 6.15 | +0.25% | 1.03% | 1.05% | 20 | +0.17% | 0.92 | 0.76 | | TPCDS(42) | TPCDS-Q40 | orc / snap / block | 1.94 | 1.94 | +0.28% | 1.33% | 1.54% | 20 | +0.01% | 0.10 | 0.61 | | TPCDS(42) | TPCDS-Q77A | orc / snap / block | 15.19 | 15.16 | +0.17% | 1.68% | 2.11% | 20 | +0.11% | 0.28 | 0.28 | | TPCDS(42) | TPCDS-Q24-1 | orc / snap / block | 11.45 | 11.44 | +0.10% | 1.62% | 1.35% | 20 | +0.17% | 0.36 | 0.22 | | TPCDS(42) | TPCDS-Q90 | orc / snap / block | 1.36 | 1.36 | +0.11% | 1.63% | 1.86% | 20 | +0.17% | 1.04 | 0.20 | | TPCDS(42) | TPCDS-Q45 | orc / snap / block | 2.18 | 2.17 | +0.06% | 1.16% | 1.16% | 20 | +0.08% | 0.95 | 0.17 | | TPCDS(42) | TPCDS-Q95 | orc / snap / block | 2.88 | 2.88 | +0.17% | 1.49% | 1.04% | 20 | -0.03% | -0.34 | 0.42 | | TPCDS(42) | TPCDS-Q35A | orc / snap / block | 2.68 | 2.68 | +0.07% | 1.69% | 2.09% | 20 | +0.07% | 0.31 | 0.11 | | TPCDS(42) | TPCDS-Q15 | orc / snap / block | 1.79 | 1.79 | -0.03% | 1.06% | 1.08% | 20 | -0.04% | -0.77 | -0.09 | | TPCDS(42) | TPCDS-Q2 | orc / snap / block | 2.61 | 2.61 | -0.10% | 1.60% | 1.29% | 20 | +0.02% | 0.16 | -0.22 | | TPCDS(42) | TPCDS-Q63 | orc / snap / block | 1.89 | 1.89 | -0.24% | 2.33% | 2.54% | 20 | +0.15% | 0.54 | -0.31 | | TPCDS(42) | TPCDS-Q19 | orc / snap / block | 1.18 | 1.18 | -0.22% | 2.56% | 4.33% | 20 | +0.05% | 0.57 | -0.20 | | TPCDS(42) | TPCDS-Q70 | orc / snap / block | 3.64 | 3.64 | -0.17% | 1.37% | 1.14% | 20 | -0.04% | -0.22 | -0.44 | | TPCDS(42) | TPCDS-Q97 | orc / snap / block | 5.09 | 5.10 | -0.19% | 1.48% | 1.13% | 20 | -0.02% | -0.10 | -0.46 | | TPCDS(42) | TPCDS-Q74 | orc / snap / block | 6.90 | 6.91 | -0.18% | 0.72% | 0.77% | 20 | -0.07% | -0.69 | -0.77 | | TPCDS(42) | TPCDS-Q18 | orc / snap / block | 4.08 | 4.09 | -0.23% | 2.46% | 2.23% | 20 | -0.04% | -0.22 | -0.31 | | TPCDS(42) | TPCDS-Q83 | orc / snap / block | 1.95 | 1.96 | -0.22% | 2.08% | 1.51% | 20 | -0.08% | -0.83 | -0.38 | | TPCDS(42) | TPCDS-Q98 | orc / snap / block | 1.69 | 1.69 | -0.32% | 2.27% | 1.68% | 20 | +0.02% | 0.16 | -0.52 | | TPCDS(42) | TPCDS-Q31 | orc / snap / block | 4.87 | 4.88 | -0.22% | 1.13% | 1.04% | 20 | -0.09% | -0.63 | -0.63 | | TPCDS(42) | TPCDS-Q60 | orc / snap / block | 2.66 | 2.67 | -0.33% | 1.89% | 1.84% | 20 | +0.02% | 0.01 | -0.57 | | TPCDS(42) | TPCDS-Q78 | orc / snap / block | 29.25 | 29.30 | -0.19% | 0.30% | 0.40% | 20 | -0.18% | -1.36 | -1.68 | | TPCDS(42) | TPCDS-Q47 | orc / snap / block | 8.77 | 8.80 | -0.24% | 0.62% | 0.76% | 20 | -0.15% | -0.80 | -1.10 | | TPCDS(42) | TPCDS-Q10A | orc / snap / block | 2.15 | 2.14 | +0.28% | 6.41% | 3.10% | 20 | -0.67% | -0.51 | 0.17 | | TPCDS(42) | TPCDS-Q8 | orc / snap / block | 1.20 | 1.20 | -0.56% | 2.48% | 3.32% | 20 | +0.14% | 0.54 | -0.61 | | TPCDS(42) | TPCDS-Q51 | orc / snap / block | 12.59 | 12.62 | -0.23% | 0.56% | 0.42% | 20 | -0.25% | -0.74 | -1.45 | | TPCDS(42) | TPCDS-Q61 | orc / snap / block | 1.76 | 1.76 | -0.50% | 2.41% | 2.44% | 20 | -0.07% | -0.36 | -0.65 | | TPCDS(42) | TPCDS-Q77 | orc / snap / block | 3.34 | 3.35 | -0.45% | 0.96% | 0.88% | 20 | -0.16% | -0.60 | -1.56 | | TPCDS(42) | TPCDS-Q87 | orc / snap / block | 4.00 | 4.02 | -0.53% | 1.32% | 1.15% | 20 | -0.15% | -0.69 | -1.36 | | TPCDS(42) | TPCDS-Q53 | orc / snap / block | 1.90 | 1.91 | -0.62% | 2.83% | 3.40% | 20 | -0.09% | -0.19 | -0.63 | | TPCDS(42) | TPCDS-Q96 | orc / snap / block | 3.26 | 3.28 | -0.63% | 3.24% | 1.95% | 20 | -0.27% | -0.28 | -0.74 | | TPCDS(42) | TPCDS-Q85 | orc / snap / block | 2.63 | 2.65 | -0.70% | 1.21% | 1.63% | 20 | -0.19% | -1.45 | -1.55 | | TPCDS(42) | TPCDS-Q62 | orc / snap / block | 1.94 | 1.95 | -0.86% | 1.56% | 1.87% | 20 | -0.10% | -1.59 | -1.60 | | TPCDS(42) | TPCDS-Q49 | orc / snap / block | 4.27 | 4.29 | -0.61% | 2.25% | 2.22% | 20 | -0.43% | -0.80 | -0.86 | | TPCDS(42) | TPCDS-Q88 | orc / snap / block | 23.11 | 23.21 | -0.43% | 1.71% | 1.79% | 20 | -0.62% | -1.97 | -0.77 | | TPCDS(42) | TPCDS-Q89 | orc / snap / block | 2.14 | 2.15 | -0.82% | 1.63% | 1.56% | 20 | -0.30% | -0.80 | -1.63 | | TPCDS(42) | TPCDS-Q38 | orc / snap / block | 5.13 | 5.16 | -0.54% | 1.23% | 0.76% | 20 | -0.65% | -1.53 | -1.68 | | TPCDS(42) | TPCDS-Q84 | orc / snap / block | 1.49 | 1.51 | -1.18% | 1.34% | 1.95% | 20 | -0.06% | -1.30 | -2.24 | | TPCDS(42) | TPCDS-Q51A | orc / snap / block | 108.35 | 109.06 | -0.65% | 0.44% | 0.39% | 20 | -0.67% | -4.19 | -4.97 | | TPCDS(42) | TPCDS-Q46 | orc / snap / block | 2.41 | 2.42 | -0.53% | 1.94% | 1.30% | 20 | -1.01% | -1.33 | -1.01 | | TPCDS(42) | TPCDS-Q41 | orc / snap / block | 0.52 | 0.53 | -1.46% | 2.56% | 4.26% | 20 | -0.08% | -0.54 | -1.32 | | TPCDS(42) | TPCDS-Q55 | orc / snap / block | 0.84 | 0.85 | -1.42% | 4.02% | 3.66% | 20 | -0.36% | -0.86 | -1.18 | | TPCDS(42) | TPCDS-Q23-2 | orc / snap / block | 30.75 | 31.08 | -1.08% | 1.84% | 1.47% | 20 | -0.79% | -1.56 | -2.07 | | TPCDS(42) | TPCDS-Q86 | orc / snap / block | 1.74 | 1.77 | -1.66% | 2.67% | 4.53% | 20 | -0.34% | -1.36 | -1.42 | | TPCDS(42) | TPCDS-Q72 | orc / snap / block | 9.10 | 9.19 | -0.96% | 1.78% | 1.77% | 20 | -1.08% | -1.50 | -1.71 | | TPCDS(42) | TPCDS-Q11 | orc / snap / block | 9.38 | 9.48 | -1.11% | 1.71% | 1.13% | 20 | -1.44% | -2.32 | -2.45 | | TPCDS(42) | TPCDS-Q23-1 | orc / snap / block | 29.95 | 30.37 | -1.37% | 1.78% | 1.34% | 20 | -1.28% | -2.79 | -2.78 | | TPCDS(42) | TPCDS-Q14-2 | orc / snap / block | 27.65 | 28.09 | -1.54% | 1.89% | 0.98% | 20 | -1.37% | -2.61 | -3.27 | | TPCDS(42) | TPCDS-Q25 | orc / snap / block | 2.65 | 2.69 | -1.49% | 1.18% | 1.70% | 20 | -1.56% | -2.15 | -3.24 | | TPCDS(42) | TPCDS-Q14-1 | orc / snap / block | 29.95 | 30.40 | -1.50% | 1.04% | 0.68% | 20 | -1.56% | -4.51 | -5.46 | | TPCDS(42) | TPCDS-Q18A | orc / snap / block | 10.84 | 11.01 | -1.57% | 1.88% | 1.53% | 20 | -1.79% | -2.29 | -2.92 | | TPCDS(42) | TPCDS-Q30 | orc / snap / block | 2.43 | 2.47 | -1.53% | 1.35% | 1.45% | 20 | -1.87% | -3.37 | -3.48 | | TPCDS(42) | TPCDS-Q81 | orc / snap / block | 2.44 | 2.48 | -1.69% | 1.82% | 2.22% | 20 | -1.96% | -2.55 | -2.65 | | TPCDS(42) | TPCDS-Q67 | orc / snap / block | 56.32 | 57.37 | -1.84% | 0.41% | 0.51% | 20 | -1.87% | -5.24 | -12.66 | | TPCDS(42) | TPCDS-Q17 | orc / snap / block | 3.01 | 3.07 | -1.96% | 1.00% | 1.05% | 20 | -1.84% | -4.10 | -6.10 | | TPCDS(42) | TPCDS-Q79 | orc / snap / block | 1.70 | 1.73 | -1.85% | 1.77% | 1.63% | 20 | -2.61% | -2.00 | -3.47 | | TPCDS(42) | TPCDS-Q9 | orc / snap / block | 31.84 | 32.60 | -2.33% | 2.49% | 2.60% | 20 | -2.17% | -2.79 | -2.92 | | TPCDS(42) | TPCDS-Q48 | orc / snap / block | 2.61 | 2.68 | -2.58% | 0.88% | 1.14% | 20 | -2.07% | -4.95 | -8.10 | | TPCDS(42) | TPCDS-Q68 | orc / snap / block | 1.63 | 1.67 | -2.00% | 5.20% | 2.81% | 20 | -3.01% | -3.08 | -1.54 | | TPCDS(42) | TPCDS-Q26 | orc / snap / block | 2.64 | 2.71 | -2.62% | 1.75% | 1.08% | 20 | -2.54% | -4.04 | -5.81 | | TPCDS(42) | TPCDS-Q13 | orc / snap / block | 5.07 | 5.22 | -2.97% | 1.72% | 1.44% | 20 | -2.91% | -3.99 | -6.00 | | TPCDS(42) | TPCDS-Q24-2 | orc / snap / block | 11.41 | 11.75 | -2.90% | 1.57% | 0.84% | 20 | -3.18% | -4.45 | -7.47 | | TPCDS(42) | TPCDS-Q73 | orc / snap / block | 1.14 | 1.17 | -2.76% | 2.20% | 1.82% | 20 | -3.79% | -2.53 | -4.39 | | TPCDS(42) | TPCDS-Q91 | orc / snap / block | 1.18 | 1.21 | -2.36% | 4.06% | 3.65% | 20 | -4.22% | -1.12 | -1.96 | | TPCDS(42) | TPCDS-Q59 | orc / snap / block | 2.73 | 2.83 | -3.37% | 0.97% | 1.19% | 20 | -3.54% | -5.04 | -9.92 | | TPCDS(42) | TPCDS-Q64 | orc / snap / block | 11.10 | 11.50 | -3.53% | 1.22% | 1.42% | 20 | -3.62% | -5.01 | -8.56 | | TPCDS(42) | TPCDS-Q66 | orc / snap / block | 4.05 | 4.20 | -3.59% | 1.35% | 0.72% | 20 | -3.83% | -5.24 | -10.77 | | TPCDS(42) | TPCDS-Q99 | orc / snap / block | 2.62 | 2.72 | -3.77% | 1.39% | 1.34% | 20 | -3.86% | -4.92 | -8.87 | | TPCDS(42) | TPCDS-Q1 | orc / snap / block | 2.29 | 2.38 | -3.94% | 2.21% | 1.66% | 20 | -4.16% | -4.36 | -6.53 | | TPCDS(42) | TPCDS-Q76 | orc / snap / block | 6.36 | 6.64 | -4.19% | 2.66% | 1.31% | 20 | -3.97% | -4.51 | -6.54 | | TPCDS(42) | TPCDS-Q80 | orc / snap / block | 3.94 | 4.11 | -4.16% | 1.08% | 1.22% | 20 | -4.05% | -5.27 | -11.61 | | TPCDS(42) | TPCDS-Q80A | orc / snap / block | 25.50 | 26.53 | -3.89% | 2.34% | 2.96% | 20 | -4.35% | -4.22 | -4.67 | | TPCDS(42) | TPCDS-Q75 | orc / snap / block | 16.65 | 17.36 | -4.14% | 2.39% | 2.17% | 20 | -4.15% | -4.48 | -5.86 | | TPCDS(42) | TPCDS-Q67A | orc / snap / block | 102.18 | 106.88 | -4.39% | 2.05% | 4.08% | 20 | -4.05% | -3.52 | -4.34 | | TPCDS(42) | TPCDS-Q7 | orc / snap / block | 2.28 | 2.40 | -4.95% | 1.62% | 2.11% | 20 | -4.70% | -4.95 | -8.49 | | TPCDS(42) | TPCDS-Q29 | orc / snap / block | 2.86 | 3.00 | -4.63% | 1.45% | 1.40% | 20 | -5.11% | -5.15 | -10.53 | | TPCDS(42) | TPCDS-Q22 | orc / snap / block | 9.25 | 9.81 | I -5.65% | 2.13% | 1.47% | 20 | I -5.96% | -5.12 | -10.16 | | TPCDS(42) | TPCDS-Q22A | orc / snap / block | 7.34 | 7.79 | I -5.80% | 0.97% | 1.35% | 20 | I -6.14% | -5.27 | -15.91 | | TPCDS(42) | TPCDS-Q16 | orc / snap / block | 2.46 | 2.61 | I -5.97% | 1.46% | 1.09% | 20 | I -6.17% | -5.27 | -15.21 | | TPCDS(42) | TPCDS-Q5 | orc / snap / block | 3.02 | 3.23 | I -6.53% | 1.60% | 0.90% | 20 | I -7.07% | -5.24 | -16.78 | | TPCDS(42) | TPCDS-Q65 | orc / snap / block | 4.84 | 5.25 | I -7.84% | 1.10% | 3.22% | 20 | I -7.94% | -5.27 | -10.39 | | TPCDS(42) | TPCDS-Q82 | orc / snap / block | 4.07 | 4.61 | I -11.68% | 1.45% | 0.95% | 20 | I -13.44% | -5.27 | -32.76 | | TPCDS(42) | TPCDS-Q39-2 | orc / snap / block | 7.11 | 8.32 | I -14.49% | 0.87% | 0.99% | 20 | I -16.93% | -5.27 | -52.18 | | TPCDS(42) | TPCDS-Q39-1 | orc / snap / block | 7.07 | 8.31 | I -14.85% | 0.83% | 1.07% | 20 | I -17.74% | -5.27 | -51.82 | | TPCDS(42) | TPCDS-Q37 | orc / snap / block | 3.04 | 3.59 | I -15.46% | 1.62% | 1.39% | 20 | I -18.18% | -5.27 | -35.40 | | TPCDS(42) | TPCDS-Q21 | orc / snap / block | 2.96 | 3.60 | I -17.66% | 0.79% | 2.61% | 20 | I -20.54% | -5.27 | -29.36 | +-----------+-------------+--------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+--------+ (I) Improvement: TPCDS(42) TPCDS-Q22 [orc / snap / block] (9.81s -> 9.25s [-5.65%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 07:AGGREGATE | 61.16% | 4.79s | 4.86s | -1.41% | 3.28% | 5.05s | 5.05s | +0.08% | 1 | 1 | 107.88K | 121.12M | | 04:HASH JOIN | 7.54% | 590.72ms | 603.99ms | -2.20% | 8.34% | 731.98ms | 691.99ms | +5.78% | 1 | 1 | 8.42M | 41.88M | | 00:SCAN HDFS | 26.45% | 2.07s | 2.53s | -18.05% | 1.42% | 2.12s | 2.58s | -17.96% | 1 | 1 | 8.42M | 42.28M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q22A [orc / snap / block] (7.79s -> 7.34s [-5.80%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 16:AGGREGATE | 7.24% | 2.03s | 1.99s | +1.90% | 2.76% | 2.12s | 2.16s | -2.04% | 1 | 1 | 26.98K | 41.88M | | 13:HASH JOIN | 2.99% | 839.14ms | 834.30ms | +0.58% | 7.89% | 995.98ms | 951.98ms | +4.62% | 1 | 1 | 8.42M | 41.88M | | 09:SCAN HDFS | 9.99% | 2.80s | 3.28s | -14.66% | 2.12% | 2.93s | 3.40s | -13.98% | 1 | 1 | 8.42M | 42.28M | | 24:AGGREGATE | 6.59% | 1.85s | 1.80s | +2.44% | 2.92% | 1.96s | 1.96s | +0.41% | 1 | 1 | 26.97K | 37.31M | | 23:HASH JOIN | 2.48% | 696.20ms | 713.25ms | -2.39% | 8.37% | 791.98ms | 831.98ms | -4.81% | 1 | 1 | 8.42M | 41.88M | | 22:HASH JOIN | 2.54% | 711.77ms | 775.77ms | -8.25% | 6.32% | 763.98ms | 899.98ms | -15.11% | 1 | 1 | 8.42M | 41.88M | | 21:HASH JOIN | 8.28% | 2.32s | 2.36s | -1.60% | 5.69% | 2.63s | 2.68s | -1.94% | 1 | 1 | 42.28M | 41.88M | | 32:AGGREGATE | 4.87% | 1.37s | 1.34s | +1.92% | 3.96% | 1.48s | 1.52s | -2.64% | 1 | 1 | 26.94K | 54.00K | | 31:HASH JOIN | 2.40% | 672.41ms | 655.77ms | +2.54% | 6.44% | 783.98ms | 767.98ms | +2.08% | 1 | 1 | 8.42M | 41.88M | | 30:HASH JOIN | 2.51% | 705.04ms | 748.61ms | -5.82% | 7.69% | 827.98ms | 827.98ms | +0.00% | 1 | 1 | 8.42M | 41.88M | | 29:HASH JOIN | 8.18% | 2.29s | 2.36s | -2.82% | 6.63% | 2.54s | 2.53s | +0.32% | 1 | 1 | 42.28M | 41.88M | | 40:AGGREGATE | 2.57% | 720.41ms | 715.35ms | +0.71% | 6.21% | 803.98ms | 871.98ms | -7.80% | 1 | 1 | 1 | 1 | | 39:HASH JOIN | 2.16% | 606.93ms | 623.99ms | -2.73% | 9.74% | 759.98ms | 707.98ms | +7.35% | 1 | 1 | 8.42M | 41.88M | | 38:HASH JOIN | 2.56% | 718.30ms | 728.40ms | -1.39% | * 11.28% * | 907.98ms | 811.98ms | +11.82% | 1 | 1 | 8.42M | 41.88M | | 37:HASH JOIN | 6.86% | 1.92s | 1.84s | +4.41% | 6.73% | 2.26s | 2.06s | +9.90% | 1 | 1 | 42.28M | 41.88M | | 08:AGGREGATE | 8.07% | 2.26s | 2.25s | +0.42% | 2.99% | 2.40s | 2.41s | -0.50% | 1 | 1 | 26.99K | 41.88M | | 05:HASH JOIN | 3.01% | 845.25ms | 861.87ms | -1.93% | 5.33% | 943.98ms | 955.98ms | -1.25% | 1 | 1 | 8.42M | 41.88M | | 01:SCAN HDFS | 9.86% | 2.76s | 3.23s | -14.44% | 1.96% | 2.90s | 3.34s | -13.29% | 1 | 1 | 8.42M | 42.28M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q16 [orc / snap / block] (2.61s -> 2.46s [-5.97%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | F06:EXCHANGE SENDER | 9.54% | 364.13ms | 361.82ms | +0.64% | * 10.92% * | 551.99ms | 567.99ms | -2.82% | 3 | 3 | -1 | -1 | | 00:SCAN HDFS | 27.08% | 1.03s | 1.22s | -15.47% | 4.40% | 1.24s | 1.36s | -9.09% | 3 | 3 | 61.40K | 60.48M | | 04:SCAN HDFS | 58.00% | 2.21s | 2.39s | -7.20% | 1.38% | 2.31s | 2.48s | -6.94% | 3 | 3 | 144.30K | 60.48M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q5 [orc / snap / block] (3.23s -> 3.02s [-6.53%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 11:SCAN HDFS | 2.07% | 141.54ms | 119.93ms | +18.02% | * 16.16% * | 291.99ms | 247.99ms | +17.74% | 3 | 3 | 25.98K | 6.05M | | 10:SCAN HDFS | 14.83% | 1.01s | 1.16s | -12.52% | 7.78% | 1.23s | 1.64s | -24.69% | 3 | 3 | 1.36M | 60.48M | | 19:SCAN HDFS | 22.88% | 1.56s | 1.61s | -3.19% | 8.88% | 1.89s | 2.05s | -7.99% | 3 | 3 | 9.11K | 3.02M | | 20:SCAN HDFS | 35.25% | 2.41s | 2.56s | -5.87% | 1.86% | 2.56s | 2.76s | -7.25% | 3 | 3 | 38.33K | 30.24M | | 18:SCAN HDFS | 8.55% | 584.34ms | 677.11ms | -13.70% | * 13.43% * | 851.98ms | 1.10s | -22.55% | 3 | 3 | 326.38K | 30.24M | | 03:SCAN HDFS | 6.71% | 458.31ms | 565.25ms | -18.92% | * 10.64% * | 631.99ms | 939.98ms | -32.77% | 3 | 3 | 55.80K | 12.09M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q65 [orc / snap / block] (5.25s -> 4.84s [-7.84%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | F05:EXCHANGE SENDER | 3.65% | 322.03ms | 308.62ms | +4.34% | 2.27% | 355.99ms | 379.99ms | -6.32% | 3 | 3 | -1 | -1 | | 05:AGGREGATE | 13.91% | 1.23s | 1.31s | -6.29% | 3.14% | 1.40s | 1.76s | -20.05% | 3 | 3 | 4.89M | 3.33M | | 04:HASH JOIN | 3.00% | 264.98ms | 267.57ms | -0.97% | 7.20% | 323.99ms | 347.99ms | -6.90% | 3 | 3 | 22.86M | 120.96M | | 00:SCAN HDFS | 27.21% | 2.40s | 2.60s | -7.49% | 2.41% | 2.53s | 2.82s | -10.21% | 1 | 1 | 60 | 118 | | F00:EXCHANGE SENDER | 3.62% | 320.06ms | 304.83ms | +5.00% | 2.80% | 347.99ms | 339.99ms | +2.35% | 3 | 3 | -1 | -1 | | 10:AGGREGATE | 13.11% | 1.16s | 1.23s | -5.58% | 2.74% | 1.31s | 1.68s | -22.33% | 3 | 3 | 4.89M | 3.33M | | 09:HASH JOIN | 3.09% | 273.19ms | 276.98ms | -1.37% | 7.22% | 371.99ms | 371.99ms | +0.00% | 3 | 3 | 22.72M | 120.96M | | 07:SCAN HDFS | 23.33% | 2.06s | 2.26s | -8.79% | 2.36% | 2.22s | 2.61s | -14.85% | 3 | 3 | 22.72M | 120.96M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q82 [orc / snap / block] (4.61s -> 4.07s [-11.68%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 38.51% | 2.38s | 2.94s | -18.75% | 2.10% | 2.47s | 3.02s | -18.25% | 1 | 1 | 554.52K | 4.23M | | 00:SCAN HDFS | 39.83% | 2.47s | 3.01s | -18.10% | 2.58% | 2.57s | 3.09s | -16.82% | 1 | 1 | 2 | 71 | | 03:SCAN HDFS | 20.18% | 1.25s | 1.22s | +2.66% | 2.93% | 1.34s | 1.34s | +0.00% | 3 | 3 | 7.13K | 120.96M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q39-2 [orc / snap / block] (8.32s -> 7.11s [-14.49%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | 08:SCAN HDFS | 17.53% | 3.08s | 3.67s | -16.18% | 1.20% | 3.14s | 3.73s | -15.97% | 1 | 1 | 648.00K | 42.28M | | 02:SCAN HDFS | 22.92% | 4.03s | 4.63s | -12.98% | 1.02% | 4.08s | 4.70s | -13.11% | 1 | 1 | 6 | 6 | | 01:SCAN HDFS | 22.99% | 4.04s | 4.63s | -12.82% | 0.99% | 4.09s | 4.70s | -12.86% | 1 | 1 | 9.53K | 54.00K | | 00:SCAN HDFS | 34.69% | 6.09s | 7.33s | -16.80% | 0.94% | 6.19s | 7.48s | -17.22% | 1 | 1 | 228.67K | 42.28M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q39-1 [orc / snap / block] (8.31s -> 7.07s [-14.85%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | 08:SCAN HDFS | 17.53% | 3.07s | 3.67s | -16.43% | 1.23% | 3.16s | 3.81s | -17.10% | 1 | 1 | 648.00K | 42.28M | | 02:SCAN HDFS | 22.97% | 4.02s | 4.63s | -13.07% | 0.85% | 4.09s | 4.77s | -14.26% | 1 | 1 | 6 | 6 | | 01:SCAN HDFS | 22.98% | 4.02s | 4.63s | -13.11% | 0.80% | 4.08s | 4.77s | -14.35% | 1 | 1 | 9.53K | 54.00K | | 00:SCAN HDFS | 34.67% | 6.07s | 7.31s | -16.95% | 1.02% | 6.24s | 7.51s | -16.88% | 1 | 1 | 228.67K | 42.28M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q37 [orc / snap / block] (3.59s -> 3.04s [-15.46%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 44.92% | 2.36s | 2.90s | -18.51% | 2.42% | 2.52s | 2.99s | -15.53% | 1 | 1 | 555.02K | 4.23M | | 00:SCAN HDFS | 46.41% | 2.44s | 2.96s | -17.70% | 2.45% | 2.56s | 3.05s | -15.99% | 1 | 1 | 1 | 71 | | 03:SCAN HDFS | 7.09% | 372.41ms | 373.75ms | -0.36% | 2.27% | 407.99ms | 435.99ms | -6.42% | 3 | 3 | 2.20K | 60.48M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q21 [orc / snap / block] (3.60s -> 2.96s [-17.66%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 96.60% | 2.01s | 2.64s | -23.94% | 0.82% | 2.04s | 3.05s | -33.07% | 1 | 1 | 94.66K | 42.28M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+--------+-----------+ Significant perf change detected.