Report Generated on 2022-03-02 Run Description: "f42643276e64944cf0f356b64b40925183514f6f vs d56038f4b98b17e0852909c7293874a6975c4b83" Cluster Name: UNKNOWN Lab Run Info: UNKNOWN Impala Version: impalad version 4.1.0-SNAPSHOT RELEASE (2022-02-24) Baseline Impala Version: impalad version 4.1.0-SNAPSHOT RELEASE (2022-02-24) +-----------+--------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +-----------+--------------------+---------+------------+------------+----------------+ | TPCDS(42) | orc / snap / block | 7.61 | -9.94% | 3.78 | -7.22% | +-----------+--------------------+---------+------------+------------+----------------+ +-----------+-------------+--------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+---------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Iters | Median Diff(%) | MW Zval | Tval | +-----------+-------------+--------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+---------+ | TPCDS(42) | TPCDS-Q88 | orc / snap / block | 30.59 | 23.08 | R +32.53% | 3.72% | 2.12% | 20 | R +24.99% | 5.27 | 27.08 | | TPCDS(42) | TPCDS-Q96 | orc / snap / block | 4.18 | 3.24 | R +28.80% | 5.31% | 1.79% | 20 | R +23.81% | 5.27 | 18.22 | | TPCDS(42) | TPCDS-Q27 | orc / snap / block | 3.11 | 2.50 | R +24.21% | 1.08% | 1.33% | 20 | R +19.48% | 5.27 | 57.38 | | TPCDS(42) | TPCDS-Q92 | orc / snap / block | 1.47 | 1.22 | R +21.01% | 1.64% | 1.92% | 20 | R +17.07% | 5.27 | 33.99 | | TPCDS(42) | TPCDS-Q24-1 | orc / snap / block | 13.58 | 11.44 | R +18.71% | 2.45% | 1.22% | 20 | R +15.78% | 5.27 | 26.56 | | TPCDS(42) | TPCDS-Q3 | orc / snap / block | 1.21 | 1.02 | R +18.05% | 1.39% | 2.49% | 20 | R +16.27% | 5.27 | 27.04 | | TPCDS(42) | TPCDS-Q46 | orc / snap / block | 2.84 | 2.41 | R +18.09% | 1.34% | 1.97% | 20 | R +15.97% | 5.27 | 31.96 | | TPCDS(42) | TPCDS-Q42 | orc / snap / block | 0.97 | 0.82 | R +17.30% | 2.91% | 3.70% | 20 | R +15.71% | 5.27 | 15.37 | | TPCDS(42) | TPCDS-Q55 | orc / snap / block | 0.96 | 0.83 | R +16.78% | 2.40% | 4.03% | 20 | R +15.86% | 5.27 | 15.28 | | TPCDS(42) | TPCDS-Q52 | orc / snap / block | 0.97 | 0.84 | R +16.28% | 3.49% | 5.65% | 20 | R +15.98% | 5.27 | 10.46 | | TPCDS(42) | TPCDS-Q48 | orc / snap / block | 3.07 | 2.61 | R +17.25% | 1.41% | 1.00% | 20 | R +14.86% | 5.27 | 40.02 | | TPCDS(42) | TPCDS-Q24-2 | orc / snap / block | 13.00 | 11.21 | R +15.90% | 1.82% | 1.53% | 20 | R +13.95% | 5.27 | 27.29 | | TPCDS(42) | TPCDS-Q90 | orc / snap / block | 1.56 | 1.34 | R +15.96% | 1.12% | 1.77% | 20 | R +13.12% | 5.27 | 32.43 | | TPCDS(42) | TPCDS-Q50 | orc / snap / block | 5.48 | 4.79 | R +14.53% | 7.72% | 4.48% | 20 | R +14.51% | 4.28 | 6.55 | | TPCDS(42) | TPCDS-Q74 | orc / snap / block | 7.95 | 6.89 | R +15.32% | 1.42% | 0.66% | 20 | R +12.90% | 5.27 | 38.84 | | TPCDS(42) | TPCDS-Q43 | orc / snap / block | 1.54 | 1.34 | R +14.81% | 2.95% | 2.31% | 20 | R +13.27% | 5.27 | 16.15 | | TPCDS(42) | TPCDS-Q79 | orc / snap / block | 1.91 | 1.67 | R +14.52% | 1.66% | 1.81% | 20 | R +13.25% | 5.27 | 24.76 | | TPCDS(42) | TPCDS-Q86A | orc / snap / block | 3.00 | 2.65 | R +13.22% | 1.04% | 1.11% | 20 | R +11.86% | 5.27 | 36.52 | | TPCDS(42) | TPCDS-Q62 | orc / snap / block | 2.16 | 1.91 | R +13.22% | 1.49% | 2.29% | 20 | R +11.80% | 5.27 | 20.78 | | TPCDS(42) | TPCDS-Q8 | orc / snap / block | 1.35 | 1.20 | R +12.77% | 2.45% | 2.45% | 20 | R +11.56% | 5.27 | 15.45 | | TPCDS(42) | TPCDS-Q73 | orc / snap / block | 1.29 | 1.15 | R +12.59% | 2.24% | 1.77% | 20 | R +11.53% | 5.27 | 18.24 | | TPCDS(42) | TPCDS-Q91 | orc / snap / block | 1.33 | 1.19 | R +12.23% | 4.34% | 3.06% | 20 | R +11.33% | 5.15 | 9.50 | | TPCDS(42) | TPCDS-Q64 | orc / snap / block | 12.34 | 10.97 | R +12.51% | 1.51% | 1.15% | 20 | R +10.85% | 5.27 | 27.28 | | TPCDS(42) | TPCDS-Q61 | orc / snap / block | 1.95 | 1.74 | R +11.67% | 1.48% | 4.52% | 20 | R +11.02% | 4.86 | 10.85 | | TPCDS(42) | TPCDS-Q86 | orc / snap / block | 1.92 | 1.72 | R +11.83% | 4.86% | 3.78% | 20 | R +10.54% | 4.89 | 7.99 | | TPCDS(42) | TPCDS-Q1 | orc / snap / block | 2.58 | 2.30 | R +12.09% | 7.63% | 1.37% | 20 | R +9.33% | 5.27 | 6.24 | | TPCDS(42) | TPCDS-Q45 | orc / snap / block | 2.35 | 2.12 | R +10.83% | 1.02% | 1.14% | 20 | R +10.41% | 5.27 | 30.12 | | TPCDS(42) | TPCDS-Q83 | orc / snap / block | 2.12 | 1.92 | R +10.60% | 2.51% | 1.46% | 20 | R +9.55% | 5.27 | 15.12 | | TPCDS(42) | TPCDS-Q4 | orc / snap / block | 15.42 | 14.01 | R +10.05% | 0.88% | 1.78% | 20 | R +9.23% | 5.27 | 22.20 | | TPCDS(42) | TPCDS-Q36 | orc / snap / block | 2.88 | 2.63 | R +9.47% | 1.96% | 2.95% | 20 | R +8.82% | 5.27 | 11.60 | | TPCDS(42) | TPCDS-Q68 | orc / snap / block | 1.77 | 1.62 | R +9.61% | 1.89% | 3.63% | 20 | R +8.65% | 4.80 | 10.29 | | TPCDS(42) | TPCDS-Q34 | orc / snap / block | 1.72 | 1.57 | R +9.38% | 1.83% | 1.75% | 20 | R +8.82% | 5.27 | 15.80 | | TPCDS(42) | TPCDS-Q59 | orc / snap / block | 2.98 | 2.72 | R +9.41% | 1.11% | 1.00% | 20 | R +8.69% | 5.27 | 26.66 | | TPCDS(42) | TPCDS-Q11 | orc / snap / block | 10.24 | 9.36 | R +9.39% | 0.96% | 1.19% | 20 | R +8.58% | 5.27 | 26.50 | | TPCDS(42) | TPCDS-Q19 | orc / snap / block | 1.30 | 1.19 | R +9.78% | 2.83% | 3.73% | 20 | R +8.13% | 5.01 | 9.01 | | TPCDS(42) | TPCDS-Q13 | orc / snap / block | 5.44 | 4.97 | R +9.38% | 1.11% | 0.66% | 20 | R +8.39% | 5.27 | 30.38 | | TPCDS(42) | TPCDS-Q94 | orc / snap / block | 1.81 | 1.67 | R +8.22% | 2.64% | 1.54% | 20 | R +8.26% | 5.27 | 11.31 | | TPCDS(42) | TPCDS-Q6 | orc / snap / block | 2.07 | 1.91 | R +8.56% | 0.99% | 0.98% | 20 | R +7.44% | 5.27 | 26.36 | | TPCDS(42) | TPCDS-Q30 | orc / snap / block | 2.59 | 2.41 | R +7.63% | 1.30% | 1.25% | 20 | R +7.60% | 5.27 | 18.15 | | TPCDS(42) | TPCDS-Q2 | orc / snap / block | 2.81 | 2.61 | R +7.77% | 1.57% | 2.03% | 20 | R +7.22% | 5.27 | 13.18 | | TPCDS(42) | TPCDS-Q84 | orc / snap / block | 1.61 | 1.49 | R +8.15% | 1.58% | 1.00% | 20 | R +6.46% | 5.27 | 18.44 | | TPCDS(42) | TPCDS-Q89 | orc / snap / block | 2.23 | 2.09 | R +6.75% | 0.98% | 2.21% | 20 | R +6.74% | 5.27 | 12.36 | | TPCDS(42) | TPCDS-Q28 | orc / snap / block | 27.48 | 25.89 | R +6.12% | 4.09% | 5.24% | 20 | R +5.63% | 3.43 | 4.02 | | TPCDS(42) | TPCDS-Q85 | orc / snap / block | 2.73 | 2.58 | R +5.89% | 1.72% | 1.87% | 20 | R +5.57% | 5.21 | 10.10 | | TPCDS(42) | TPCDS-Q47 | orc / snap / block | 9.23 | 8.72 | R +5.78% | 0.54% | 0.82% | 20 | R +5.52% | 5.27 | 25.79 | | TPCDS(42) | TPCDS-Q65 | orc / snap / block | 5.01 | 4.74 | R +5.69% | 1.58% | 1.79% | 20 | R +5.19% | 5.18 | 10.40 | | TPCDS(42) | TPCDS-Q29 | orc / snap / block | 3.09 | 2.94 | R +5.22% | 1.84% | 1.26% | 20 | R +4.97% | 5.15 | 10.10 | | TPCDS(42) | TPCDS-Q31 | orc / snap / block | 5.02 | 4.79 | +4.83% | 1.25% | 1.14% | 20 | +4.41% | 5.27 | 12.44 | | TPCDS(42) | TPCDS-Q53 | orc / snap / block | 1.92 | 1.87 | +2.88% | 2.24% | 1.96% | 20 | +2.82% | 3.78 | 4.25 | | TPCDS(42) | TPCDS-Q63 | orc / snap / block | 1.91 | 1.87 | +2.48% | 1.66% | 2.16% | 20 | +2.85% | 3.72 | 4.02 | | TPCDS(42) | TPCDS-Q93 | orc / snap / block | 6.23 | 6.07 | +2.64% | 0.89% | 1.05% | 20 | +2.50% | 5.01 | 8.47 | | TPCDS(42) | TPCDS-Q14-1 | orc / snap / block | 30.97 | 30.18 | +2.59% | 0.65% | 1.24% | 20 | +2.54% | 4.92 | 8.24 | | TPCDS(42) | TPCDS-Q81 | orc / snap / block | 2.50 | 2.43 | +2.72% | 1.77% | 1.21% | 20 | +2.13% | 4.25 | 5.58 | | TPCDS(42) | TPCDS-Q70 | orc / snap / block | 3.78 | 3.69 | +2.24% | 1.41% | 1.72% | 20 | +2.37% | 3.69 | 4.45 | | TPCDS(42) | TPCDS-Q35A | orc / snap / block | 2.70 | 2.63 | +2.42% | 1.76% | 1.57% | 20 | +2.14% | 3.93 | 4.53 | | TPCDS(42) | TPCDS-Q7 | orc / snap / block | 2.42 | 2.37 | +2.15% | 1.17% | 1.93% | 20 | +2.11% | 3.49 | 4.24 | | TPCDS(42) | TPCDS-Q54 | orc / snap / block | 4.24 | 4.14 | +2.42% | 3.03% | 6.70% | 20 | +1.08% | 0.63 | 1.47 | | TPCDS(42) | TPCDS-Q67 | orc / snap / block | 56.54 | 55.95 | +1.07% | 0.34% | 0.54% | 20 | +1.07% | 4.60 | 7.41 | | TPCDS(42) | TPCDS-Q76 | orc / snap / block | 6.49 | 6.48 | +0.16% | 3.83% | 0.65% | 20 | +1.08% | 1.39 | 0.19 | | TPCDS(42) | TPCDS-Q51 | orc / snap / block | 12.59 | 12.55 | +0.33% | 0.66% | 0.49% | 20 | +0.37% | 1.62 | 1.80 | | TPCDS(42) | TPCDS-Q78 | orc / snap / block | 28.92 | 28.82 | +0.34% | 0.33% | 0.31% | 20 | +0.35% | 2.96 | 3.34 | | TPCDS(42) | TPCDS-Q41 | orc / snap / block | 0.53 | 0.52 | +0.51% | 2.77% | 2.14% | 20 | +0.10% | 0.77 | 0.65 | | TPCDS(42) | TPCDS-Q51A | orc / snap / block | 108.39 | 108.17 | +0.21% | 0.53% | 0.48% | 20 | +0.19% | 1.33 | 1.29 | | TPCDS(42) | TPCDS-Q12 | orc / snap / block | 1.55 | 1.55 | +0.25% | 2.03% | 2.57% | 20 | +0.12% | 0.63 | 0.34 | | TPCDS(42) | TPCDS-Q23-1 | orc / snap / block | 29.90 | 29.94 | -0.13% | 1.90% | 1.08% | 20 | +0.19% | 0.31 | -0.26 | | TPCDS(42) | TPCDS-Q87 | orc / snap / block | 3.97 | 3.98 | -0.20% | 1.42% | 1.50% | 20 | -0.14% | -0.34 | -0.43 | | TPCDS(42) | TPCDS-Q98 | orc / snap / block | 1.67 | 1.68 | -0.43% | 1.57% | 2.77% | 20 | +0.01% | 0.04 | -0.61 | | TPCDS(42) | TPCDS-Q23-2 | orc / snap / block | 30.27 | 30.68 | -1.34% | 1.15% | 1.78% | 20 | -1.07% | -2.61 | -2.84 | | TPCDS(42) | TPCDS-Q9 | orc / snap / block | 32.49 | 33.05 | -1.68% | 4.84% | 3.06% | 20 | -1.03% | -1.85 | -1.33 | | TPCDS(42) | TPCDS-Q97 | orc / snap / block | 4.98 | 5.06 | -1.58% | 1.19% | 1.25% | 20 | -1.91% | -3.14 | -4.12 | | TPCDS(42) | TPCDS-Q17 | orc / snap / block | 2.97 | 3.03 | -1.89% | 1.43% | 1.34% | 20 | -1.77% | -3.08 | -4.34 | | TPCDS(42) | TPCDS-Q44 | orc / snap / block | 12.22 | 12.59 | -2.91% | 5.53% | 2.16% | 20 | -1.08% | -2.50 | -2.25 | | TPCDS(42) | TPCDS-Q38 | orc / snap / block | 4.99 | 5.09 | -1.97% | 1.48% | 1.13% | 20 | -2.04% | -3.52 | -4.79 | | TPCDS(42) | TPCDS-Q95 | orc / snap / block | 2.77 | 2.84 | -2.50% | 1.17% | 1.00% | 20 | -2.23% | -4.77 | -7.35 | | TPCDS(42) | TPCDS-Q69 | orc / snap / block | 1.97 | 2.05 | -3.64% | 2.23% | 1.99% | 20 | -3.12% | -4.22 | -5.57 | | TPCDS(42) | TPCDS-Q77 | orc / snap / block | 3.20 | 3.33 | -4.05% | 1.26% | 0.70% | 20 | -4.21% | -5.27 | -12.97 | | TPCDS(42) | TPCDS-Q10A | orc / snap / block | 1.99 | 2.07 | -3.98% | * 10.19% * | 4.48% | 20 | -5.41% | -2.90 | -1.65 | | TPCDS(42) | TPCDS-Q99 | orc / snap / block | 2.53 | 2.66 | -4.87% | 1.59% | 1.47% | 20 | -5.78% | -5.15 | -10.35 | | TPCDS(42) | TPCDS-Q25 | orc / snap / block | 2.45 | 2.59 | I -5.62% | 1.53% | 1.24% | 20 | I -6.04% | -5.27 | -13.17 | | TPCDS(42) | TPCDS-Q33 | orc / snap / block | 2.27 | 2.41 | I -5.62% | 1.62% | 1.66% | 20 | I -6.21% | -5.27 | -11.14 | | TPCDS(42) | TPCDS-Q72 | orc / snap / block | 8.28 | 8.95 | I -7.43% | 1.91% | 2.00% | 20 | I -7.93% | -5.27 | -12.46 | | TPCDS(42) | TPCDS-Q60 | orc / snap / block | 2.43 | 2.63 | I -7.50% | 1.60% | 1.06% | 20 | I -8.19% | -5.27 | -18.45 | | TPCDS(42) | TPCDS-Q56 | orc / snap / block | 2.41 | 2.61 | I -7.88% | 1.82% | 1.38% | 20 | I -8.45% | -5.27 | -16.24 | | TPCDS(42) | TPCDS-Q5 | orc / snap / block | 2.83 | 3.09 | I -8.27% | 1.04% | 0.97% | 20 | I -8.95% | -5.27 | -27.14 | | TPCDS(42) | TPCDS-Q49 | orc / snap / block | 3.94 | 4.34 | I -9.12% | 1.78% | 3.05% | 20 | I -10.34% | -5.12 | -11.83 | | TPCDS(42) | TPCDS-Q80 | orc / snap / block | 3.64 | 4.03 | I -9.60% | 1.36% | 0.77% | 20 | I -11.10% | -5.27 | -29.59 | | TPCDS(42) | TPCDS-Q71 | orc / snap / block | 2.11 | 2.37 | I -11.17% | 6.03% | 1.75% | 20 | I -14.75% | -4.71 | -8.87 | | TPCDS(42) | TPCDS-Q66 | orc / snap / block | 3.56 | 4.09 | I -12.97% | 1.94% | 1.64% | 20 | I -14.54% | -5.27 | -24.64 | | TPCDS(42) | TPCDS-Q40 | orc / snap / block | 1.66 | 1.89 | I -12.55% | 1.95% | 1.27% | 20 | I -15.32% | -5.27 | -26.41 | | TPCDS(42) | TPCDS-Q15 | orc / snap / block | 1.50 | 1.74 | I -13.80% | 2.17% | 1.26% | 20 | I -16.92% | -5.27 | -27.31 | | TPCDS(42) | TPCDS-Q20 | orc / snap / block | 1.46 | 1.70 | I -13.93% | 3.15% | 2.48% | 20 | I -17.38% | -5.27 | -16.93 | | TPCDS(42) | TPCDS-Q18 | orc / snap / block | 3.42 | 4.05 | I -15.60% | 2.78% | 3.15% | 20 | I -18.14% | -5.27 | -17.77 | | TPCDS(42) | TPCDS-Q57 | orc / snap / block | 5.15 | 6.36 | I -18.90% | 1.12% | 1.58% | 20 | I -23.51% | -5.27 | -46.25 | | TPCDS(42) | TPCDS-Q16 | orc / snap / block | 1.96 | 2.55 | I -23.02% | 2.43% | 1.41% | 20 | I -30.62% | -5.27 | -43.91 | | TPCDS(42) | TPCDS-Q22 | orc / snap / block | 7.10 | 9.33 | I -23.92% | 0.85% | 1.17% | 20 | I -31.15% | -5.27 | -80.22 | | TPCDS(42) | TPCDS-Q26 | orc / snap / block | 2.00 | 2.65 | I -24.50% | 3.02% | 0.99% | 20 | I -32.81% | -5.27 | -44.02 | | TPCDS(42) | TPCDS-Q14-2 | orc / snap / block | 19.98 | 27.45 | I -27.22% | 0.76% | 1.07% | 20 | I -37.48% | -5.27 | -101.23 | | TPCDS(42) | TPCDS-Q18A | orc / snap / block | 7.57 | 11.04 | I -31.40% | 2.61% | 0.54% | 20 | I -45.87% | -5.27 | -75.01 | | TPCDS(42) | TPCDS-Q32 | orc / snap / block | 1.12 | 1.64 | I -31.96% | 3.89% | 2.57% | 20 | I -46.39% | -5.27 | -38.75 | | TPCDS(42) | TPCDS-Q82 | orc / snap / block | 2.78 | 4.47 | I -37.72% | 3.90% | 1.15% | 20 | I -60.62% | -5.27 | -62.72 | | TPCDS(42) | TPCDS-Q67A | orc / snap / block | 64.00 | 103.93 | I -38.42% | 0.69% | 2.69% | 20 | I -62.00% | -5.27 | -63.08 | | TPCDS(42) | TPCDS-Q75 | orc / snap / block | 10.43 | 17.21 | I -39.40% | 0.59% | 2.18% | 20 | I -64.41% | -5.27 | -79.64 | | TPCDS(42) | TPCDS-Q70A | orc / snap / block | 7.31 | 12.47 | I -41.35% | 0.51% | 1.64% | 20 | I -69.67% | -5.27 | -110.93 | | TPCDS(42) | TPCDS-Q77A | orc / snap / block | 8.96 | 15.40 | I -41.77% | 1.84% | 0.99% | 20 | I -71.29% | -5.27 | -128.31 | | TPCDS(42) | TPCDS-Q22A | orc / snap / block | 3.84 | 7.53 | I -49.01% | 1.35% | 1.30% | 20 | I -95.73% | -5.27 | -149.10 | | TPCDS(42) | TPCDS-Q37 | orc / snap / block | 1.47 | 3.51 | I -58.10% | 2.17% | 0.84% | 20 | I -138.25% | -5.27 | -209.54 | | TPCDS(42) | TPCDS-Q58 | orc / snap / block | 3.04 | 7.81 | I -61.04% | 1.51% | 0.63% | 20 | I -155.62% | -5.27 | -315.84 | | TPCDS(42) | TPCDS-Q80A | orc / snap / block | 9.92 | 25.13 | I -60.51% | 0.49% | 3.77% | 20 | I -157.96% | -5.27 | -71.63 | | TPCDS(42) | TPCDS-Q21 | orc / snap / block | 1.27 | 3.50 | I -63.68% | 3.78% | 2.10% | 20 | I -178.60% | -5.27 | -113.39 | | TPCDS(42) | TPCDS-Q39-1 | orc / snap / block | 1.50 | 8.04 | I -81.36% | 1.72% | 0.62% | 20 | I -434.94% | -5.27 | -522.51 | | TPCDS(42) | TPCDS-Q39-2 | orc / snap / block | 1.49 | 8.04 | I -81.50% | 2.31% | 0.60% | 20 | I -439.16% | -5.27 | -493.82 | +-----------+-------------+--------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+---------+ (R) Regression: TPCDS(42) TPCDS-Q88 [orc / snap / block] (23.08s -> 30.59s [+32.53%]) +--------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+---------+-----------+ | 56:SCAN HDFS | 12.22% | 26.73s | 19.23s | +39.00% | 5.39% | 28.66s | 21.23s | +35.01% | 3 | 3 | 4.63M | 120.96M | | 48:SCAN HDFS | 12.22% | 26.74s | 19.31s | +38.49% | 5.48% | 28.65s | 21.29s | +34.57% | 3 | 3 | 4.04M | 120.96M | | 40:SCAN HDFS | 12.24% | 26.77s | 19.31s | +38.65% | 5.42% | 28.74s | 21.14s | +35.93% | 3 | 3 | 4.04M | 120.96M | | 32:SCAN HDFS | 12.15% | 26.58s | 19.13s | +38.93% | 5.44% | 28.68s | 21.10s | +35.93% | 3 | 3 | 6.94M | 120.96M | | 24:SCAN HDFS | 12.17% | 26.61s | 19.14s | +39.04% | 5.32% | 28.63s | 20.96s | +36.60% | 3 | 3 | 6.92M | 120.96M | | 16:SCAN HDFS | 12.22% | 26.74s | 19.26s | +38.83% | 5.30% | 28.66s | 21.12s | +35.71% | 3 | 3 | 4.62M | 120.96M | | 08:SCAN HDFS | 12.26% | 26.82s | 19.32s | +38.86% | 5.35% | 28.81s | 21.22s | +35.76% | 3 | 3 | 1.21M | 120.96M | | 00:SCAN HDFS | 12.27% | 26.85s | 19.38s | +38.52% | 5.37% | 28.82s | 21.19s | +36.00% | 3 | 3 | 604.52K | 120.96M | +--------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q96 [orc / snap / block] (3.24s -> 4.18s [+28.80%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 99.19% | 3.00s | 2.30s | +30.25% | 6.52% | 3.49s | 2.52s | +38.35% | 3 | 3 | 29.64K | 120.96M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+--------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q27 [orc / snap / block] (2.50s -> 3.11s [+24.21%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 7.19% | 110.52ms | 104.21ms | +6.06% | * 14.20% * | 151.99ms | 151.99ms | +0.00% | 1 | 1 | 27.44K | 97.40K | | 00:SCAN HDFS | 79.49% | 1.22s | 736.18ms | +66.07% | 1.91% | 1.45s | 1.02s | +41.41% | 3 | 3 | 109.10K | 120.96M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q92 [orc / snap / block] (1.22s -> 1.47s [+21.01%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 03:SCAN HDFS | 18.06% | 307.43ms | 274.73ms | +11.90% | 8.15% | 395.99ms | 339.99ms | +16.47% | 3 | 3 | 868.07K | 30.24M | | 01:SCAN HDFS | 52.49% | 893.65ms | 681.24ms | +31.18% | 2.14% | 947.97ms | 719.98ms | +31.67% | 1 | 1 | 29 | 56 | | 00:SCAN HDFS | 22.77% | 387.71ms | 353.32ms | +9.73% | 2.62% | 439.99ms | 387.99ms | +13.40% | 3 | 3 | 962 | 30.24M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q24-1 [orc / snap / block] (11.44s -> 13.58s [+18.71%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 17:SCAN HDFS | 12.21% | 3.52s | 135.78ms | +2494.73% | 2.91% | 3.81s | 399.99ms | +852.00% | 2 | 2 | 633.00K | 633.00K | | 20:HASH JOIN | 7.65% | 2.21s | 2.19s | +0.85% | 2.79% | 4.33s | 4.27s | +1.41% | 3 | 3 | 1.13M | 16.43M | | F12:EXCHANGE SENDER | 2.36% | 681.17ms | 718.92ms | -5.25% | 5.19% | 839.97ms | 927.97ms | -9.48% | 3 | 3 | -1 | -1 | | 14:SCAN HDFS | 9.80% | 2.83s | 2.79s | +1.30% | 2.49% | 3.17s | 3.08s | +2.99% | 3 | 3 | 12.09M | 12.09M | | 15:SCAN HDFS | 10.99% | 3.17s | 93.89ms | +3279.82% | 3.44% | 3.46s | 299.99ms | +1054.67% | 1 | 1 | 11 | 12 | | 13:SCAN HDFS | 20.91% | 6.04s | 4.59s | +31.42% | 8.33% | 8.11s | 6.22s | +30.44% | 3 | 3 | 8.84M | 120.96M | | 00:SCAN HDFS | 25.13% | 7.26s | 5.21s | +39.38% | 9.98% | 9.10s | 5.62s | +61.81% | 3 | 3 | 238.75K | 120.96M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q3 [orc / snap / block] (1.02s -> 1.21s [+18.05%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 01:SCAN HDFS | 88.65% | 276.13ms | 221.61ms | +24.60% | 4.32% | 323.99ms | 279.99ms | +15.71% | 3 | 3 | 36.23K | 120.96M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q46 [orc / snap / block] (2.41s -> 2.84s [+18.09%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | F06:EXCHANGE SENDER | 4.00% | 95.58ms | 96.63ms | -1.09% | 6.17% | 171.99ms | 179.99ms | -4.44% | 2 | 2 | -1 | -1 | | 10:SCAN HDFS | 29.96% | 716.61ms | 717.55ms | -0.13% | 2.22% | 775.97ms | 783.97ms | -1.02% | 2 | 2 | 633.00K | 633.00K | | 09:AGGREGATE | 4.66% | 111.36ms | 104.84ms | +6.22% | * 16.96% * | 187.99ms | 199.99ms | -6.00% | 3 | 3 | 117.10K | 9.41M | | 00:SCAN HDFS | 45.29% | 1.08s | 831.62ms | +30.28% | 2.01% | 1.25s | 963.97ms | +29.46% | 3 | 3 | 1.28M | 120.96M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q42 [orc / snap / block] (0.82s -> 0.97s [+17.30%]) +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q55 [orc / snap / block] (0.83s -> 0.96s [+16.78%]) +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q52 [orc / snap / block] (0.84s -> 0.97s [+16.28%]) +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q48 [orc / snap / block] (2.61s -> 3.07s [+17.25%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 89.99% | 1.29s | 988.60ms | +30.81% | 5.41% | 1.41s | 1.09s | +29.30% | 3 | 3 | 22.07K | 12.10M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+--------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q24-2 [orc / snap / block] (11.21s -> 13.00s [+15.90%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 17:SCAN HDFS | 13.10% | 3.58s | 118.52ms | +2920.43% | 3.26% | 3.88s | 383.99ms | +911.46% | 2 | 2 | 633.00K | 633.00K | | 20:HASH JOIN | 7.87% | 2.15s | 2.15s | -0.03% | 2.93% | 4.26s | 4.34s | -1.75% | 3 | 3 | 1.13M | 16.43M | | F12:EXCHANGE SENDER | 2.52% | 689.38ms | 714.92ms | -3.57% | 6.20% | 843.97ms | 891.97ms | -5.38% | 3 | 3 | -1 | -1 | | 14:SCAN HDFS | 10.51% | 2.87s | 2.77s | +3.62% | 4.09% | 3.23s | 3.02s | +7.02% | 3 | 3 | 12.09M | 12.09M | | 15:SCAN HDFS | 11.75% | 3.21s | 121.89ms | +2535.23% | 3.59% | 3.46s | 555.98ms | +521.58% | 1 | 1 | 11 | 12 | | 13:SCAN HDFS | 19.67% | 5.38s | 4.32s | +24.43% | 6.15% | 7.36s | 6.17s | +19.33% | 3 | 3 | 8.84M | 120.96M | | 00:SCAN HDFS | 22.47% | 6.14s | 4.96s | +23.83% | 8.24% | 8.35s | 5.54s | +50.69% | 3 | 3 | 249.68K | 120.96M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q90 [orc / snap / block] (1.34s -> 1.56s [+15.96%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | 08:SCAN HDFS | 47.47% | 548.26ms | 496.05ms | +10.52% | 5.24% | 659.98ms | 567.98ms | +16.20% | 3 | 3 | 4.83K | 30.24M | | 00:SCAN HDFS | 47.45% | 548.05ms | 493.95ms | +10.95% | 4.31% | 651.98ms | 563.98ms | +15.60% | 3 | 3 | 2.90K | 30.24M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q50 [orc / snap / block] (4.79s -> 5.48s [+14.53%]) +--------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 31.66% | 1.59s | 1.48s | +7.76% | 3.09% | 1.80s | 1.54s | +16.84% | 3 | 3 | 122.96K | 12.09M | | 00:SCAN HDFS | 63.28% | 3.19s | 2.63s | +21.16% | * 15.12% * | 3.83s | 3.16s | +21.14% | 3 | 3 | 1.05M | 120.96M | +--------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q74 [orc / snap / block] (6.89s -> 7.95s [+15.32%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 10.98% | 3.16s | 161.78ms | +1850.42% | 2.43% | 3.48s | 379.99ms | +814.74% | 2 | 2 | 633.00K | 633.00K | | 02:SCAN HDFS | 5.87% | 1.69s | 755.83ms | +123.14% | 3.43% | 1.96s | 1.04s | +88.80% | 3 | 3 | 22.83M | 120.96M | | 15:SCAN HDFS | 16.10% | 4.63s | 3.90s | +18.52% | 1.78% | 4.96s | 4.18s | +18.45% | 2 | 2 | 631.57K | 633.00K | | 16:SCAN HDFS | 14.63% | 4.20s | 3.52s | +19.60% | 2.26% | 4.76s | 3.86s | +23.32% | 3 | 3 | 6.01M | 30.24M | | 08:SCAN HDFS | 19.75% | 5.67s | 4.81s | +17.99% | 1.54% | 5.94s | 5.10s | +16.55% | 2 | 2 | 344.97K | 633.00K | | 09:SCAN HDFS | 16.01% | 4.60s | 3.88s | +18.41% | 2.70% | 5.31s | 4.19s | +26.72% | 3 | 3 | 12.31M | 120.96M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q43 [orc / snap / block] (1.34s -> 1.54s [+14.81%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | 05:AGGREGATE | 40.86% | 207.08ms | 194.31ms | +6.57% | 5.81% | 275.99ms | 247.99ms | +11.29% | 3 | 3 | 60 | 610 | | 04:HASH JOIN | 16.95% | 85.89ms | 78.10ms | +9.97% | * 12.55% * | 128.00ms | 116.00ms | +10.34% | 3 | 3 | 7.55M | 23.93M | | 03:HASH JOIN | 21.20% | 107.43ms | 107.15ms | +0.26% | * 10.11% * | 163.99ms | 143.99ms | +13.89% | 3 | 3 | 7.55M | 24.74M | | 01:SCAN HDFS | 19.09% | 96.77ms | 74.38ms | +30.09% | * 10.73% * | 151.99ms | 132.00ms | +15.15% | 3 | 3 | 7.55M | 120.96M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q79 [orc / snap / block] (1.67s -> 1.91s [+14.52%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | F05:EXCHANGE SENDER | 12.95% | 114.94ms | 115.26ms | -0.27% | 7.30% | 195.99ms | 207.99ms | -5.77% | 2 | 2 | -1 | -1 | | 07:AGGREGATE | 20.83% | 184.84ms | 170.59ms | +8.35% | 9.45% | 251.99ms | 251.99ms | -0.00% | 3 | 3 | 339.96K | 538.68K | | 04:HASH JOIN | 8.19% | 72.70ms | 69.40ms | +4.75% | * 13.14% * | 116.00ms | 112.00ms | +3.57% | 3 | 3 | 3.65M | 11.81M | | 00:SCAN HDFS | 21.92% | 194.52ms | 118.52ms | +64.12% | 9.76% | 267.99ms | 211.99ms | +26.42% | 3 | 3 | 3.65M | 120.96M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q86A [orc / snap / block] (2.65s -> 3.00s [+13.22%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | 12:AGGREGATE | 8.50% | 383.71ms | 370.51ms | +3.56% | 5.92% | 527.98ms | 459.98ms | +14.78% | 3 | 3 | 416 | 990 | | 11:HASH JOIN | 2.23% | 100.84ms | 95.08ms | +6.05% | * 11.87% * | 179.99ms | 136.00ms | +32.35% | 3 | 3 | 6.08M | 29.95M | | 10:HASH JOIN | 7.91% | 356.90ms | 321.18ms | +11.12% | 5.28% | 483.98ms | 419.99ms | +15.24% | 3 | 3 | 6.08M | 29.95M | | 07:SCAN HDFS | 12.41% | 559.84ms | 479.00ms | +16.88% | * 11.71% * | 851.97ms | 687.98ms | +23.84% | 3 | 3 | 6.08M | 30.24M | | 19:AGGREGATE | 8.87% | 400.48ms | 359.64ms | +11.36% | 5.76% | 479.98ms | 423.99ms | +13.21% | 3 | 3 | 416 | 990 | | 18:HASH JOIN | 2.20% | 99.29ms | 95.08ms | +4.43% | * 13.74% * | 144.00ms | 128.00ms | +12.50% | 3 | 3 | 6.08M | 29.95M | | 17:HASH JOIN | 7.75% | 349.67ms | 328.55ms | +6.43% | 5.36% | 435.99ms | 411.99ms | +5.83% | 3 | 3 | 6.08M | 29.95M | | 14:SCAN HDFS | 12.25% | 552.89ms | 451.77ms | +22.38% | * 11.60% * | 823.97ms | 623.98ms | +32.05% | 3 | 3 | 6.08M | 30.24M | | 06:AGGREGATE | 8.61% | 388.69ms | 360.20ms | +7.91% | 6.60% | 511.98ms | 475.98ms | +7.56% | 3 | 3 | 416 | 990 | | 05:HASH JOIN | 2.24% | 101.12ms | 91.79ms | +10.17% | * 11.45% * | 151.99ms | 132.00ms | +15.15% | 3 | 3 | 6.08M | 29.95M | | 04:HASH JOIN | 7.66% | 345.88ms | 328.41ms | +5.32% | 3.20% | 415.99ms | 415.99ms | +0.00% | 3 | 3 | 6.08M | 29.95M | | 01:SCAN HDFS | 12.48% | 563.21ms | 483.00ms | +16.61% | * 14.18% * | 831.97ms | 643.98ms | +29.19% | 3 | 3 | 6.08M | 30.24M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q62 [orc / snap / block] (1.91s -> 2.16s [+13.22%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | 09:AGGREGATE | 39.73% | 315.78ms | 306.59ms | +3.00% | 5.07% | 371.99ms | 359.99ms | +3.33% | 3 | 3 | 432 | 120 | | 08:HASH JOIN | 11.31% | 89.89ms | 81.75ms | +9.96% | * 11.61% * | 140.00ms | 120.00ms | +16.67% | 3 | 3 | 6.07M | 30.24M | | 07:HASH JOIN | 9.59% | 76.21ms | 70.59ms | +7.95% | 9.67% | 104.00ms | 120.00ms | -13.33% | 3 | 3 | 6.07M | 30.24M | | 06:HASH JOIN | 9.66% | 76.77ms | 70.31ms | +9.18% | * 11.43% * | 124.00ms | 104.00ms | +19.23% | 3 | 3 | 6.07M | 30.24M | | 05:HASH JOIN | 12.47% | 99.08ms | 107.51ms | -7.83% | 9.03% | 136.00ms | 155.99ms | -12.82% | 3 | 3 | 6.07M | 30.24M | | 00:SCAN HDFS | 13.67% | 108.63ms | 49.47ms | +119.57% | 8.00% | 199.99ms | 96.00ms | +108.33% | 3 | 3 | 6.07M | 30.24M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q8 [orc / snap / block] (1.20s -> 1.35s [+12.77%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | F06:EXCHANGE SENDER | 5.92% | 81.68ms | 77.47ms | +5.43% | * 15.51% * | 108.00ms | 92.00ms | +17.39% | 1 | 1 | -1 | -1 | | 06:SCAN HDFS | 22.45% | 309.88ms | 301.25ms | +2.87% | * 10.18% * | 383.99ms | 383.99ms | -0.00% | 2 | 2 | 299.21K | 305.48K | | 02:SCAN HDFS | 55.94% | 771.97ms | 745.24ms | +3.59% | 4.50% | 851.97ms | 783.97ms | +8.67% | 1 | 1 | 29 | 118 | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q73 [orc / snap / block] (1.15s -> 1.29s [+12.59%]) +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 00:SCAN HDFS | 46.51% | 83.08ms | 83.16ms | -0.08% | * 20.45% * | 144.00ms | 124.00ms | +16.13% | 3 | 3 | 210.98K | 120.96M | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q91 [orc / snap / block] (1.19s -> 1.33s [+12.23%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 05:SCAN HDFS | 6.77% | 112.84ms | 142.10ms | -20.59% | * 30.98% * | 183.99ms | 199.99ms | -8.00% | 1 | 1 | 109.76K | 108.19K | | 03:SCAN HDFS | 50.53% | 841.66ms | 699.77ms | +20.28% | 6.91% | 967.97ms | 779.97ms | +24.10% | 2 | 2 | 633 | 633.00K | | 01:SCAN HDFS | 31.04% | 516.96ms | 587.35ms | -11.98% | * 12.98% * | 731.98ms | 707.98ms | +3.39% | 3 | 3 | 68 | 6.05M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q64 [orc / snap / block] (10.97s -> 12.34s [+12.51%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | 43:HASH JOIN | 3.99% | 3.41s | 3.56s | -4.12% | 3.62% | 3.78s | 4.21s | -10.17% | 3 | 3 | 6.05M | 35.51M | | 54:SCAN HDFS | 6.16% | 5.26s | 62.10ms | +8377.31% | 2.30% | 5.48s | 159.99ms | +3327.51% | 1 | 1 | 7.20K | 7.20K | | 49:SCAN HDFS | 6.07% | 5.19s | 119.26ms | +4253.50% | 4.16% | 5.66s | 355.99ms | +1491.02% | 2 | 2 | 633.00K | 633.00K | | 53:SCAN HDFS | 5.97% | 5.11s | 81.47ms | +6167.46% | 3.19% | 5.33s | 227.99ms | +2236.85% | 1 | 1 | 7.20K | 7.20K | | 59:SCAN HDFS | 7.82% | 6.69s | 83.79ms | +7880.67% | 4.57% | 7.16s | 120.00ms | +5870.02% | 1 | 1 | 37 | 1.11K | | 39:SCAN HDFS | 3.06% | 2.61s | 5.38s | -51.42% | 3.27% | 3.45s | 7.74s | -55.43% | 3 | 3 | 11.21K | 120.96M | | 40:SCAN HDFS | 10.38% | 8.88s | 8.48s | +4.70% | 1.09% | 9.53s | 9.65s | -1.24% | 3 | 3 | 1.55M | 12.09M | | 04:HASH JOIN | 4.55% | 3.89s | 4.83s | -19.42% | 2.60% | 4.30s | 5.56s | -22.66% | 3 | 3 | 6.05M | 35.51M | | 15:SCAN HDFS | 5.95% | 5.09s | 73.47ms | +6827.24% | 2.55% | 5.44s | 143.99ms | +3675.01% | 1 | 1 | 7.20K | 7.20K | | 10:SCAN HDFS | 5.85% | 5.00s | 96.42ms | +5090.63% | 3.10% | 5.56s | 283.99ms | +1856.34% | 2 | 2 | 633.00K | 633.00K | | 14:SCAN HDFS | 5.85% | 5.00s | 70.10ms | +7032.45% | 2.74% | 5.22s | 151.99ms | +3336.85% | 1 | 1 | 7.20K | 7.20K | | 20:SCAN HDFS | 8.25% | 7.06s | 97.26ms | +7154.56% | 2.03% | 7.27s | 139.99ms | +5091.44% | 1 | 1 | 37 | 1.11K | | 00:SCAN HDFS | 3.07% | 2.63s | 5.32s | -50.59% | 3.71% | 3.38s | 7.47s | -54.71% | 3 | 3 | 17.99K | 120.96M | | 01:SCAN HDFS | 10.33% | 8.83s | 8.53s | +3.58% | 0.89% | 9.33s | 9.45s | -1.27% | 3 | 3 | 1.53M | 12.09M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q61 [orc / snap / block] (1.74s -> 1.95s [+11.67%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 17:SCAN HDFS | 37.67% | 1.12s | 1.04s | +7.65% | 2.42% | 1.20s | 1.10s | +9.09% | 2 | 2 | 230.48K | 633.00K | | 14:SCAN HDFS | 4.02% | 119.36ms | 98.73ms | +20.90% | * 14.40% * | 175.99ms | 163.99ms | +7.32% | 3 | 3 | 12.87K | 120.96M | | 04:SCAN HDFS | 43.71% | 1.30s | 1.21s | +7.46% | 2.12% | 1.38s | 1.28s | +7.50% | 2 | 2 | 230.48K | 633.00K | | 00:SCAN HDFS | 3.66% | 108.70ms | 83.86ms | +29.62% | * 10.05% * | 175.99ms | 144.00ms | +22.22% | 3 | 3 | 12.87K | 120.96M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q86 [orc / snap / block] (1.72s -> 1.92s [+11.83%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | 05:AGGREGATE | 56.89% | 430.16ms | 425.81ms | +1.02% | 4.00% | 515.98ms | 479.98ms | +7.50% | 3 | 3 | 438 | 1.00K | | 03:HASH JOIN | 22.67% | 171.43ms | 169.47ms | +1.16% | 7.24% | 235.99ms | 203.99ms | +15.69% | 3 | 3 | 6.02M | 29.95M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q1 [orc / snap / block] (2.30s -> 2.58s [+12.09%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 23:AGGREGATE | 4.59% | 195.22ms | 208.91ms | -6.55% | 8.52% | 239.99ms | 247.99ms | -3.23% | 3 | 3 | 2.22M | 2.26M | | F06:EXCHANGE SENDER | 3.78% | 161.12ms | 159.99ms | +0.70% | 6.53% | 215.99ms | 211.99ms | +1.89% | 3 | 3 | -1 | -1 | | 09:AGGREGATE | 4.45% | 189.33ms | 185.40ms | +2.12% | 8.93% | 267.99ms | 255.99ms | +4.69% | 3 | 3 | 2.29M | 2.26M | | 06:SCAN HDFS | 3.60% | 153.19ms | 102.73ms | +49.11% | * 87.89% * | 1.56s | 179.99ms | +764.44% | 3 | 3 | 2.34M | 12.09M | | F04:EXCHANGE SENDER | 2.25% | 95.79ms | 95.05ms | +0.78% | * 11.13% * | 179.99ms | 155.99ms | +15.38% | 2 | 2 | -1 | -1 | | 04:SCAN HDFS | 36.91% | 1.57s | 1.45s | +8.32% | * 13.41% * | 2.43s | 1.52s | +59.32% | 1 | 1 | 21 | 39 | | 00:SCAN HDFS | 30.31% | 1.29s | 1.24s | +3.80% | * 14.42% * | 2.08s | 1.39s | +49.43% | 3 | 3 | 802.52K | 12.09M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q45 [orc / snap / block] (2.12s -> 2.35s [+10.83%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | F04:EXCHANGE SENDER | 3.53% | 81.47ms | 78.10ms | +4.31% | * 12.66% * | 104.00ms | 104.00ms | +0.00% | 1 | 1 | -1 | -1 | | 01:SCAN HDFS | 59.32% | 1.37s | 1.32s | +3.87% | 1.49% | 1.43s | 1.36s | +4.69% | 2 | 2 | 633.00K | 633.00K | | 00:SCAN HDFS | 25.75% | 594.01ms | 532.19ms | +11.62% | 3.75% | 687.98ms | 599.98ms | +14.67% | 3 | 3 | 875.40K | 30.24M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q83 [orc / snap / block] (1.92s -> 2.12s [+10.60%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 14:SCAN HDFS | 2.56% | 148.84ms | 102.10ms | +45.77% | * 43.48% * | 295.99ms | 223.99ms | +32.14% | 1 | 1 | 3 | 3 | | 12:SCAN HDFS | 18.57% | 1.08s | 1.03s | +4.34% | 6.71% | 1.22s | 1.14s | +6.67% | 1 | 1 | 21 | 73.05K | | 24:SCAN HDFS | 2.85% | 165.68ms | 132.21ms | +25.32% | * 39.32% * | 311.99ms | 227.99ms | +36.84% | 1 | 1 | 3 | 3 | | 22:SCAN HDFS | 18.20% | 1.06s | 974.70ms | +8.36% | 8.65% | 1.34s | 1.10s | +21.01% | 1 | 1 | 21 | 73.05K | | 04:SCAN HDFS | 2.47% | 143.36ms | 113.26ms | +26.58% | * 46.77% * | 279.99ms | 219.99ms | +27.27% | 1 | 1 | 3 | 3 | | 02:SCAN HDFS | 17.29% | 1.00s | 910.07ms | +10.29% | 8.42% | 1.20s | 1.05s | +14.45% | 1 | 1 | 21 | 73.05K | | 06:HASH JOIN | 2.41% | 140.00ms | 145.82ms | -3.99% | 6.77% | 171.99ms | 195.99ms | -12.24% | 3 | 3 | 4.92M | 11.97M | | 01:SCAN HDFS | 24.88% | 1.44s | 1.24s | +16.20% | 3.73% | 1.53s | 1.30s | +17.18% | 1 | 1 | 21.92K | 54.00K | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q4 [orc / snap / block] (14.01s -> 15.42s [+10.05%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | 36:SCAN HDFS | 7.43% | 5.41s | 362.83ms | +1391.82% | 2.44% | 5.77s | 1.62s | +256.30% | 2 | 2 | 633.00K | 633.00K | | 01:SCAN HDFS | 9.10% | 6.63s | 389.14ms | +1604.73% | 1.88% | 7.00s | 1.66s | +322.71% | 2 | 2 | 633.00K | 633.00K | | 02:SCAN HDFS | 6.14% | 4.47s | 1.49s | +199.34% | 3.37% | 4.88s | 2.70s | +81.01% | 3 | 3 | 22.98M | 120.96M | | 15:SCAN HDFS | 12.32% | 8.98s | 375.04ms | +2293.74% | 0.75% | 9.19s | 1.62s | +467.16% | 2 | 2 | 633.00K | 633.00K | | 16:SCAN HDFS | 10.07% | 7.34s | 3.42s | +114.79% | 1.84% | 8.12s | 4.62s | +75.84% | 3 | 3 | 12.03M | 60.48M | | 29:SCAN HDFS | 12.08% | 8.81s | 9.12s | -3.43% | 1.02% | 9.29s | 9.50s | -2.19% | 2 | 2 | 633.00K | 633.00K | | 08:SCAN HDFS | 11.97% | 8.73s | 9.16s | -4.76% | 0.90% | 9.04s | 9.46s | -4.36% | 2 | 2 | 633.00K | 633.00K | | 09:SCAN HDFS | 9.95% | 7.25s | 275.50ms | +2532.63% | 1.11% | 7.58s | 647.98ms | +1069.75% | 3 | 3 | 23.09M | 120.96M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q36 [orc / snap / block] (2.63s -> 2.88s [+9.47%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | 07:AGGREGATE | 51.22% | 688.05ms | 648.89ms | +6.03% | 3.70% | 791.97ms | 779.97ms | +1.54% | 3 | 3 | 438 | 1.00K | | 06:HASH JOIN | 18.58% | 249.61ms | 234.94ms | +6.24% | 6.45% | 331.99ms | 327.99ms | +1.22% | 3 | 3 | 7.85M | 15.66M | | 05:HASH JOIN | 6.74% | 90.59ms | 73.75ms | +22.84% | 9.91% | 120.00ms | 108.00ms | +11.11% | 3 | 3 | 7.85M | 15.82M | | 04:HASH JOIN | 8.64% | 116.07ms | 117.33ms | -1.08% | * 12.25% * | 179.99ms | 183.99ms | -2.17% | 3 | 3 | 7.85M | 24.74M | | 00:SCAN HDFS | 10.64% | 142.94ms | 100.56ms | +42.15% | * 10.36% * | 219.99ms | 175.99ms | +25.00% | 3 | 3 | 7.85M | 120.96M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q68 [orc / snap / block] (1.62s -> 1.77s [+9.61%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | F06:EXCHANGE SENDER | 7.31% | 94.10ms | 91.89ms | +2.41% | 8.17% | 167.99ms | 167.99ms | +0.00% | 2 | 2 | -1 | -1 | | 10:SCAN HDFS | 57.09% | 735.03ms | 728.08ms | +0.95% | 4.29% | 815.97ms | 847.97ms | -3.77% | 2 | 2 | 633.00K | 633.00K | | 00:SCAN HDFS | 15.64% | 201.40ms | 260.69ms | -22.75% | * 10.67% * | 275.99ms | 495.98ms | -44.35% | 3 | 3 | 289.03K | 120.96M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q34 [orc / snap / block] (1.57s -> 1.72s [+9.38%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 00:SCAN HDFS | 69.83% | 401.67ms | 250.80ms | +60.16% | 3.31% | 475.98ms | 343.99ms | +38.37% | 3 | 3 | 741.08K | 120.96M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q59 [orc / snap / block] (2.72s -> 2.98s [+9.41%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 11:AGGREGATE | 5.58% | 414.16ms | 403.21ms | +2.72% | 3.35% | 475.98ms | 479.98ms | -0.83% | 3 | 3 | 9.70K | 649.16K | | 10:HASH JOIN | 3.29% | 244.20ms | 242.73ms | +0.61% | 4.60% | 299.99ms | 303.99ms | -1.32% | 3 | 3 | 23.46M | 120.96M | | 09:SCAN HDFS | 11.26% | 836.39ms | 762.08ms | +9.75% | 7.62% | 927.97ms | 823.97ms | +12.62% | 1 | 1 | 371 | 73.05K | | 04:SCAN HDFS | 22.38% | 1.66s | 1.48s | +12.58% | 3.56% | 1.78s | 1.60s | +11.78% | 1 | 1 | 118 | 118 | | 05:SCAN HDFS | 22.63% | 1.68s | 1.47s | +14.02% | 3.65% | 1.79s | 1.52s | +17.59% | 1 | 1 | 365 | 7.30K | | 03:AGGREGATE | 5.79% | 430.09ms | 405.25ms | +6.13% | 2.69% | 511.98ms | 459.98ms | +11.30% | 3 | 3 | 9.70K | 649.16K | | 02:HASH JOIN | 3.18% | 236.41ms | 235.08ms | +0.57% | 4.59% | 287.99ms | 315.99ms | -8.86% | 3 | 3 | 23.49M | 120.96M | | 01:SCAN HDFS | 21.02% | 1.56s | 1.40s | +11.49% | 4.03% | 1.70s | 1.51s | +12.70% | 1 | 1 | 371 | 73.05K | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q11 [orc / snap / block] (9.36s -> 10.24s [+9.39%]) +--------------+------------+----------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | 23:SCAN HDFS | 2.43% | 905.37ms | 1.30s | -30.59% | * 15.31% * | 1.54s | 1.82s | -15.35% | 3 | 3 | 6.05M | 30.24M | | 01:SCAN HDFS | 9.48% | 3.53s | 118.21ms | +2884.87% | 1.80% | 3.76s | 619.98ms | +507.10% | 2 | 2 | 633.00K | 633.00K | | 02:SCAN HDFS | 5.28% | 1.96s | 1.03s | +89.87% | 3.47% | 2.34s | 1.33s | +75.90% | 3 | 3 | 22.83M | 120.96M | | 15:SCAN HDFS | 15.85% | 5.90s | 5.38s | +9.62% | 0.88% | 6.16s | 5.66s | +8.76% | 2 | 2 | 631.57K | 633.00K | | 16:SCAN HDFS | 15.25% | 5.68s | 5.14s | +10.36% | 1.41% | 6.02s | 5.60s | +7.57% | 3 | 3 | 6.01M | 30.24M | | 08:SCAN HDFS | 19.78% | 7.36s | 6.67s | +10.31% | 1.06% | 7.61s | 6.90s | +10.20% | 2 | 2 | 344.97K | 633.00K | | 09:SCAN HDFS | 16.60% | 6.17s | 5.55s | +11.28% | 1.74% | 6.50s | 5.93s | +9.72% | 3 | 3 | 12.31M | 120.96M | +--------------+------------+----------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q19 [orc / snap / block] (1.19s -> 1.30s [+9.78%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | F05:EXCHANGE SENDER | 6.62% | 92.21ms | 86.31ms | +6.83% | * 13.75% * | 120.00ms | 104.00ms | +15.38% | 1 | 1 | -1 | -1 | | 03:SCAN HDFS | 59.05% | 822.29ms | 721.24ms | +14.01% | 3.52% | 891.97ms | 827.97ms | +7.73% | 2 | 2 | 633.00K | 633.00K | | 01:SCAN HDFS | 18.48% | 257.32ms | 275.71ms | -6.67% | * 15.34% * | 395.99ms | 419.99ms | -5.71% | 3 | 3 | 62.61K | 120.96M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q13 [orc / snap / block] (4.97s -> 5.44s [+9.38%]) +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 02:SCAN HDFS | 5.82% | 76.00ms | 81.47ms | -6.72% | * 12.78% * | 104.00ms | 96.00ms | +8.33% | 1 | 1 | 164.64K | 181.75K | | 00:SCAN HDFS | 84.91% | 1.11s | 908.32ms | +22.03% | 4.66% | 1.52s | 1.20s | +26.33% | 3 | 3 | 2.88K | 12.10M | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q94 [orc / snap / block] (1.67s -> 1.81s [+8.22%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 21.75% | 499.42ms | 530.86ms | -5.92% | 8.06% | 623.98ms | 599.98ms | +4.00% | 3 | 3 | 3.19K | 30.24M | | 04:SCAN HDFS | 67.32% | 1.55s | 1.42s | +8.69% | 2.14% | 1.64s | 1.52s | +7.92% | 3 | 3 | 33.16K | 30.24M | | F00:EXCHANGE SENDER | 4.76% | 109.40ms | 103.86ms | +5.34% | 4.69% | 140.00ms | 144.00ms | -2.78% | 3 | 3 | -1 | -1 | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q6 [orc / snap / block] (1.91s -> 2.07s [+8.56%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 03:SCAN HDFS | 29.98% | 1.38s | 1.31s | +5.31% | 1.40% | 1.41s | 1.35s | +4.14% | 1 | 1 | 31 | 73.05K | | 01:SCAN HDFS | 31.30% | 1.44s | 1.37s | +5.17% | 1.20% | 1.54s | 1.42s | +8.17% | 2 | 2 | 633.00K | 633.00K | | 04:SCAN HDFS | 29.41% | 1.36s | 1.30s | +4.02% | 1.47% | 1.40s | 1.33s | +5.41% | 1 | 1 | 53.96K | 54.00K | | 02:SCAN HDFS | 2.92% | 134.66ms | 126.59ms | +6.37% | 8.04% | 159.99ms | 155.99ms | +2.56% | 3 | 3 | 1.21M | 120.96M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q30 [orc / snap / block] (2.41s -> 2.59s [+7.63%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | F09:EXCHANGE SENDER | 2.86% | 128.21ms | 136.42ms | -6.02% | * 16.74% * | 175.99ms | 175.99ms | +0.00% | 1 | 1 | -1 | -1 | | 10:SCAN HDFS | 2.37% | 106.52ms | 70.31ms | +51.50% | * 52.70% * | 207.99ms | 159.99ms | +30.00% | 1 | 1 | 316.00K | 316.00K | | 06:SCAN HDFS | 2.87% | 129.05ms | 67.16ms | +92.16% | * 49.81% * | 271.99ms | 124.00ms | +119.35% | 1 | 1 | 10.00K | 6.01K | | 07:SCAN HDFS | 4.38% | 196.73ms | 235.04ms | -16.30% | 9.46% | 355.99ms | 395.99ms | -10.10% | 2 | 2 | 20.12K | 633.00K | | 02:SCAN HDFS | 39.74% | 1.78s | 1.76s | +1.34% | 3.49% | 1.88s | 1.86s | +1.29% | 1 | 1 | 315.45K | 316.00K | | 00:SCAN HDFS | 33.36% | 1.50s | 1.57s | -4.50% | 2.66% | 1.67s | 1.73s | -3.47% | 3 | 3 | 17.70K | 3.02M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q2 [orc / snap / block] (2.61s -> 2.81s [+7.77%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 13:AGGREGATE | 5.39% | 296.27ms | 291.43ms | +1.66% | 7.40% | 371.99ms | 395.99ms | -6.06% | 3 | 3 | 159 | 10.64K | | 12:HASH JOIN | 4.80% | 263.71ms | 267.01ms | -1.24% | 6.83% | 331.99ms | 335.99ms | -1.19% | 3 | 3 | 18.19M | 90.71M | | 11:SCAN HDFS | 8.06% | 442.72ms | 436.41ms | +1.45% | 7.09% | 495.98ms | 479.98ms | +3.33% | 1 | 1 | 371 | 73.05K | | 10:SCAN HDFS | 2.49% | 136.63ms | 160.77ms | -15.02% | * 21.24% * | 271.99ms | 279.99ms | -2.86% | 3 | 3 | 12.79M | 60.48M | | 09:SCAN HDFS | 3.64% | 199.92ms | 182.24ms | +9.70% | * 16.23% * | 467.98ms | 499.98ms | -6.40% | 3 | 3 | 6.11M | 30.24M | | 06:SCAN HDFS | 30.29% | 1.66s | 1.50s | +10.66% | 1.87% | 1.71s | 1.59s | +7.54% | 1 | 1 | 365 | 373 | | 05:AGGREGATE | 4.97% | 273.18ms | 257.75ms | +5.99% | 6.25% | 339.99ms | 319.99ms | +6.25% | 3 | 3 | 159 | 10.64K | | 04:HASH JOIN | 4.71% | 258.94ms | 264.20ms | -1.99% | 6.35% | 319.99ms | 339.99ms | -5.88% | 3 | 3 | 18.57M | 90.71M | | 03:SCAN HDFS | 29.40% | 1.61s | 1.45s | +11.61% | 2.25% | 1.68s | 1.54s | +9.09% | 1 | 1 | 371 | 73.05K | | 02:SCAN HDFS | 2.88% | 158.45ms | 157.75ms | +0.44% | * 10.90% * | 223.99ms | 259.99ms | -13.85% | 3 | 3 | 13.32M | 60.48M | | 01:SCAN HDFS | 2.71% | 148.70ms | 116.35ms | +27.80% | * 17.27% * | 363.99ms | 311.99ms | +16.67% | 3 | 3 | 6.22M | 30.24M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q84 [orc / snap / block] (1.49s -> 1.61s [+8.15%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | F06:EXCHANGE SENDER | 4.36% | 163.78ms | 152.42ms | +7.46% | * 10.70% * | 203.99ms | 199.99ms | +2.00% | 1 | 1 | -1 | -1 | | 03:SCAN HDFS | 27.35% | 1.03s | 1.01s | +1.56% | 2.37% | 1.08s | 1.05s | +2.66% | 1 | 1 | 1.44K | 7.20K | | 00:SCAN HDFS | 30.31% | 1.14s | 1.05s | +8.15% | 2.42% | 1.24s | 1.12s | +10.71% | 2 | 2 | 1.04K | 633.00K | | 05:SCAN HDFS | 36.18% | 1.36s | 1.24s | +9.48% | 1.60% | 1.45s | 1.31s | +10.37% | 3 | 3 | 6.41K | 12.09M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q89 [orc / snap / block] (2.09s -> 2.23s [+6.75%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 07:AGGREGATE | 17.72% | 181.54ms | 227.71ms | -20.28% | * 12.16% * | 295.99ms | 355.99ms | -16.85% | 3 | 3 | 16.52K | 443.25K | | 01:SCAN HDFS | 65.18% | 667.70ms | 423.70ms | +57.59% | 7.84% | 779.97ms | 567.98ms | +37.32% | 3 | 3 | 1.63M | 120.96M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q28 [orc / snap / block] (25.89s -> 27.48s [+6.12%]) +--------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+-------+-----------+ | 15:SCAN HDFS | 16.63% | 25.13s | 22.77s | +10.35% | 6.68% | 28.08s | 27.02s | +3.95% | 3 | 3 | 1.27M | 12.10M | | 12:SCAN HDFS | 16.61% | 25.09s | 22.76s | +10.26% | 6.66% | 27.93s | 26.88s | +3.91% | 3 | 3 | 1.54M | 12.10M | | 09:SCAN HDFS | 16.61% | 25.09s | 22.73s | +10.41% | 6.60% | 28.04s | 26.91s | +4.21% | 3 | 3 | 1.34M | 12.10M | | 06:SCAN HDFS | 16.60% | 25.09s | 22.73s | +10.36% | 6.61% | 27.96s | 26.97s | +3.66% | 3 | 3 | 1.19M | 12.10M | | 03:SCAN HDFS | 16.58% | 25.06s | 22.71s | +10.36% | 6.71% | 28.02s | 26.82s | +4.47% | 3 | 3 | 1.49M | 12.10M | | 00:SCAN HDFS | 16.58% | 25.05s | 22.71s | +10.30% | 6.62% | 27.97s | 26.77s | +4.50% | 3 | 3 | 1.54M | 12.10M | +--------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+-------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q85 [orc / snap / block] (2.58s -> 2.73s [+5.89%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 05:SCAN HDFS | 3.08% | 147.99ms | 76.21ms | +94.20% | * 58.16% * | 275.99ms | 112.00ms | +146.43% | 1 | 1 | 70.20K | 54.91K | | 04:SCAN HDFS | 3.51% | 168.63ms | 156.42ms | +7.81% | * 28.23% * | 243.99ms | 215.99ms | +12.96% | 1 | 1 | 164.64K | 181.75K | | 03:SCAN HDFS | 10.92% | 524.82ms | 485.67ms | +8.06% | * 16.09% * | 731.97ms | 635.98ms | +15.09% | 1 | 1 | 164.64K | 181.75K | | 00:SCAN HDFS | 32.23% | 1.55s | 1.43s | +8.19% | 3.71% | 1.74s | 1.63s | +7.13% | 3 | 3 | 212.05K | 3.02M | | 01:SCAN HDFS | 43.72% | 2.10s | 1.98s | +6.04% | 2.56% | 2.30s | 2.23s | +3.05% | 3 | 3 | 3.85K | 3.02M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q47 [orc / snap / block] (8.72s -> 9.23s [+5.78%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 30:AGGREGATE | 16.09% | 3.43s | 3.31s | +3.69% | 1.97% | 3.76s | 3.78s | -0.42% | 3 | 3 | 368.76K | 28.51M | | 29:HASH JOIN | 2.27% | 484.76ms | 457.60ms | +5.93% | 5.10% | 607.98ms | 563.98ms | +7.80% | 3 | 3 | 27.68M | 28.51M | | 28:HASH JOIN | 6.87% | 1.46s | 1.39s | +5.76% | 2.69% | 1.64s | 1.61s | +1.99% | 3 | 3 | 28.18M | 28.51M | | 24:SCAN HDFS | 3.77% | 802.99ms | 498.37ms | +61.12% | 9.29% | 1.18s | 671.98ms | +76.19% | 3 | 3 | 28.18M | 120.96M | | 07:AGGREGATE | 15.99% | 3.41s | 3.31s | +3.03% | 1.71% | 3.71s | 3.80s | -2.42% | 3 | 3 | 368.76K | 28.51M | | 06:HASH JOIN | 2.25% | 480.69ms | 464.62ms | +3.46% | 6.47% | 583.98ms | 567.98ms | +2.82% | 3 | 3 | 27.68M | 28.51M | | 05:HASH JOIN | 6.80% | 1.45s | 1.38s | +4.77% | 2.76% | 1.68s | 1.66s | +1.20% | 3 | 3 | 28.18M | 28.51M | | 01:SCAN HDFS | 3.78% | 805.52ms | 539.91ms | +49.19% | * 10.60% * | 1.22s | 779.97ms | +56.41% | 3 | 3 | 28.18M | 120.96M | | 20:AGGREGATE | 15.99% | 3.41s | 3.30s | +3.28% | 1.62% | 3.68s | 3.72s | -0.97% | 3 | 3 | 368.76K | 28.51M | | 19:HASH JOIN | 2.20% | 469.67ms | 458.86ms | +2.36% | 4.13% | 595.98ms | 567.98ms | +4.93% | 3 | 3 | 27.68M | 28.51M | | 18:HASH JOIN | 6.78% | 1.45s | 1.40s | +3.26% | 3.31% | 1.56s | 1.60s | -2.26% | 3 | 3 | 28.18M | 28.51M | | 17:HASH JOIN | 2.02% | 430.30ms | 401.81ms | +7.09% | 4.66% | 507.98ms | 515.98ms | -1.55% | 3 | 3 | 28.18M | 28.78M | | 14:SCAN HDFS | 3.70% | 789.73ms | 488.26ms | +61.74% | 9.09% | 1.15s | 847.97ms | +35.38% | 3 | 3 | 28.18M | 120.96M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q65 [orc / snap / block] (4.74s -> 5.01s [+5.69%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | F05:EXCHANGE SENDER | 3.61% | 315.71ms | 315.22ms | +0.16% | 2.61% | 359.99ms | 355.99ms | +1.12% | 3 | 3 | -1 | -1 | | 05:AGGREGATE | 13.50% | 1.18s | 1.16s | +2.10% | 2.89% | 1.33s | 1.33s | +0.00% | 3 | 3 | 4.89M | 3.33M | | 04:HASH JOIN | 3.36% | 293.74ms | 290.31ms | +1.18% | 7.14% | 363.99ms | 383.99ms | -5.21% | 3 | 3 | 22.86M | 120.96M | | 00:SCAN HDFS | 27.70% | 2.42s | 2.35s | +3.25% | 2.94% | 2.51s | 2.46s | +1.79% | 1 | 1 | 60 | 118 | | F00:EXCHANGE SENDER | 3.59% | 314.16ms | 308.48ms | +1.84% | 2.50% | 343.99ms | 347.99ms | -1.15% | 3 | 3 | -1 | -1 | | 10:AGGREGATE | 13.12% | 1.15s | 1.10s | +4.57% | 2.27% | 1.32s | 1.26s | +4.75% | 3 | 3 | 4.89M | 3.33M | | 09:HASH JOIN | 3.36% | 294.38ms | 288.13ms | +2.17% | 3.82% | 363.99ms | 351.99ms | +3.41% | 3 | 3 | 22.72M | 120.96M | | 07:SCAN HDFS | 23.09% | 2.02s | 2.04s | -0.74% | 4.13% | 2.22s | 2.22s | -0.18% | 3 | 3 | 22.72M | 120.96M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (R) Regression: TPCDS(42) TPCDS-Q29 [orc / snap / block] (2.94s -> 3.09s [+5.22%]) +---------------------+------------+----------+----------+------------+-------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-------------+----------+----------+------------+--------+-------+---------+-----------+ | 15:AGGREGATE | 4.21% | 173.82ms | 165.61ms | +4.96% | * 10.32% * | 283.99ms | 235.99ms | +20.34% | 3 | 3 | 131 | 176.95K | | 12:HASH JOIN | 4.36% | 180.20ms | 165.12ms | +9.14% | 9.92% | 263.99ms | 247.99ms | +6.45% | 3 | 3 | 134 | 289.96K | | F06:EXCHANGE SENDER | 2.24% | 92.42ms | 97.68ms | -5.39% | * 14.03% * | 112.00ms | 132.00ms | -15.15% | 1 | 1 | -1 | -1 | | 07:SCAN HDFS | 4.45% | 183.78ms | 61.89ms | +196.94% | * 19.94% * | 239.99ms | 88.00ms | +172.73% | 1 | 1 | 54.00K | 54.00K | | 04:SCAN HDFS | 2.05% | 84.84ms | 167.78ms | -49.44% | * 109.78% * | 255.99ms | 259.99ms | -1.54% | 1 | 1 | 122 | 118 | | F02:EXCHANGE SENDER | 6.19% | 255.92ms | 242.80ms | +5.40% | 3.56% | 299.99ms | 307.99ms | -2.60% | 3 | 3 | -1 | -1 | | 00:SCAN HDFS | 16.21% | 669.87ms | 682.29ms | -1.82% | 7.53% | 839.97ms | 807.97ms | +3.96% | 3 | 3 | 2.48M | 120.96M | | 01:SCAN HDFS | 41.79% | 1.73s | 1.62s | +6.38% | 2.68% | 1.91s | 1.79s | +6.94% | 3 | 3 | 123.21K | 12.09M | | 02:SCAN HDFS | 10.23% | 423.00ms | 416.06ms | +1.67% | 7.37% | 539.98ms | 535.98ms | +0.75% | 3 | 3 | 3.03M | 60.48M | +---------------------+------------+----------+----------+------------+-------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q25 [orc / snap / block] (2.59s -> 2.45s [-5.62%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 05:SCAN HDFS | 4.97% | 182.31ms | 28.00ms | +551.13% | * 41.54% * | 303.99ms | 60.00ms | +406.67% | 1 | 1 | 214 | 118 | | 12:HASH JOIN | 2.22% | 81.26ms | 70.94ms | +14.54% | * 12.63% * | 120.00ms | 120.00ms | +0.00% | 3 | 3 | 30 | 289.96K | | F06:EXCHANGE SENDER | 2.55% | 93.47ms | 86.31ms | +8.29% | * 15.41% * | 132.00ms | 108.00ms | +22.22% | 1 | 1 | -1 | -1 | | 07:SCAN HDFS | 4.89% | 179.15ms | 130.31ms | +37.48% | * 29.37% * | 255.99ms | 207.99ms | +23.08% | 1 | 1 | 54.00K | 54.00K | | 04:SCAN HDFS | 5.73% | 209.89ms | 22.95ms | +814.68% | * 30.92% * | 303.99ms | 44.00ms | +590.91% | 1 | 1 | 214 | 118 | | F02:EXCHANGE SENDER | 3.23% | 118.38ms | 109.89ms | +7.73% | 7.70% | 163.99ms | 147.99ms | +10.81% | 3 | 3 | -1 | -1 | | 03:SCAN HDFS | 5.74% | 210.52ms | 19.58ms | +975.27% | * 31.09% * | 291.99ms | 40.00ms | +630.00% | 1 | 1 | 30 | 108 | | 00:SCAN HDFS | 18.32% | 671.49ms | 676.82ms | -0.79% | 7.11% | 847.97ms | 795.97ms | +6.53% | 3 | 3 | 1.08M | 120.96M | | 01:SCAN HDFS | 41.59% | 1.52s | 1.41s | +7.97% | 2.89% | 1.67s | 1.54s | +8.03% | 3 | 3 | 88.76K | 12.09M | | 02:SCAN HDFS | 6.09% | 223.15ms | 492.47ms | -54.69% | 8.45% | 323.99ms | 595.98ms | -45.64% | 3 | 3 | 512.75K | 60.48M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q33 [orc / snap / block] (2.41s -> 2.27s [-5.62%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 15:SCAN HDFS | 20.28% | 1.04s | 25.89ms | +3898.37% | 7.78% | 1.21s | 56.00ms | +2064.29% | 1 | 1 | 54.00K | 54.00K | | 12:SCAN HDFS | 8.41% | 429.11ms | 653.73ms | -34.36% | * 14.64% * | 671.98ms | 971.97ms | -30.86% | 3 | 3 | 219.66K | 60.48M | | 26:SCAN HDFS | 23.09% | 1.18s | 30.74ms | +3734.25% | 7.62% | 1.41s | 52.00ms | +2607.69% | 1 | 1 | 54.00K | 54.00K | | 25:SCAN HDFS | 2.09% | 106.73ms | 39.16ms | +172.58% | * 44.39% * | 187.99ms | 92.00ms | +104.35% | 1 | 1 | 115.00K | 51.09K | | 23:SCAN HDFS | 8.56% | 437.04ms | 520.82ms | -16.09% | * 14.33% * | 675.98ms | 887.97ms | -23.87% | 3 | 3 | 107.45K | 30.24M | | 04:SCAN HDFS | 20.98% | 1.07s | 1.01s | +5.67% | 7.86% | 1.27s | 1.31s | -2.75% | 1 | 1 | 53.61K | 54.00K | | 03:SCAN HDFS | 2.03% | 103.58ms | 44.63ms | +132.08% | * 47.23% * | 199.99ms | 84.00ms | +138.10% | 1 | 1 | 115.00K | 51.09K | | 01:SCAN HDFS | 2.15% | 109.61ms | 217.33ms | -49.56% | * 30.92% * | 263.99ms | 523.98ms | -49.62% | 3 | 3 | 399.45K | 120.96M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q72 [orc / snap / block] (8.95s -> 8.28s [-7.43%]) +---------------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | 17:HASH JOIN | 3.08% | 1.02s | 1.61s | -36.78% | 4.17% | 1.22s | 1.87s | -34.83% | 3 | 3 | 110.68K | 1.61B | | F07:EXCHANGE SENDER | 14.47% | 4.79s | 4.79s | -0.00% | 2.24% | 5.01s | 5.18s | -3.25% | 1 | 1 | -1 | -1 | | 01:SCAN HDFS | 3.66% | 1.21s | 1.11s | +8.87% | * 10.10% * | 1.71s | 1.38s | +23.70% | 1 | 1 | 42.28M | 42.28M | | 07:SCAN HDFS | 19.89% | 6.59s | 6.42s | +2.62% | 2.42% | 7.00s | 6.77s | +3.43% | 1 | 1 | 261 | 73.05K | | 03:SCAN HDFS | 19.86% | 6.58s | 6.40s | +2.81% | 2.55% | 7.04s | 6.72s | +4.64% | 1 | 1 | 54.00K | 54.00K | | 06:SCAN HDFS | 19.48% | 6.45s | 6.38s | +1.10% | 2.46% | 6.84s | 6.69s | +2.15% | 1 | 1 | 365 | 373 | | 00:SCAN HDFS | 15.57% | 5.15s | 5.60s | -8.06% | 2.98% | 5.77s | 6.34s | -9.02% | 3 | 3 | 403.89K | 60.48M | +---------------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q60 [orc / snap / block] (2.63s -> 2.43s [-7.50%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 14:SCAN HDFS | 18.52% | 1.05s | 1.04s | +1.23% | 8.73% | 1.34s | 1.28s | +4.70% | 1 | 1 | 11.74K | 54.00K | | 13:SCAN HDFS | 3.35% | 190.73ms | 118.73ms | +60.64% | * 33.76% * | 275.99ms | 191.99ms | +43.75% | 1 | 1 | 115.00K | 51.09K | | 12:SCAN HDFS | 3.13% | 177.89ms | 98.73ms | +80.17% | * 51.65% * | 303.99ms | 207.99ms | +46.15% | 1 | 1 | 30 | 108 | | 11:SCAN HDFS | 7.49% | 426.37ms | 890.57ms | -52.12% | * 16.19% * | 667.98ms | 1.11s | -39.93% | 3 | 3 | 475.65K | 60.48M | | 24:SCAN HDFS | 18.18% | 1.03s | 974.49ms | +6.11% | 8.85% | 1.21s | 1.24s | -1.94% | 1 | 1 | 11.74K | 54.00K | | 23:SCAN HDFS | 2.88% | 163.99ms | 109.05ms | +50.39% | * 31.36% * | 259.99ms | 167.99ms | +54.76% | 1 | 1 | 115.00K | 51.09K | | 22:SCAN HDFS | 3.18% | 180.84ms | 116.42ms | +55.33% | * 30.17% * | 279.99ms | 199.99ms | +40.00% | 1 | 1 | 30 | 108 | | 21:SCAN HDFS | 7.95% | 452.34ms | 743.41ms | -39.15% | * 13.95% * | 691.98ms | 1.00s | -31.08% | 3 | 3 | 238.94K | 30.24M | | 04:SCAN HDFS | 20.74% | 1.18s | 1.17s | +0.90% | 9.12% | 1.48s | 1.27s | +16.40% | 1 | 1 | 11.74K | 54.00K | | 03:SCAN HDFS | 3.16% | 179.57ms | 131.36ms | +36.70% | * 36.31% * | 327.99ms | 179.99ms | +82.22% | 1 | 1 | 115.00K | 51.09K | | 02:SCAN HDFS | 2.72% | 154.52ms | 73.26ms | +110.92% | * 47.10% * | 291.99ms | 191.99ms | +52.08% | 1 | 1 | 30 | 108 | | 01:SCAN HDFS | 2.36% | 134.10ms | 299.64ms | -55.25% | * 32.08% * | 307.99ms | 691.98ms | -55.49% | 3 | 3 | 169.05K | 120.96M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q56 [orc / snap / block] (2.61s -> 2.41s [-7.88%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 14:SCAN HDFS | 19.66% | 1.09s | 1.04s | +4.54% | 7.65% | 1.28s | 1.22s | +4.59% | 1 | 1 | 3.36K | 54.00K | | 13:SCAN HDFS | 3.24% | 179.36ms | 133.05ms | +34.81% | * 20.97% * | 247.99ms | 207.99ms | +19.23% | 1 | 1 | 115.00K | 51.09K | | 12:SCAN HDFS | 2.93% | 162.10ms | 101.05ms | +60.42% | * 62.33% * | 291.99ms | 223.99ms | +30.36% | 1 | 1 | 28 | 108 | | 11:SCAN HDFS | 8.04% | 444.69ms | 868.04ms | -48.77% | * 14.72% * | 659.98ms | 1.20s | -45.00% | 3 | 3 | 195.91K | 60.48M | | 24:SCAN HDFS | 18.36% | 1.02s | 1.00s | +1.09% | 8.89% | 1.24s | 1.27s | -2.52% | 1 | 1 | 3.36K | 54.00K | | 23:SCAN HDFS | 2.96% | 163.57ms | 112.00ms | +46.05% | * 33.48% * | 231.99ms | 175.99ms | +31.82% | 1 | 1 | 115.00K | 51.09K | | 22:SCAN HDFS | 2.84% | 157.26ms | 106.94ms | +47.05% | * 59.06% * | 263.99ms | 191.99ms | +37.50% | 1 | 1 | 28 | 108 | | 21:SCAN HDFS | 8.16% | 451.35ms | 743.34ms | -39.28% | * 15.05% * | 631.98ms | 1.02s | -37.80% | 3 | 3 | 97.66K | 30.24M | | 04:SCAN HDFS | 21.47% | 1.19s | 1.21s | -2.07% | 9.40% | 1.44s | 1.49s | -3.49% | 1 | 1 | 3.36K | 54.00K | | 03:SCAN HDFS | 3.31% | 182.73ms | 128.00ms | +42.76% | * 38.56% * | 303.99ms | 191.99ms | +58.33% | 1 | 1 | 115.00K | 51.09K | | 02:SCAN HDFS | 2.29% | 126.52ms | 79.79ms | +58.58% | * 73.24% * | 303.99ms | 231.99ms | +31.03% | 1 | 1 | 28 | 108 | | 01:SCAN HDFS | 2.40% | 132.77ms | 233.54ms | -43.15% | * 25.01% * | 307.99ms | 507.98ms | -39.37% | 3 | 3 | 19.59K | 120.96M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q5 [orc / snap / block] (3.09s -> 2.83s [-8.27%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 11:SCAN HDFS | 4.28% | 246.31ms | 155.01ms | +58.90% | * 20.64% * | 395.99ms | 279.99ms | +41.43% | 3 | 3 | 25.98K | 6.05M | | 10:SCAN HDFS | 4.84% | 278.03ms | 1.15s | -75.81% | * 25.51% * | 743.97ms | 1.40s | -46.86% | 3 | 3 | 654.38K | 60.48M | | 19:SCAN HDFS | 26.43% | 1.52s | 1.56s | -2.92% | 7.15% | 1.80s | 1.96s | -7.77% | 3 | 3 | 9.11K | 3.02M | | 20:SCAN HDFS | 38.45% | 2.21s | 2.48s | -10.74% | 1.68% | 2.35s | 2.64s | -10.91% | 3 | 3 | 38.33K | 30.24M | | 18:SCAN HDFS | 8.64% | 496.61ms | 637.87ms | -22.15% | * 14.69% * | 743.97ms | 839.97ms | -11.43% | 3 | 3 | 326.38K | 30.24M | | 03:SCAN HDFS | 7.82% | 449.60ms | 601.80ms | -25.29% | * 11.90% * | 619.98ms | 835.97ms | -25.84% | 3 | 3 | 55.80K | 12.09M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q49 [orc / snap / block] (4.34s -> 3.94s [-9.12%]) +--------------+------------+----------+----------+------------+-------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-------------+----------+----------+------------+--------+-------+---------+-----------+ | 14:SCAN HDFS | 3.07% | 141.68ms | 234.31ms | -39.53% | * 137.83% * | 763.97ms | 1.27s | -39.94% | 1 | 1 | 31 | 108 | | 13:SCAN HDFS | 12.85% | 593.52ms | 464.62ms | +27.75% | * 48.54% * | 1.98s | 1.68s | +17.81% | 3 | 3 | 52.08K | 604.79K | | 12:SCAN HDFS | 16.25% | 750.71ms | 1.52s | -50.48% | * 17.81% * | 1.32s | 2.21s | -40.33% | 3 | 3 | 793.25K | 6.05M | | 24:SCAN HDFS | 17.42% | 804.67ms | 652.40ms | +23.34% | * 43.62% * | 1.96s | 1.76s | +11.85% | 3 | 3 | 19.80K | 1.21M | | 23:SCAN HDFS | 8.97% | 414.51ms | 621.17ms | -33.27% | * 29.58% * | 1.04s | 1.58s | -34.43% | 3 | 3 | 967.80K | 12.10M | | 03:SCAN HDFS | 5.02% | 231.78ms | 266.94ms | -13.17% | * 102.86% * | 935.97ms | 1.25s | -25.00% | 1 | 1 | 31 | 108 | | 02:SCAN HDFS | 9.91% | 457.74ms | 386.93ms | +18.30% | * 50.29% * | 1.42s | 1.20s | +19.06% | 3 | 3 | 24.97K | 302.33K | | 01:SCAN HDFS | 18.39% | 849.44ms | 1.35s | -36.99% | * 15.83% * | 1.32s | 2.10s | -36.95% | 3 | 3 | 398.83K | 3.02M | +--------------+------------+----------+----------+------------+-------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q80 [orc / snap / block] (4.03s -> 3.64s [-9.60%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 14:SCAN HDFS | 20.90% | 1.84s | 1.75s | +4.89% | 5.14% | 2.26s | 2.17s | +4.06% | 3 | 3 | 341.34K | 6.05M | | 13:SCAN HDFS | 8.39% | 737.52ms | 1.50s | -50.79% | * 16.39% * | 1.04s | 1.78s | -41.57% | 3 | 3 | 75.11K | 60.48M | | 26:SCAN HDFS | 19.90% | 1.75s | 1.65s | +5.94% | 6.76% | 2.11s | 1.99s | +6.02% | 3 | 3 | 170.74K | 3.02M | | 25:SCAN HDFS | 7.79% | 684.47ms | 816.67ms | -16.19% | * 16.34% * | 1.01s | 1.13s | -10.28% | 3 | 3 | 1.68M | 30.24M | | 02:SCAN HDFS | 21.04% | 1.85s | 1.82s | +1.49% | 8.37% | 2.20s | 2.18s | +0.55% | 3 | 3 | 681.75K | 12.09M | | 01:SCAN HDFS | 3.87% | 340.13ms | 300.55ms | +13.17% | * 19.05% * | 707.98ms | 483.98ms | +46.28% | 3 | 3 | 137.02K | 120.96M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q71 [orc / snap / block] (2.37s -> 2.11s [-11.17%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 05:SCAN HDFS | 29.29% | 189.54ms | 526.02ms | -63.97% | * 49.52% * | 679.98ms | 751.98ms | -9.57% | 3 | 3 | 13.69K | 60.48M | | 08:SCAN HDFS | 7.04% | 45.54ms | 58.59ms | -22.28% | * 75.61% * | 195.99ms | 136.00ms | +44.12% | 3 | 3 | 27.02K | 120.96M | | 02:SCAN HDFS | 47.13% | 304.97ms | 377.25ms | -19.16% | 9.04% | 419.99ms | 719.98ms | -41.67% | 3 | 3 | 6.68K | 30.24M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q66 [orc / snap / block] (4.09s -> 3.56s [-12.97%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 20:AGGREGATE | 3.89% | 61.61ms | 67.51ms | -8.73% | * 19.46% * | 112.00ms | 112.00ms | +0.00% | 3 | 3 | 18 | 39.20K | | 11:SCAN HDFS | 38.36% | 607.42ms | 1.37s | -55.82% | * 18.75% * | 1.14s | 2.06s | -44.55% | 3 | 3 | 461.05K | 60.48M | | 01:SCAN HDFS | 38.66% | 612.19ms | 1.04s | -41.06% | * 12.95% * | 1.25s | 1.80s | -30.60% | 3 | 3 | 232.90K | 30.24M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q40 [orc / snap / block] (1.89s -> 1.66s [-12.55%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 78.06% | 1.09s | 1.03s | +6.22% | 2.08% | 1.16s | 1.16s | +0.69% | 3 | 3 | 386.02K | 6.05M | | 00:SCAN HDFS | 11.41% | 159.85ms | 571.35ms | -72.02% | 6.76% | 227.99ms | 635.98ms | -64.15% | 3 | 3 | 75.51K | 60.48M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q15 [orc / snap / block] (1.74s -> 1.50s [-13.80%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 06:HASH JOIN | 3.89% | 56.49ms | 99.22ms | -43.07% | * 12.93% * | 124.00ms | 239.99ms | -48.33% | 3 | 3 | 138.31K | 6.13M | | 01:SCAN HDFS | 63.62% | 924.07ms | 847.55ms | +9.03% | 2.96% | 991.97ms | 911.97ms | +8.77% | 2 | 2 | 633.00K | 633.00K | | 00:SCAN HDFS | 19.71% | 286.31ms | 603.84ms | -52.59% | 4.74% | 367.99ms | 807.97ms | -54.46% | 3 | 3 | 1.75M | 60.48M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q20 [orc / snap / block] (1.70s -> 1.46s [-13.93%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 00:SCAN HDFS | 52.83% | 134.31ms | 404.62ms | -66.81% | * 13.96% * | 247.99ms | 567.98ms | -56.34% | 3 | 3 | 173.04K | 60.48M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q18 [orc / snap / block] (4.05s -> 3.42s [-15.60%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 24:AGGREGATE | 4.77% | 170.59ms | 167.64ms | +1.76% | 7.12% | 251.99ms | 195.99ms | +28.57% | 3 | 3 | 179.53K | 245.22K | | F07:EXCHANGE SENDER | 4.61% | 165.05ms | 159.22ms | +3.66% | 7.00% | 215.99ms | 211.99ms | +1.89% | 3 | 3 | -1 | -1 | | F06:EXCHANGE SENDER | 5.91% | 211.57ms | 200.62ms | +5.46% | 9.68% | 263.99ms | 231.99ms | +13.79% | 1 | 1 | -1 | -1 | | 03:SCAN HDFS | 42.46% | 1.52s | 1.53s | -0.93% | 5.68% | 1.77s | 1.80s | -1.78% | 2 | 2 | 52.22K | 316.50K | | 01:SCAN HDFS | 3.64% | 130.31ms | 99.79ms | +30.59% | * 28.10% * | 179.99ms | 163.99ms | +9.76% | 1 | 1 | 137.20K | 194.03K | | 00:SCAN HDFS | 26.86% | 961.23ms | 1.75s | -45.16% | * 11.38% * | 1.25s | 2.10s | -40.38% | 3 | 3 | 70.97K | 60.48M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q57 [orc / snap / block] (6.36s -> 5.15s [-18.90%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 30:AGGREGATE | 14.21% | 1.34s | 1.57s | -14.36% | 2.17% | 1.54s | 1.89s | -18.39% | 3 | 3 | 122.95K | 14.19M | | 28:HASH JOIN | 6.53% | 617.94ms | 753.59ms | -18.00% | 5.93% | 827.97ms | 959.97ms | -13.75% | 3 | 3 | 14.67M | 14.19M | | 27:HASH JOIN | 2.32% | 219.29ms | 276.76ms | -20.77% | 6.26% | 295.99ms | 379.99ms | -22.11% | 3 | 3 | 14.67M | 14.33M | | 24:SCAN HDFS | 5.60% | 529.46ms | 1.41s | -62.53% | * 13.16% * | 919.97ms | 2.44s | -62.30% | 3 | 3 | 14.75M | 60.48M | | 07:AGGREGATE | 14.22% | 1.35s | 1.55s | -13.37% | 2.95% | 1.67s | 1.96s | -14.87% | 3 | 3 | 122.95K | 14.19M | | 05:HASH JOIN | 6.51% | 615.42ms | 739.06ms | -16.73% | 4.29% | 743.98ms | 955.97ms | -22.18% | 3 | 3 | 14.67M | 14.19M | | 04:HASH JOIN | 2.25% | 213.12ms | 275.57ms | -22.66% | 6.49% | 291.99ms | 403.99ms | -27.72% | 3 | 3 | 14.67M | 14.33M | | 01:SCAN HDFS | 5.75% | 544.19ms | 1.43s | -61.85% | * 13.63% * | 1.13s | 2.22s | -49.19% | 3 | 3 | 14.75M | 60.48M | | 20:AGGREGATE | 14.25% | 1.35s | 1.54s | -12.35% | 2.66% | 1.60s | 2.03s | -21.10% | 3 | 3 | 122.95K | 14.19M | | 18:HASH JOIN | 6.59% | 623.91ms | 723.27ms | -13.74% | 5.86% | 795.97ms | 1.00s | -20.72% | 3 | 3 | 14.67M | 14.19M | | 17:HASH JOIN | 2.29% | 216.98ms | 267.36ms | -18.85% | 9.76% | 359.99ms | 367.99ms | -2.17% | 3 | 3 | 14.67M | 14.33M | | 14:SCAN HDFS | 5.65% | 534.65ms | 1.47s | -63.59% | * 18.95% * | 1.11s | 2.53s | -56.17% | 3 | 3 | 14.75M | 60.48M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q16 [orc / snap / block] (2.55s -> 1.96s [-23.02%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | F06:EXCHANGE SENDER | 8.30% | 214.66ms | 364.13ms | -41.05% | 3.44% | 271.99ms | 551.98ms | -50.72% | 3 | 3 | -1 | -1 | | 00:SCAN HDFS | 17.35% | 448.97ms | 1.19s | -62.17% | 7.52% | 611.98ms | 1.32s | -53.78% | 3 | 3 | 61.40K | 60.48M | | 04:SCAN HDFS | 67.21% | 1.74s | 2.33s | -25.37% | 2.12% | 1.86s | 2.42s | -23.43% | 3 | 3 | 144.30K | 60.48M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q22 [orc / snap / block] (9.33s -> 7.10s [-23.92%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 07:AGGREGATE | 81.12% | 4.52s | 4.57s | -1.07% | 1.19% | 4.63s | 4.84s | -4.30% | 1 | 1 | 107.88K | 121.12M | | 06:HASH JOIN | 2.23% | 124.42ms | 119.79ms | +3.87% | * 19.95% * | 163.99ms | 159.99ms | +2.50% | 1 | 1 | 8.42M | 41.88M | | 04:HASH JOIN | 10.17% | 566.51ms | 550.51ms | +2.91% | 4.65% | 607.98ms | 615.98ms | -1.30% | 1 | 1 | 8.43M | 41.88M | | 00:SCAN HDFS | 2.50% | 139.36ms | 2.49s | -94.40% | * 18.44% * | 199.99ms | 2.55s | -92.16% | 1 | 1 | 8.43M | 42.28M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q26 [orc / snap / block] (2.65s -> 2.00s [-24.50%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 12.22% | 106.52ms | 100.42ms | +6.08% | * 14.73% * | 167.99ms | 136.00ms | +23.53% | 1 | 1 | 27.44K | 97.40K | | 00:SCAN HDFS | 73.55% | 640.96ms | 1.34s | -52.29% | 6.89% | 815.97ms | 1.56s | -47.56% | 3 | 3 | 171.89K | 60.48M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q14-2 [orc / snap / block] (27.45s -> 19.98s [-27.22%]) +--------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+---------+-----------+ | 77:SCAN HDFS | 9.30% | 10.35s | 10.56s | -2.03% | 6.17% | 12.90s | 14.72s | -12.34% | 3 | 3 | 120.96M | 120.96M | | 57:HASH JOIN | 3.15% | 3.50s | 3.52s | -0.43% | 5.88% | 4.27s | 4.24s | +0.85% | 3 | 3 | 60.48M | 59.89M | | 53:AGGREGATE | 2.06% | 2.29s | 2.24s | +2.17% | 3.40% | 2.58s | 2.54s | +1.58% | 3 | 3 | 23.50K | 149.12K | | 51:HASH JOIN | 5.20% | 5.78s | 5.74s | +0.72% | 3.34% | 6.38s | 6.78s | -5.84% | 3 | 3 | 120.96M | 119.80M | | 48:SCAN HDFS | 3.05% | 3.39s | 3.35s | +1.45% | 7.24% | 5.09s | 4.86s | +4.86% | 3 | 3 | 120.96M | 120.96M | | 46:SCAN HDFS | 3.48% | 3.87s | 3.54s | +9.42% | 8.29% | 4.43s | 4.09s | +8.21% | 1 | 1 | 7 | 73.05K | | 45:SCAN HDFS | 7.96% | 8.85s | 9.11s | -2.86% | 1.45% | 9.09s | 9.37s | -2.99% | 1 | 1 | 54.00K | 54.00K | | 33:SCAN HDFS | 9.23% | 10.27s | 10.35s | -0.78% | 5.65% | 12.38s | 14.64s | -15.39% | 3 | 3 | 120.96M | 120.96M | | 13:HASH JOIN | 3.14% | 3.50s | 3.56s | -1.70% | 4.68% | 4.05s | 4.26s | -4.89% | 3 | 3 | 60.48M | 59.89M | | 09:AGGREGATE | 2.01% | 2.24s | 2.20s | +1.45% | 4.24% | 2.51s | 2.56s | -1.72% | 3 | 3 | 23.50K | 149.12K | | 07:HASH JOIN | 5.16% | 5.74s | 5.75s | -0.11% | 2.58% | 6.47s | 6.67s | -2.94% | 3 | 3 | 120.96M | 119.80M | | 04:SCAN HDFS | 3.27% | 3.64s | 3.47s | +4.91% | 6.37% | 5.30s | 5.31s | -0.30% | 3 | 3 | 120.96M | 120.96M | | 02:SCAN HDFS | 3.57% | 3.97s | 3.71s | +7.18% | 8.08% | 4.45s | 3.98s | +11.75% | 1 | 1 | 7 | 73.05K | | 01:SCAN HDFS | 7.93% | 8.82s | 8.89s | -0.82% | 1.34% | 9.04s | 9.07s | -0.31% | 1 | 1 | 54.00K | 54.00K | +--------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q18A [orc / snap / block] (11.04s -> 7.57s [-31.40%]) +--------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | 18:SCAN HDFS | 7.99% | 2.74s | 2.83s | -3.30% | 4.60% | 3.32s | 3.45s | -3.94% | 2 | 2 | 44.62K | 316.50K | | 15:SCAN HDFS | 7.95% | 2.73s | 6.08s | -55.10% | * 10.23% * | 3.72s | 6.92s | -46.19% | 3 | 3 | 852.96K | 60.48M | | 32:SCAN HDFS | 7.50% | 2.57s | 2.61s | -1.60% | 7.63% | 3.44s | 3.32s | +3.61% | 2 | 2 | 44.62K | 316.50K | | 29:SCAN HDFS | 7.92% | 2.72s | 6.06s | -55.18% | * 11.65% * | 3.77s | 6.76s | -44.23% | 3 | 3 | 852.96K | 60.48M | | 46:SCAN HDFS | 7.36% | 2.52s | 2.60s | -3.02% | 3.75% | 3.14s | 3.52s | -10.58% | 2 | 2 | 44.62K | 316.50K | | 43:SCAN HDFS | 7.92% | 2.72s | 6.04s | -54.97% | * 12.13% * | 3.71s | 7.00s | -47.06% | 3 | 3 | 852.96K | 60.48M | | 60:SCAN HDFS | 8.34% | 2.86s | 2.93s | -2.13% | 5.68% | 3.35s | 3.28s | +2.20% | 2 | 2 | 44.62K | 316.50K | | 57:SCAN HDFS | 7.91% | 2.71s | 6.05s | -55.15% | * 10.32% * | 3.72s | 6.92s | -46.19% | 3 | 3 | 852.96K | 60.48M | | 04:SCAN HDFS | 7.53% | 2.58s | 2.69s | -3.91% | 7.33% | 3.43s | 3.45s | -0.58% | 2 | 2 | 44.62K | 316.50K | | 01:SCAN HDFS | 7.87% | 2.70s | 6.05s | -55.40% | * 11.79% * | 3.73s | 6.82s | -45.28% | 3 | 3 | 852.96K | 60.48M | +--------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q32 [orc / snap / block] (1.64s -> 1.12s [-31.96%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | 03:SCAN HDFS | 11.17% | 128.91ms | 429.67ms | -70.00% | 9.88% | 211.99ms | 603.98ms | -64.90% | 3 | 3 | 1.74M | 60.48M | | 01:SCAN HDFS | 64.14% | 740.19ms | 853.23ms | -13.25% | 4.80% | 803.97ms | 943.97ms | -14.83% | 1 | 1 | 3 | 56 | | 00:SCAN HDFS | 15.66% | 180.70ms | 581.31ms | -68.92% | 6.89% | 243.99ms | 651.98ms | -62.58% | 3 | 3 | 217 | 60.48M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q82 [orc / snap / block] (4.47s -> 2.78s [-37.72%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 21.20% | 675.56ms | 2.85s | -76.26% | 5.81% | 755.97ms | 2.94s | -74.29% | 1 | 1 | 556.33K | 4.23M | | 00:SCAN HDFS | 26.27% | 837.23ms | 2.92s | -71.36% | 4.50% | 919.97ms | 3.00s | -69.29% | 1 | 1 | 2 | 71 | | 03:SCAN HDFS | 49.51% | 1.58s | 1.19s | +32.99% | 5.95% | 1.78s | 1.28s | +38.75% | 3 | 3 | 7.13K | 120.96M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q67A [orc / snap / block] (103.93s -> 64.00s [-38.42%]) +---------------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+--------+-----------+ | F05:EXCHANGE SENDER | 3.70% | 13.97s | 11.05s | +26.45% | 1.55% | 15.08s | 12.73s | +18.48% | 3 | 3 | -1 | -1 | | 16:AGGREGATE | 3.35% | 12.66s | 11.21s | +13.01% | 2.73% | 14.08s | 13.26s | +6.18% | 3 | 3 | 17.98M | 119.80M | | F11:EXCHANGE SENDER | 3.72% | 14.07s | 11.06s | +27.12% | 1.15% | 14.95s | 12.74s | +17.29% | 3 | 3 | -1 | -1 | | 25:AGGREGATE | 3.39% | 12.82s | 11.22s | +14.28% | 3.01% | 14.34s | 12.88s | +11.40% | 3 | 3 | 17.98M | 119.80M | | F17:EXCHANGE SENDER | 3.72% | 14.04s | 11.04s | +27.16% | 1.72% | 15.33s | 12.78s | +19.97% | 3 | 3 | -1 | -1 | | 34:AGGREGATE | 3.36% | 12.70s | 11.14s | +13.96% | 3.08% | 14.24s | 12.76s | +11.60% | 3 | 3 | 17.98M | 119.80M | | F23:EXCHANGE SENDER | 3.71% | 14.03s | 11.03s | +27.20% | 1.30% | 15.24s | 12.56s | +21.41% | 3 | 3 | -1 | -1 | | 43:AGGREGATE | 3.39% | 12.79s | 11.21s | +14.09% | 2.56% | 13.94s | 13.11s | +6.28% | 3 | 3 | 17.98M | 119.80M | | F29:EXCHANGE SENDER | 3.71% | 14.02s | 11.08s | +26.57% | 1.51% | 14.93s | 12.53s | +19.19% | 3 | 3 | -1 | -1 | | 52:AGGREGATE | 3.38% | 12.76s | 11.16s | +14.27% | 2.35% | 14.06s | 12.90s | +8.99% | 3 | 3 | 17.98M | 119.80M | | F35:EXCHANGE SENDER | 3.70% | 13.97s | 11.07s | +26.20% | 1.30% | 14.91s | 12.58s | +18.51% | 3 | 3 | -1 | -1 | | 61:AGGREGATE | 3.40% | 12.86s | 11.13s | +15.53% | 2.23% | 14.04s | 12.95s | +8.40% | 3 | 3 | 17.98M | 119.80M | | F41:EXCHANGE SENDER | 3.71% | 14.02s | 11.05s | +26.93% | 1.46% | 15.10s | 12.60s | +19.84% | 3 | 3 | -1 | -1 | | 70:AGGREGATE | 3.36% | 12.70s | 11.20s | +13.45% | 2.04% | 14.29s | 12.72s | +12.32% | 3 | 3 | 17.98M | 119.80M | | F47:EXCHANGE SENDER | 3.73% | 14.08s | 11.06s | +27.31% | 1.60% | 15.26s | 12.62s | +20.91% | 3 | 3 | -1 | -1 | | 79:AGGREGATE | 3.40% | 12.85s | 11.27s | +13.99% | 2.71% | 14.52s | 13.63s | +6.48% | 3 | 3 | 17.98M | 119.80M | | F00:EXCHANGE SENDER | 3.70% | 13.99s | 11.12s | +25.72% | 1.18% | 14.96s | 12.79s | +16.98% | 3 | 3 | -1 | -1 | | 08:AGGREGATE | 3.37% | 12.73s | 11.12s | +14.47% | 2.87% | 14.28s | 12.82s | +11.38% | 3 | 3 | 17.98M | 119.80M | +---------------------+------------+--------+----------+------------+-----------+--------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q75 [orc / snap / block] (17.21s -> 10.43s [-39.40%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 38:HASH JOIN | 2.39% | 618.71ms | 611.35ms | +1.21% | 4.37% | 759.97ms | 719.98ms | +5.56% | 3 | 3 | 2.29M | 2.44M | | F24:EXCHANGE SENDER | 2.86% | 738.29ms | 799.41ms | -7.65% | 5.02% | 943.97ms | 1.03s | -8.17% | 3 | 3 | -1 | -1 | | F23:EXCHANGE SENDER | 4.05% | 1.05s | 1.03s | +1.96% | 3.16% | 1.30s | 1.25s | +3.85% | 3 | 3 | -1 | -1 | | 39:SCAN HDFS | 5.48% | 1.42s | 2.04s | -30.75% | 6.20% | 2.12s | 2.50s | -15.18% | 3 | 3 | 3.02M | 30.24M | | 25:SCAN HDFS | 2.15% | 555.00ms | 2.68s | -79.31% | * 29.80% * | 1.96s | 3.57s | -45.18% | 3 | 3 | 1.20M | 60.48M | | 28:SCAN HDFS | 17.05% | 4.41s | 6.39s | -31.00% | 2.62% | 4.72s | 6.86s | -31.24% | 3 | 3 | 122.16K | 6.05M | | 14:HASH JOIN | 2.33% | 602.22ms | 607.42ms | -0.86% | 3.43% | 671.98ms | 703.98ms | -4.55% | 3 | 3 | 2.26M | 2.44M | | F06:EXCHANGE SENDER | 2.84% | 734.22ms | 788.96ms | -6.94% | 5.66% | 927.97ms | 967.97ms | -4.13% | 3 | 3 | -1 | -1 | | F05:EXCHANGE SENDER | 3.87% | 1.00s | 981.44ms | +1.89% | 3.59% | 1.26s | 1.14s | +10.53% | 3 | 3 | -1 | -1 | | 15:SCAN HDFS | 4.99% | 1.29s | 2.01s | -35.84% | 6.82% | 1.89s | 2.40s | -21.46% | 3 | 3 | 3.02M | 30.24M | | 01:SCAN HDFS | 2.52% | 650.78ms | 2.65s | -75.42% | * 33.92% * | 2.00s | 3.57s | -43.95% | 3 | 3 | 1.18M | 60.48M | | 04:SCAN HDFS | 17.03% | 4.40s | 6.41s | -31.33% | 3.01% | 4.94s | 6.97s | -29.15% | 3 | 3 | 122.14K | 6.05M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q70A [orc / snap / block] (12.47s -> 7.31s [-41.35%]) +--------------+------------+----------+----------+------------+------------+-------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+-------+----------+------------+--------+-------+--------+-----------+ | 20:SCAN HDFS | 2.67% | 677.03ms | 922.35ms | -26.60% | * 10.52% * | 1.30s | 1.61s | -19.15% | 3 | 3 | 23.06M | 120.96M | | 19:SCAN HDFS | 14.33% | 3.64s | 3.88s | -6.29% | 3.47% | 3.88s | 4.09s | -5.09% | 1 | 1 | 118 | 118 | | 17:SCAN HDFS | 5.64% | 1.43s | 1.80s | -20.57% | 8.16% | 1.90s | 2.27s | -16.55% | 3 | 3 | 23.06M | 120.96M | | 37:SCAN HDFS | 2.74% | 695.27ms | 1.88s | -62.93% | 8.04% | 1.26s | 2.66s | -52.71% | 3 | 3 | 23.21M | 120.96M | | 36:SCAN HDFS | 16.81% | 4.27s | 50.10ms | +8417.23% | 2.69% | 4.57s | 104.00ms | +4292.31% | 1 | 1 | 118 | 118 | | 34:SCAN HDFS | 5.97% | 1.52s | 1.58s | -3.91% | 7.99% | 1.99s | 3.45s | -42.41% | 3 | 3 | 23.21M | 120.96M | | 04:SCAN HDFS | 2.52% | 641.03ms | 911.27ms | -29.66% | * 10.99% * | 1.32s | 1.46s | -9.07% | 3 | 3 | 23.06M | 120.96M | | 03:SCAN HDFS | 15.15% | 3.85s | 4.14s | -7.07% | 2.42% | 4.04s | 4.37s | -7.69% | 1 | 1 | 118 | 118 | | 01:SCAN HDFS | 5.78% | 1.47s | 1.84s | -20.05% | 7.71% | 2.06s | 2.31s | -10.92% | 3 | 3 | 23.06M | 120.96M | +--------------+------------+----------+----------+------------+------------+-------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q77A [orc / snap / block] (15.40s -> 8.96s [-41.77%]) +---------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | 56:SCAN HDFS | 2.54% | 1.19s | 2.33s | -49.06% | * 25.54% * | 3.24s | 3.59s | -9.91% | 3 | 3 | 840.18K | 6.05M | | 52:SCAN HDFS | 7.93% | 3.70s | 5.97s | -38.03% | * 14.92% * | 5.09s | 7.25s | -29.80% | 3 | 3 | 1.37M | 60.48M | | 67:SCAN HDFS | 2.46% | 1.15s | 1.34s | -14.49% | * 12.41% * | 2.15s | 2.92s | -26.30% | 3 | 3 | 3.02M | 3.02M | | 61:SCAN HDFS | 5.64% | 2.63s | 4.70s | -44.13% | * 14.67% * | 3.68s | 6.42s | -42.65% | 3 | 3 | 30.24M | 30.24M | | 45:SCAN HDFS | 4.16% | 1.94s | 2.85s | -31.87% | * 12.43% * | 3.03s | 4.18s | -27.46% | 3 | 3 | 12.09M | 12.09M | | 39:SCAN HDFS | 3.38% | 1.58s | 8.69s | -81.84% | * 10.85% * | 2.49s | 9.86s | -74.73% | 3 | 3 | 2.57M | 120.96M | | 94:SCAN HDFS | 2.55% | 1.19s | 2.31s | -48.51% | * 30.18% * | 3.25s | 3.50s | -7.09% | 3 | 3 | 840.18K | 6.05M | | 90:SCAN HDFS | 8.38% | 3.91s | 6.22s | -37.16% | * 14.08% * | 5.14s | 7.35s | -29.99% | 3 | 3 | 1.37M | 60.48M | | 105:SCAN HDFS | 2.69% | 1.26s | 1.37s | -8.15% | * 12.87% * | 2.29s | 2.17s | +5.52% | 3 | 3 | 3.02M | 3.02M | | 99:SCAN HDFS | 6.24% | 2.91s | 4.92s | -40.87% | * 10.69% * | 3.82s | 6.42s | -40.56% | 3 | 3 | 30.24M | 30.24M | | 83:SCAN HDFS | 4.75% | 2.21s | 3.15s | -29.83% | 9.73% | 3.12s | 4.48s | -30.36% | 3 | 3 | 12.09M | 12.09M | | 77:SCAN HDFS | 3.83% | 1.79s | 9.06s | -80.29% | 7.47% | 2.77s | 10.39s | -73.32% | 3 | 3 | 2.57M | 120.96M | | 19:SCAN HDFS | 2.95% | 1.37s | 2.35s | -41.63% | * 18.59% * | 2.93s | 3.49s | -16.15% | 3 | 3 | 64.08K | 6.05M | | 15:SCAN HDFS | 7.55% | 3.52s | 6.68s | -47.29% | * 14.05% * | 4.70s | 7.98s | -41.13% | 3 | 3 | 1.36M | 60.48M | | 30:SCAN HDFS | 2.39% | 1.12s | 1.28s | -12.77% | * 10.58% * | 2.22s | 2.42s | -8.11% | 3 | 3 | 42.03K | 3.02M | | 24:SCAN HDFS | 6.06% | 2.82s | 4.74s | -40.37% | * 11.71% * | 3.62s | 6.03s | -40.01% | 3 | 3 | 679.22K | 30.24M | | 08:SCAN HDFS | 4.70% | 2.19s | 3.00s | -26.77% | * 11.20% * | 3.06s | 4.23s | -27.72% | 3 | 3 | 139.14K | 12.09M | | 02:SCAN HDFS | 3.40% | 1.58s | 1.95s | -18.73% | * 11.67% * | 2.47s | 3.41s | -27.46% | 3 | 3 | 2.56M | 120.96M | +---------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q22A [orc / snap / block] (7.53s -> 3.84s [-49.01%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 16:AGGREGATE | 13.96% | 1.39s | 1.91s | -27.07% | 3.09% | 1.47s | 2.02s | -27.47% | 1 | 1 | 26.98K | 41.88M | | 13:HASH JOIN | 6.50% | 648.19ms | 760.19ms | -14.73% | 7.24% | 771.97ms | 867.97ms | -11.06% | 1 | 1 | 8.43M | 41.88M | | 24:AGGREGATE | 10.59% | 1.06s | 1.70s | -37.99% | 6.67% | 1.24s | 1.82s | -32.02% | 1 | 1 | 26.97K | 37.31M | | 21:HASH JOIN | 5.57% | 556.19ms | 2.21s | -74.86% | 9.09% | 683.98ms | 2.42s | -71.69% | 1 | 1 | 8.43M | 41.88M | | 32:AGGREGATE | 6.07% | 605.24ms | 1.29s | -52.94% | 8.07% | 683.98ms | 1.41s | -51.42% | 1 | 1 | 26.94K | 54.00K | | 29:HASH JOIN | 5.08% | 506.51ms | 2.19s | -76.86% | 6.48% | 563.98ms | 2.34s | -75.94% | 1 | 1 | 8.43M | 41.88M | | 37:HASH JOIN | 3.77% | 375.99ms | 1.76s | -78.60% | 6.64% | 427.99ms | 1.99s | -78.47% | 1 | 1 | 8.43M | 41.88M | | 08:AGGREGATE | 16.04% | 1.60s | 2.13s | -24.99% | 3.81% | 1.72s | 2.32s | -26.16% | 1 | 1 | 26.99K | 41.88M | | 05:HASH JOIN | 6.42% | 640.61ms | 810.92ms | -21.00% | 5.99% | 711.98ms | 951.97ms | -25.21% | 1 | 1 | 8.43M | 41.88M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q37 [orc / snap / block] (3.51s -> 1.47s [-58.10%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 33.03% | 650.08ms | 2.83s | -77.03% | 7.45% | 767.97ms | 2.90s | -73.55% | 1 | 1 | 558.64K | 4.23M | | 00:SCAN HDFS | 41.41% | 815.13ms | 2.90s | -71.91% | 4.02% | 867.97ms | 2.96s | -70.64% | 1 | 1 | 1 | 71 | | 03:SCAN HDFS | 20.97% | 412.69ms | 356.62ms | +15.72% | 2.72% | 467.98ms | 419.99ms | +11.43% | 3 | 3 | 2.20K | 60.48M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q58 [orc / snap / block] (7.81s -> 3.04s [-61.04%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 13:SCAN HDFS | 12.78% | 967.34ms | 878.08ms | +10.17% | * 10.18% * | 1.14s | 1.08s | +5.56% | 1 | 1 | 7 | 73.05K | | 11:SCAN HDFS | 3.10% | 234.45ms | 291.85ms | -19.67% | * 11.58% * | 355.99ms | 451.98ms | -21.24% | 3 | 3 | 158.10K | 60.48M | | 24:SCAN HDFS | 13.10% | 991.55ms | 934.92ms | +6.06% | 7.03% | 1.20s | 1.03s | +16.34% | 1 | 1 | 7 | 73.05K | | 29:HASH JOIN | 10.26% | 776.61ms | 1.14s | -31.99% | 3.32% | 871.97ms | 1.31s | -33.33% | 3 | 3 | 30.24M | 29.95M | | 22:SCAN HDFS | 2.18% | 165.33ms | 196.48ms | -15.86% | * 12.34% * | 267.99ms | 319.99ms | -16.25% | 3 | 3 | 30.24M | 30.24M | | 02:SCAN HDFS | 14.76% | 1.12s | 1.04s | +7.30% | 7.00% | 1.30s | 1.18s | +10.51% | 1 | 1 | 7 | 73.05K | | 01:SCAN HDFS | 33.39% | 2.53s | 2.87s | -11.79% | 1.63% | 2.60s | 3.06s | -14.92% | 1 | 1 | 52.43K | 54.00K | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q80A [orc / snap / block] (25.13s -> 9.92s [-60.51%]) +---------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ | 53:SCAN HDFS | 6.62% | 4.68s | 4.56s | +2.47% | 4.57% | 5.59s | 5.54s | +1.01% | 3 | 3 | 341.34K | 6.05M | | 52:SCAN HDFS | 3.31% | 2.34s | 7.00s | -66.62% | 5.56% | 3.46s | 9.16s | -62.18% | 3 | 3 | 76.44K | 60.48M | | 65:SCAN HDFS | 6.37% | 4.50s | 4.29s | +4.88% | 6.84% | 5.40s | 5.08s | +6.38% | 3 | 3 | 170.74K | 3.02M | | 64:SCAN HDFS | 3.89% | 2.74s | 5.39s | -49.08% | 6.86% | 3.74s | 7.66s | -51.23% | 3 | 3 | 1.70M | 30.24M | | 41:SCAN HDFS | 7.46% | 5.27s | 5.26s | +0.17% | 4.32% | 5.91s | 6.67s | -11.39% | 3 | 3 | 681.75K | 12.09M | | 92:SCAN HDFS | 7.37% | 5.20s | 4.87s | +6.82% | 6.82% | 6.04s | 5.53s | +9.18% | 3 | 3 | 341.34K | 6.05M | | 91:SCAN HDFS | 3.40% | 2.40s | 7.23s | -66.80% | 5.18% | 3.58s | 9.44s | -62.03% | 3 | 3 | 76.44K | 60.48M | | 104:SCAN HDFS | 6.73% | 4.75s | 4.48s | +6.16% | 8.59% | 5.73s | 5.40s | +6.07% | 3 | 3 | 170.74K | 3.02M | | 103:SCAN HDFS | 4.19% | 2.96s | 5.52s | -46.36% | * 12.16% * | 3.97s | 7.94s | -49.97% | 3 | 3 | 1.70M | 30.24M | | 80:SCAN HDFS | 7.94% | 5.61s | 5.63s | -0.48% | 4.98% | 6.40s | 6.70s | -4.59% | 3 | 3 | 681.75K | 12.09M | | 15:SCAN HDFS | 6.98% | 4.93s | 4.89s | +0.71% | 4.80% | 5.82s | 5.76s | +0.90% | 3 | 3 | 341.34K | 6.05M | | 14:SCAN HDFS | 3.22% | 2.27s | 6.96s | -67.31% | 7.64% | 3.15s | 9.60s | -67.17% | 3 | 3 | 75.71K | 60.48M | | 27:SCAN HDFS | 6.23% | 4.39s | 4.19s | +4.79% | 5.70% | 5.31s | 4.93s | +7.79% | 3 | 3 | 170.74K | 3.02M | | 26:SCAN HDFS | 3.84% | 2.71s | 5.37s | -49.59% | 8.55% | 3.55s | 8.16s | -56.54% | 3 | 3 | 1.70M | 30.24M | | 03:SCAN HDFS | 7.62% | 5.38s | 5.43s | -0.99% | 5.81% | 6.62s | 6.81s | -2.76% | 3 | 3 | 681.75K | 12.09M | +---------------+------------+-------+----------+------------+------------+-------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q21 [orc / snap / block] (3.50s -> 1.27s [-63.68%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 74.16% | 198.73ms | 2.58s | -92.29% | * 19.85% * | 263.99ms | 2.84s | -90.72% | 1 | 1 | 95.13K | 42.28M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q39-1 [orc / snap / block] (8.04s -> 1.50s [-81.36%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 15:AGGREGATE | 3.29% | 94.52ms | 93.89ms | +0.67% | * 15.36% * | 124.00ms | 124.00ms | +0.00% | 1 | 1 | 162.00K | 17.20M | | 02:SCAN HDFS | 37.19% | 1.07s | 4.50s | -76.28% | 2.76% | 1.12s | 4.60s | -75.76% | 1 | 1 | 6 | 6 | | 01:SCAN HDFS | 37.70% | 1.08s | 4.50s | -75.99% | 2.71% | 1.13s | 4.60s | -75.50% | 1 | 1 | 9.53K | 54.00K | | 00:SCAN HDFS | 11.92% | 341.88ms | 7.08s | -95.17% | * 11.13% * | 399.99ms | 7.18s | -94.43% | 1 | 1 | 231.56K | 42.28M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(42) TPCDS-Q39-2 [orc / snap / block] (8.04s -> 1.49s [-81.50%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 15:AGGREGATE | 3.15% | 90.52ms | 92.00ms | -1.60% | * 14.84% * | 116.00ms | 116.00ms | +0.00% | 1 | 1 | 162.00K | 17.20M | | 02:SCAN HDFS | 37.45% | 1.08s | 4.48s | -75.96% | 3.41% | 1.14s | 4.54s | -74.98% | 1 | 1 | 6 | 6 | | 01:SCAN HDFS | 37.32% | 1.07s | 4.49s | -76.06% | 2.97% | 1.13s | 4.54s | -75.15% | 1 | 1 | 9.53K | 54.00K | | 00:SCAN HDFS | 12.02% | 345.88ms | 7.07s | -95.11% | 8.76% | 423.99ms | 7.14s | -94.06% | 1 | 1 | 231.56K | 42.28M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (V) Significant Variability: TPCDS(42) TPCDS-Q10A [orc / snap / block] (4.48% -> 10.19%) +--------------+------------+-----------+----------------+------------------+--------+-------+--------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-----------+----------------+------------------+--------+-------+--------+-----------+ | 01:SCAN HDFS | 2.45% | 32.70% | 47.35% | -30.94% | 1 | 1 | 2.98K | 866 | | 03:SCAN HDFS | 27.41% | 15.11% | 6.34% | +138.55% | 3 | 3 | 41.68K | 120.96M | | 10:SCAN HDFS | 3.25% | 21.87% | 6.83% | +220.45% | 3 | 3 | 9.53K | 60.48M | | 07:SCAN HDFS | 25.34% | 20.48% | 5.71% | +258.66% | 3 | 3 | 5.32K | 30.24M | +--------------+------------+-----------+----------------+------------------+--------+-------+--------+-----------+ Significant perf change detected.