Report Generated on 2022-06-23 Run Description: "7a26ff4b97603e60c91f5211e6e139affd213752 vs a585a73594a25825be1134a991a7bfba928da9bc" Cluster Name: UNKNOWN Lab Run Info: UNKNOWN Impala Version: impalad version 4.2.0-SNAPSHOT RELEASE () Baseline Impala Version: impalad version 4.2.0-SNAPSHOT RELEASE (2022-06-22) +-----------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +-----------+-----------------------+---------+------------+------------+----------------+ | TPCDS(30) | parquet / none / none | 3.00 | -2.64% | 1.63 | -4.29% | +-----------+-----------------------+---------+------------+------------+----------------+ +-----------+-------------+-----------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+--------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Iters | Median Diff(%) | MW Zval | Tval | +-----------+-------------+-----------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+--------+ | TPCDS(30) | TPCDS-Q28 | parquet / none / none | 3.79 | 3.78 | +0.37% | 1.73% | 0.99% | 15 | +0.99% | 1.15 | 0.72 | | TPCDS(30) | TPCDS-Q41 | parquet / none / none | 0.06 | 0.06 | +1.21% | 3.66% | 2.24% | 15 | +0.00% | 0.00 | 1.08 | | TPCDS(30) | TPCDS-Q51 | parquet / none / none | 5.58 | 5.56 | +0.27% | 0.68% | 0.74% | 15 | +0.04% | 0.87 | 1.03 | | TPCDS(30) | TPCDS-Q9 | parquet / none / none | 5.39 | 5.39 | -0.10% | 0.59% | 0.64% | 15 | -0.05% | -0.51 | -0.45 | | TPCDS(30) | TPCDS-Q51A | parquet / none / none | 51.48 | 51.55 | -0.15% | 0.53% | 0.49% | 15 | -0.18% | -0.87 | -0.78 | | TPCDS(30) | TPCDS-Q93 | parquet / none / none | 2.28 | 2.30 | -1.02% | 1.27% | 1.49% | 15 | -0.14% | -2.02 | -2.04 | | TPCDS(30) | TPCDS-Q78 | parquet / none / none | 10.24 | 10.31 | -0.68% | 0.76% | 0.41% | 15 | -0.51% | -2.02 | -3.07 | | TPCDS(30) | TPCDS-Q97 | parquet / none / none | 2.33 | 2.35 | -0.98% | 1.67% | 1.95% | 15 | -0.53% | -1.06 | -1.49 | | TPCDS(30) | TPCDS-Q38 | parquet / none / none | 2.07 | 2.10 | -1.23% | 0.99% | 1.10% | 15 | -0.46% | -1.15 | -3.24 | | TPCDS(30) | TPCDS-Q39-2 | parquet / none / none | 1.28 | 1.30 | -1.64% | 1.37% | 1.75% | 15 | -0.11% | -1.15 | -2.88 | | TPCDS(30) | TPCDS-Q44 | parquet / none / none | 2.04 | 2.07 | -1.71% | 0.67% | 2.31% | 15 | -0.49% | -3.08 | -2.76 | | TPCDS(30) | TPCDS-Q32 | parquet / none / none | 0.60 | 0.61 | -2.31% | 4.31% | 4.12% | 15 | -0.07% | -0.37 | -1.52 | | TPCDS(30) | TPCDS-Q67 | parquet / none / none | 20.67 | 20.93 | -1.21% | 0.70% | 0.64% | 15 | -1.21% | -3.45 | -4.97 | | TPCDS(30) | TPCDS-Q36 | parquet / none / none | 1.53 | 1.57 | -2.13% | 3.34% | 2.22% | 15 | -0.30% | -2.02 | -2.08 | | TPCDS(30) | TPCDS-Q22 | parquet / none / none | 3.22 | 3.26 | -1.10% | 1.87% | 0.95% | 15 | -1.55% | -1.98 | -2.04 | | TPCDS(30) | TPCDS-Q23-2 | parquet / none / none | 12.20 | 12.37 | -1.40% | 0.56% | 0.91% | 15 | -1.48% | -3.86 | -5.09 | | TPCDS(30) | TPCDS-Q23-1 | parquet / none / none | 11.97 | 12.19 | -1.75% | 0.70% | 2.57% | 15 | -1.31% | -2.85 | -2.55 | | TPCDS(30) | TPCDS-Q67A | parquet / none / none | 25.61 | 26.10 | -1.86% | 0.50% | 1.40% | 15 | -1.53% | -4.09 | -4.87 | | TPCDS(30) | TPCDS-Q14-2 | parquet / none / none | 10.66 | 10.84 | -1.63% | 1.02% | 1.63% | 15 | -1.83% | -2.53 | -3.30 | | TPCDS(30) | TPCDS-Q52 | parquet / none / none | 0.50 | 0.52 | -3.18% | 2.82% | 4.23% | 15 | -0.33% | -0.96 | -2.44 | | TPCDS(30) | TPCDS-Q14-1 | parquet / none / none | 10.32 | 10.50 | -1.66% | 1.48% | 0.81% | 15 | -1.86% | -3.86 | -3.88 | | TPCDS(30) | TPCDS-Q43 | parquet / none / none | 0.79 | 0.81 | -3.00% | 2.92% | 2.42% | 15 | -0.62% | -2.21 | -3.12 | | TPCDS(30) | TPCDS-Q1 | parquet / none / none | 1.35 | 1.38 | -1.77% | 0.98% | 2.48% | 15 | -2.17% | -1.10 | -2.57 | | TPCDS(30) | TPCDS-Q87 | parquet / none / none | 1.92 | 1.95 | -1.56% | 1.93% | 1.91% | 15 | -2.48% | -2.39 | -2.23 | | TPCDS(30) | TPCDS-Q65 | parquet / none / none | 1.94 | 1.97 | -1.82% | 1.25% | 1.55% | 15 | -2.46% | -2.48 | -3.56 | | TPCDS(30) | TPCDS-Q84 | parquet / none / none | 0.60 | 0.62 | -3.56% | 4.36% | 3.22% | 15 | -0.73% | -1.75 | -2.60 | | TPCDS(30) | TPCDS-Q47 | parquet / none / none | 3.97 | 4.05 | -1.94% | 1.51% | 1.20% | 15 | -2.36% | -3.12 | -3.93 | | TPCDS(30) | TPCDS-Q57 | parquet / none / none | 2.45 | 2.52 | -2.92% | 1.21% | 1.52% | 15 | -2.18% | -3.77 | -5.90 | | TPCDS(30) | TPCDS-Q10A | parquet / none / none | 1.15 | 1.18 | -2.80% | 4.16% | 2.04% | 15 | -2.76% | -1.93 | -2.39 | | TPCDS(30) | TPCDS-Q18 | parquet / none / none | 1.60 | 1.65 | -3.05% | 1.41% | 1.75% | 15 | -3.16% | -3.58 | -5.33 | | TPCDS(30) | TPCDS-Q4 | parquet / none / none | 5.17 | 5.34 | -3.19% | 0.57% | 0.73% | 15 | -3.23% | -4.50 | -13.53 | | TPCDS(30) | TPCDS-Q22A | parquet / none / none | 2.15 | 2.23 | -3.42% | 2.09% | 1.89% | 15 | -3.00% | -3.31 | -4.78 | | TPCDS(30) | TPCDS-Q75 | parquet / none / none | 5.03 | 5.19 | -3.20% | 1.38% | 1.14% | 15 | -3.40% | -4.27 | -7.07 | | TPCDS(30) | TPCDS-Q24-2 | parquet / none / none | 4.97 | 5.11 | -2.78% | 6.48% | 7.46% | 15 | -3.86% | -2.66 | -1.10 | | TPCDS(30) | TPCDS-Q35A | parquet / none / none | 1.27 | 1.31 | -3.06% | 2.34% | 1.78% | 15 | -3.91% | -2.76 | -4.12 | | TPCDS(30) | TPCDS-Q59 | parquet / none / none | 1.32 | 1.37 | -3.24% | 1.55% | 1.64% | 15 | -3.86% | -3.81 | -5.65 | | TPCDS(30) | TPCDS-Q11 | parquet / none / none | 3.57 | 3.70 | -3.34% | 2.76% | 1.59% | 15 | -3.79% | -3.54 | -4.17 | | TPCDS(30) | TPCDS-Q39-1 | parquet / none / none | 1.27 | 1.31 | -3.32% | 1.68% | 1.84% | 15 | -3.90% | -4.04 | -5.24 | | TPCDS(30) | TPCDS-Q77A | parquet / none / none | 3.85 | 4.00 | -3.62% | 0.59% | 0.85% | 15 | -3.69% | -4.50 | -13.72 | | TPCDS(30) | TPCDS-Q17 | parquet / none / none | 1.43 | 1.49 | -3.72% | 1.87% | 2.26% | 15 | -3.71% | -3.31 | -4.99 | | TPCDS(30) | TPCDS-Q64 | parquet / none / none | 4.83 | 5.01 | -3.65% | 1.14% | 1.13% | 15 | -3.88% | -4.37 | -8.98 | | TPCDS(30) | TPCDS-Q24-1 | parquet / none / none | 4.88 | 5.06 | -3.57% | 7.98% | 7.88% | 15 | -4.06% | -2.48 | -1.26 | | TPCDS(30) | TPCDS-Q74 | parquet / none / none | 2.73 | 2.84 | -3.95% | 2.83% | 2.78% | 15 | -3.76% | -3.91 | -3.93 | | TPCDS(30) | TPCDS-Q99 | parquet / none / none | 1.21 | 1.26 | -3.57% | 2.76% | 1.89% | 15 | -4.17% | -3.95 | -4.24 | | TPCDS(30) | TPCDS-Q58 | parquet / none / none | 1.53 | 1.60 | -4.26% | 1.85% | 2.47% | 15 | -3.60% | -3.63 | -5.42 | | TPCDS(30) | TPCDS-Q33 | parquet / none / none | 1.12 | 1.16 | -3.43% | 4.96% | 4.26% | 15 | -4.50% | -1.61 | -2.07 | | TPCDS(30) | TPCDS-Q72 | parquet / none / none | 2.30 | 2.39 | -3.70% | 1.76% | 1.22% | 15 | -4.36% | -4.04 | -6.86 | | TPCDS(30) | TPCDS-Q85 | parquet / none / none | 1.32 | 1.38 | -4.21% | 2.65% | 1.80% | 15 | -4.00% | -3.68 | -5.24 | | TPCDS(30) | TPCDS-Q2 | parquet / none / none | 1.15 | 1.20 | -4.25% | 2.43% | 2.83% | 15 | -4.44% | -3.81 | -4.49 | | TPCDS(30) | TPCDS-Q70A | parquet / none / none | 3.27 | 3.42 | -4.21% | 1.54% | 1.19% | 15 | -4.57% | -4.41 | -8.61 | | TPCDS(30) | TPCDS-Q69 | parquet / none / none | 1.05 | 1.09 | -4.00% | 2.35% | 2.67% | 15 | -4.78% | -3.12 | -4.44 | | TPCDS(30) | TPCDS-Q60 | parquet / none / none | 1.21 | 1.27 | -4.79% | 3.76% | 3.80% | 15 | -4.15% | -2.48 | -3.55 | | TPCDS(30) | TPCDS-Q76 | parquet / none / none | 2.19 | 2.29 | -4.37% | * 25.35% * | * 24.90% * | 15 | -4.90% | -3.86 | -0.49 | | TPCDS(30) | TPCDS-Q48 | parquet / none / none | 1.15 | 1.22 | I -5.15% | 1.98% | 0.35% | 15 | I -4.34% | -4.50 | -10.44 | | TPCDS(30) | TPCDS-Q56 | parquet / none / none | 1.18 | 1.24 | -5.15% | 4.78% | 5.32% | 15 | -4.47% | -2.21 | -2.85 | | TPCDS(30) | TPCDS-Q96 | parquet / none / none | 1.03 | 1.08 | -4.85% | 2.43% | 4.00% | 15 | -4.83% | -2.76 | -4.07 | | TPCDS(30) | TPCDS-Q86A | parquet / none / none | 1.12 | 1.19 | I -5.18% | 1.85% | 1.51% | 15 | I -4.50% | -4.50 | -8.66 | | TPCDS(30) | TPCDS-Q25 | parquet / none / none | 1.18 | 1.25 | I -5.46% | 2.78% | 2.47% | 15 | I -4.43% | -3.68 | -5.87 | | TPCDS(30) | TPCDS-Q26 | parquet / none / none | 0.99 | 1.04 | -4.71% | 2.62% | 2.14% | 15 | -5.30% | -3.26 | -5.55 | | TPCDS(30) | TPCDS-Q62 | parquet / none / none | 0.97 | 1.02 | -4.81% | 1.45% | 2.53% | 15 | -5.22% | -3.91 | -6.47 | | TPCDS(30) | TPCDS-Q71 | parquet / none / none | 1.10 | 1.16 | I -5.28% | 5.13% | 4.47% | 15 | I -4.82% | -3.63 | -3.10 | | TPCDS(30) | TPCDS-Q53 | parquet / none / none | 1.01 | 1.07 | I -5.14% | 1.36% | 1.63% | 15 | I -5.07% | -4.14 | -9.58 | | TPCDS(30) | TPCDS-Q46 | parquet / none / none | 1.06 | 1.12 | I -5.50% | 2.05% | 0.43% | 15 | I -4.75% | -4.50 | -10.75 | | TPCDS(30) | TPCDS-Q6 | parquet / none / none | 1.07 | 1.13 | I -5.41% | 1.69% | 2.12% | 15 | I -4.84% | -3.95 | -7.88 | | TPCDS(30) | TPCDS-Q49 | parquet / none / none | 2.01 | 2.12 | I -5.31% | 2.80% | 3.61% | 15 | I -5.00% | -3.31 | -4.60 | | TPCDS(30) | TPCDS-Q80A | parquet / none / none | 4.98 | 5.25 | I -5.04% | 0.66% | 0.59% | 15 | I -5.33% | -4.50 | -22.75 | | TPCDS(30) | TPCDS-Q89 | parquet / none / none | 1.12 | 1.19 | I -5.46% | 2.45% | 2.18% | 15 | I -4.94% | -4.18 | -6.65 | | TPCDS(30) | TPCDS-Q50 | parquet / none / none | 1.93 | 2.04 | I -5.15% | 1.07% | 1.20% | 15 | I -5.25% | -4.50 | -12.70 | | TPCDS(30) | TPCDS-Q70 | parquet / none / none | 1.76 | 1.85 | I -5.00% | 1.10% | 1.39% | 15 | I -5.57% | -4.50 | -11.13 | | TPCDS(30) | TPCDS-Q27 | parquet / none / none | 1.12 | 1.19 | I -5.77% | 1.15% | 2.27% | 15 | I -4.84% | -4.50 | -8.88 | | TPCDS(30) | TPCDS-Q63 | parquet / none / none | 1.01 | 1.06 | I -5.12% | 2.32% | 1.21% | 15 | I -5.50% | -4.37 | -7.89 | | TPCDS(30) | TPCDS-Q54 | parquet / none / none | 1.65 | 1.73 | -4.89% | 1.34% | 1.63% | 15 | -5.95% | -4.18 | -9.16 | | TPCDS(30) | TPCDS-Q20 | parquet / none / none | 0.83 | 0.87 | -4.88% | 2.71% | 2.84% | 15 | -6.06% | -3.54 | -4.94 | | TPCDS(30) | TPCDS-Q88 | parquet / none / none | 5.43 | 5.73 | I -5.29% | 0.56% | 0.69% | 15 | I -5.67% | -4.50 | -23.43 | | TPCDS(30) | TPCDS-Q29 | parquet / none / none | 1.29 | 1.38 | I -6.19% | 2.76% | 1.79% | 15 | I -4.82% | -4.50 | -7.60 | | TPCDS(30) | TPCDS-Q79 | parquet / none / none | 0.85 | 0.90 | I -5.17% | 2.13% | 2.47% | 15 | I -5.85% | -3.40 | -6.29 | | TPCDS(30) | TPCDS-Q86 | parquet / none / none | 0.86 | 0.91 | -5.55% | 4.45% | 6.12% | 15 | -5.81% | -2.16 | -2.90 | | TPCDS(30) | TPCDS-Q31 | parquet / none / none | 2.53 | 2.67 | I -5.49% | 1.48% | 1.74% | 15 | I -5.88% | -4.50 | -9.52 | | TPCDS(30) | TPCDS-Q68 | parquet / none / none | 0.84 | 0.89 | I -5.44% | 2.95% | 2.81% | 15 | I -5.93% | -3.72 | -5.31 | | TPCDS(30) | TPCDS-Q83 | parquet / none / none | 1.00 | 1.06 | I -5.97% | 3.27% | 2.27% | 15 | I -5.41% | -4.09 | -6.05 | | TPCDS(30) | TPCDS-Q61 | parquet / none / none | 0.99 | 1.06 | I -6.31% | 2.35% | 1.86% | 15 | I -5.10% | -4.14 | -8.47 | | TPCDS(30) | TPCDS-Q45 | parquet / none / none | 1.03 | 1.10 | I -6.52% | 1.69% | 2.24% | 15 | I -5.04% | -4.37 | -9.20 | | TPCDS(30) | TPCDS-Q90 | parquet / none / none | 0.63 | 0.66 | -4.39% | 2.81% | 3.59% | 15 | -7.27% | -2.53 | -3.79 | | TPCDS(30) | TPCDS-Q7 | parquet / none / none | 0.96 | 1.02 | I -5.90% | 1.31% | 2.04% | 15 | I -5.77% | -4.50 | -9.60 | | TPCDS(30) | TPCDS-Q91 | parquet / none / none | 0.65 | 0.69 | I -5.14% | 3.72% | 3.40% | 15 | I -6.63% | -2.62 | -4.06 | | TPCDS(30) | TPCDS-Q92 | parquet / none / none | 0.59 | 0.62 | -4.08% | 4.11% | 5.17% | 15 | -7.69% | -1.65 | -2.43 | | TPCDS(30) | TPCDS-Q34 | parquet / none / none | 0.83 | 0.88 | I -5.30% | 3.03% | 2.38% | 15 | I -6.52% | -3.72 | -5.50 | | TPCDS(30) | TPCDS-Q82 | parquet / none / none | 0.87 | 0.92 | I -5.90% | 2.59% | 2.55% | 15 | I -6.04% | -3.40 | -6.49 | | TPCDS(30) | TPCDS-Q94 | parquet / none / none | 0.74 | 0.78 | I -5.37% | 3.07% | 3.33% | 15 | I -6.72% | -2.80 | -4.71 | | TPCDS(30) | TPCDS-Q19 | parquet / none / none | 0.66 | 0.70 | I -5.32% | 2.20% | 2.43% | 15 | I -7.04% | -3.26 | -6.44 | | TPCDS(30) | TPCDS-Q30 | parquet / none / none | 1.39 | 1.47 | I -5.41% | 2.55% | 2.43% | 15 | I -6.96% | -3.95 | -6.12 | | TPCDS(30) | TPCDS-Q18A | parquet / none / none | 3.67 | 3.92 | I -6.34% | 0.99% | 2.08% | 15 | I -6.12% | -4.50 | -10.79 | | TPCDS(30) | TPCDS-Q15 | parquet / none / none | 0.74 | 0.78 | I -5.69% | 3.30% | 2.84% | 15 | I -7.05% | -4.09 | -5.23 | | TPCDS(30) | TPCDS-Q40 | parquet / none / none | 0.87 | 0.93 | I -6.73% | 2.80% | 3.61% | 15 | I -6.03% | -3.54 | -5.85 | | TPCDS(30) | TPCDS-Q21 | parquet / none / none | 0.77 | 0.83 | I -6.40% | 1.80% | 2.04% | 15 | I -6.46% | -4.09 | -9.38 | | TPCDS(30) | TPCDS-Q13 | parquet / none / none | 2.47 | 2.65 | I -6.59% | 1.11% | 1.14% | 15 | I -6.50% | -4.50 | -16.59 | | TPCDS(30) | TPCDS-Q77 | parquet / none / none | 1.45 | 1.55 | I -6.06% | 2.37% | 2.23% | 15 | I -7.05% | -4.14 | -7.45 | | TPCDS(30) | TPCDS-Q98 | parquet / none / none | 0.97 | 1.05 | I -7.04% | 2.32% | 2.32% | 15 | I -6.10% | -4.50 | -8.62 | | TPCDS(30) | TPCDS-Q81 | parquet / none / none | 1.38 | 1.47 | I -6.36% | 3.52% | 3.67% | 15 | I -7.20% | -3.63 | -4.99 | | TPCDS(30) | TPCDS-Q8 | parquet / none / none | 0.68 | 0.72 | I -6.08% | 3.48% | 2.48% | 15 | I -7.49% | -3.40 | -5.75 | | TPCDS(30) | TPCDS-Q12 | parquet / none / none | 0.83 | 0.90 | I -7.24% | 3.55% | 2.78% | 15 | I -6.65% | -3.81 | -6.51 | | TPCDS(30) | TPCDS-Q16 | parquet / none / none | 0.59 | 0.62 | I -5.71% | 4.01% | 3.11% | 15 | I -8.54% | -2.80 | -4.52 | | TPCDS(30) | TPCDS-Q5 | parquet / none / none | 1.25 | 1.34 | I -6.33% | 1.81% | 2.68% | 15 | I -7.96% | -4.23 | -7.73 | | TPCDS(30) | TPCDS-Q3 | parquet / none / none | 0.55 | 0.59 | I -6.02% | 0.64% | 3.88% | 15 | I -8.52% | -3.22 | -5.94 | | TPCDS(30) | TPCDS-Q66 | parquet / none / none | 1.83 | 1.97 | I -6.75% | 3.31% | 3.78% | 15 | I -7.98% | -3.63 | -5.36 | | TPCDS(30) | TPCDS-Q73 | parquet / none / none | 0.65 | 0.70 | I -7.75% | 3.08% | 2.61% | 15 | I -7.89% | -4.04 | -7.77 | | TPCDS(30) | TPCDS-Q55 | parquet / none / none | 0.48 | 0.52 | I -6.96% | 5.01% | 4.95% | 15 | I -9.17% | -2.62 | -3.96 | | TPCDS(30) | TPCDS-Q37 | parquet / none / none | 0.77 | 0.84 | I -8.91% | 3.48% | 2.92% | 15 | I -7.46% | -4.37 | -8.00 | | TPCDS(30) | TPCDS-Q42 | parquet / none / none | 0.50 | 0.53 | I -7.14% | 3.34% | 4.76% | 15 | I -9.39% | -2.66 | -4.87 | | TPCDS(30) | TPCDS-Q80 | parquet / none / none | 1.66 | 1.81 | I -8.32% | 2.25% | 2.54% | 15 | I -9.20% | -4.37 | -9.85 | | TPCDS(30) | TPCDS-Q95 | parquet / none / none | 1.55 | 1.77 | I -12.43% | 2.59% | 3.97% | 15 | I -16.17% | -4.46 | -10.53 | +-----------+-------------+-----------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+--------+ (I) Improvement: TPCDS(30) TPCDS-Q48 [parquet / none / none] (1.22s -> 1.15s [-5.15%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 79.16% | 194.29ms | 201.43ms | -3.55% | 5.86% | 224.00ms | 236.00ms | -5.08% | 3 | 3 | 15.87K | 8.64M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q86A [parquet / none / none] (1.19s -> 1.12s [-5.18%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | 12:AGGREGATE | 12.74% | 133.43ms | 136.48ms | -2.23% | 6.69% | 180.00ms | 168.00ms | +7.14% | 3 | 3 | 399 | 990 | | 19:AGGREGATE | 13.21% | 138.38ms | 140.86ms | -1.76% | 5.86% | 176.00ms | 212.00ms | -16.98% | 3 | 3 | 399 | 990 | | 18:HASH JOIN | 5.79% | 60.67ms | 71.33ms | -14.95% | * 15.33% * | 108.00ms | 104.00ms | +3.85% | 3 | 3 | 4.34M | 21.60M | | 06:AGGREGATE | 13.63% | 142.76ms | 141.24ms | +1.08% | 9.07% | 204.00ms | 188.00ms | +8.51% | 3 | 3 | 399 | 990 | | 05:HASH JOIN | 6.40% | 67.05ms | 68.67ms | -2.36% | 8.32% | 100.00ms | 108.00ms | -7.41% | 3 | 3 | 4.34M | 21.60M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q25 [parquet / none / none] (1.25s -> 1.18s [-5.46%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 00:SCAN HDFS | 21.23% | 284.38ms | 300.95ms | -5.51% | * 11.67% * | 396.00ms | 392.00ms | +1.02% | 3 | 3 | 770.97K | 86.41M | | 01:SCAN HDFS | 48.00% | 642.86ms | 684.09ms | -6.03% | 4.98% | 720.00ms | 780.00ms | -7.69% | 3 | 3 | 63.71K | 8.64M | | 02:SCAN HDFS | 11.97% | 160.29ms | 165.33ms | -3.05% | 5.49% | 184.00ms | 192.00ms | -4.17% | 3 | 3 | 364.81K | 43.20M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q71 [parquet / none / none] (1.16s -> 1.10s [-5.28%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | 05:SCAN HDFS | 46.43% | 151.33ms | 162.86ms | -7.08% | * 13.59% * | 216.00ms | 252.00ms | -14.29% | 3 | 3 | 9.54K | 43.20M | | 02:SCAN HDFS | 36.21% | 118.00ms | 128.00ms | -7.81% | 7.53% | 168.00ms | 196.00ms | -14.29% | 3 | 3 | 4.73K | 21.60M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q53 [parquet / none / none] (1.07s -> 1.01s [-5.14%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 66.98% | 109.52ms | 123.90ms | -11.61% | * 12.47% * | 176.00ms | 200.00ms | -12.00% | 3 | 3 | 623.61K | 86.41M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q46 [parquet / none / none] (1.12s -> 1.06s [-5.50%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 10:SCAN HDFS | 45.92% | 378.57ms | 402.86ms | -6.03% | 3.45% | 416.00ms | 440.00ms | -5.45% | 1 | 1 | 433.00K | 433.00K | | 09:AGGREGATE | 10.93% | 90.10ms | 92.29ms | -2.37% | * 13.44% * | 128.00ms | 140.00ms | -8.57% | 3 | 3 | 145.01K | 6.80M | | 00:SCAN HDFS | 9.55% | 78.76ms | 80.86ms | -2.59% | * 18.74% * | 132.00ms | 132.00ms | +0.00% | 3 | 3 | 1.59M | 86.41M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q6 [parquet / none / none] (1.13s -> 1.07s [-5.41%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 04:SCAN HDFS | 30.84% | 771.43ms | 825.71ms | -6.57% | 0.94% | 784.00ms | 840.00ms | -6.67% | 1 | 1 | 39.96K | 40.00K | | 03:SCAN HDFS | 31.29% | 782.58ms | 840.29ms | -6.87% | 0.98% | 800.00ms | 852.00ms | -6.10% | 1 | 1 | 31 | 73.05K | | 01:SCAN HDFS | 31.85% | 796.58ms | 857.14ms | -7.07% | 1.15% | 816.00ms | 876.00ms | -6.85% | 1 | 1 | 433.00K | 433.00K | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q49 [parquet / none / none] (2.12s -> 2.01s [-5.31%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 13:SCAN HDFS | 7.33% | 105.71ms | 114.57ms | -7.73% | * 15.27% * | 176.00ms | 172.00ms | +2.33% | 3 | 3 | 37.18K | 432.23K | | 12:SCAN HDFS | 25.30% | 364.67ms | 370.19ms | -1.49% | 8.79% | 460.00ms | 552.00ms | -16.67% | 3 | 3 | 564.25K | 4.32M | | 24:SCAN HDFS | 12.01% | 173.14ms | 174.76ms | -0.93% | 9.57% | 280.00ms | 280.00ms | +0.00% | 3 | 3 | 14.16K | 863.66K | | 23:SCAN HDFS | 7.08% | 102.10ms | 108.86ms | -6.21% | * 16.95% * | 192.00ms | 412.00ms | -53.40% | 3 | 3 | 691.17K | 8.64M | | 02:SCAN HDFS | 5.05% | 72.76ms | 71.33ms | +2.00% | * 16.72% * | 132.00ms | 128.00ms | +3.13% | 3 | 3 | 17.74K | 216.05K | | 01:SCAN HDFS | 25.72% | 370.76ms | 382.10ms | -2.97% | * 10.83% * | 536.00ms | 524.00ms | +2.29% | 3 | 3 | 284.76K | 2.16M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q80A [parquet / none / none] (5.25s -> 4.98s [-5.04%]) +---------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 53:SCAN HDFS | 3.56% | 676.76ms | 586.67ms | +15.36% | 9.27% | 996.00ms | 1.06s | -6.04% | 3 | 3 | 785.10K | 4.32M | | 52:SCAN HDFS | 6.53% | 1.24s | 890.38ms | +39.50% | * 13.42% * | 1.56s | 1.34s | +15.77% | 3 | 3 | 2.46M | 43.20M | | 65:SCAN HDFS | 3.74% | 711.24ms | 794.57ms | -10.49% | 6.19% | 1.15s | 1.20s | -4.00% | 3 | 3 | 662.17K | 2.16M | | 64:SCAN HDFS | 4.95% | 941.72ms | 765.05ms | +23.09% | 5.16% | 1.44s | 936.00ms | +53.85% | 3 | 3 | 1.23M | 21.60M | | 41:SCAN HDFS | 4.75% | 903.43ms | 1.03s | -12.40% | * 11.87% * | 1.48s | 1.74s | -14.98% | 3 | 3 | 1.03M | 8.64M | | 40:SCAN HDFS | 2.87% | 545.33ms | 354.48ms | +53.84% | * 10.98% * | 1.41s | 908.00ms | +55.07% | 3 | 3 | 325.53K | 86.41M | | 92:SCAN HDFS | 2.78% | 529.43ms | 879.81ms | -39.82% | * 14.64% * | 980.00ms | 1.04s | -5.41% | 3 | 3 | 786.05K | 4.32M | | 91:SCAN HDFS | 5.03% | 956.95ms | 1.47s | -34.77% | * 15.15% * | 1.20s | 1.65s | -27.36% | 3 | 3 | 2.46M | 43.20M | | 104:SCAN HDFS | 3.61% | 687.05ms | 950.29ms | -27.70% | 3.99% | 1.18s | 1.29s | -8.70% | 3 | 3 | 663.12K | 2.16M | | 103:SCAN HDFS | 4.67% | 888.86ms | 919.33ms | -3.31% | * 11.21% * | 1.20s | 1.60s | -25.19% | 3 | 3 | 1.23M | 21.60M | | 80:SCAN HDFS | 4.15% | 789.05ms | 1.13s | -30.34% | * 17.83% * | 1.38s | 1.73s | -20.14% | 3 | 3 | 1.03M | 8.64M | | 79:SCAN HDFS | 2.45% | 465.33ms | 503.52ms | -7.58% | * 13.59% * | 1.19s | 1.32s | -9.70% | 3 | 3 | 325.53K | 86.41M | | 15:SCAN HDFS | 3.18% | 604.48ms | 694.38ms | -12.95% | 7.00% | 888.00ms | 1.13s | -21.55% | 3 | 3 | 785.05K | 4.32M | | 14:SCAN HDFS | 6.50% | 1.24s | 1.24s | -0.46% | * 13.25% * | 1.60s | 1.66s | -3.37% | 3 | 3 | 2.46M | 43.20M | | 27:SCAN HDFS | 3.98% | 757.33ms | 602.48ms | +25.70% | 6.44% | 1.00s | 1.12s | -10.68% | 3 | 3 | 663.08K | 2.16M | | 26:SCAN HDFS | 5.06% | 962.57ms | 912.67ms | +5.47% | 9.26% | 1.36s | 1.21s | +12.91% | 3 | 3 | 1.23M | 21.60M | | 03:SCAN HDFS | 4.50% | 856.00ms | 1.13s | -23.99% | * 17.99% * | 1.51s | 1.76s | -14.51% | 3 | 3 | 1.03M | 8.64M | | 02:SCAN HDFS | 2.64% | 501.62ms | 402.10ms | +24.75% | * 23.25% * | 1.22s | 1.13s | +8.16% | 3 | 3 | 208.92K | 86.41M | +---------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q89 [parquet / none / none] (1.19s -> 1.12s [-5.46%]) +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 07:AGGREGATE | 40.83% | 88.38ms | 89.81ms | -1.59% | * 14.32% * | 136.00ms | 148.00ms | -8.11% | 3 | 3 | 16.17K | 319.82K | | 01:SCAN HDFS | 24.20% | 52.38ms | 54.19ms | -3.34% | * 26.69% * | 144.00ms | 132.00ms | +9.09% | 3 | 3 | 1.14M | 86.41M | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q50 [parquet / none / none] (2.04s -> 1.93s [-5.15%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 47.38% | 837.14ms | 903.52ms | -7.35% | 1.37% | 888.00ms | 960.00ms | -7.50% | 3 | 3 | 88.00K | 8.64M | | 00:SCAN HDFS | 46.68% | 824.86ms | 863.81ms | -4.51% | 1.23% | 860.00ms | 916.00ms | -6.11% | 3 | 3 | 755.65K | 86.41M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q70 [parquet / none / none] (1.85s -> 1.76s [-5.00%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 15:AGGREGATE | 15.52% | 293.71ms | 296.86ms | -1.06% | 4.63% | 360.00ms | 360.00ms | +0.00% | 3 | 3 | 18 | 7 | | 14:HASH JOIN | 5.66% | 107.14ms | 112.76ms | -4.98% | * 11.41% * | 144.00ms | 144.00ms | +0.00% | 3 | 3 | 16.03M | 86.41M | | 08:AGGREGATE | 5.60% | 106.00ms | 108.29ms | -2.11% | * 11.01% * | 152.00ms | 180.00ms | -15.56% | 3 | 3 | 6 | 2 | | 07:HASH JOIN | 4.90% | 92.76ms | 95.81ms | -3.18% | * 11.48% * | 140.00ms | 144.00ms | -2.78% | 3 | 3 | 16.03M | 86.41M | | 06:HASH JOIN | 6.10% | 115.33ms | 112.76ms | +2.28% | 8.92% | 168.00ms | 152.00ms | +10.53% | 3 | 3 | 16.03M | 86.41M | | 13:HASH JOIN | 4.73% | 89.52ms | 85.33ms | +4.91% | 8.06% | 128.00ms | 124.00ms | +3.23% | 3 | 3 | 16.03M | 86.41M | | 02:SCAN HDFS | 46.70% | 883.72ms | 859.43ms | +2.83% | 2.05% | 908.00ms | 884.00ms | +2.72% | 1 | 1 | 78 | 78 | | 12:HASH JOIN | 3.93% | 74.29ms | 72.86ms | +1.96% | * 13.91% * | 112.00ms | 116.00ms | -3.45% | 3 | 3 | 16.27M | 86.41M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q27 [parquet / none / none] (1.19s -> 1.12s [-5.77%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 00:SCAN HDFS | 57.22% | 167.14ms | 173.14ms | -3.47% | 9.69% | 204.00ms | 212.00ms | -3.77% | 3 | 3 | 127.95K | 86.41M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q63 [parquet / none / none] (1.06s -> 1.01s [-5.12%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 01:SCAN HDFS | 85.52% | 137.81ms | 147.81ms | -6.77% | * 14.10% * | 188.00ms | 200.00ms | -6.00% | 3 | 3 | 15.37K | 86.41M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q88 [parquet / none / none] (5.73s -> 5.43s [-5.29%]) +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ | 56:SCAN HDFS | 11.79% | 3.70s | 3.86s | -4.15% | 2.41% | 3.95s | 4.07s | -2.85% | 3 | 3 | 3.31M | 86.41M | | 48:SCAN HDFS | 11.90% | 3.74s | 3.89s | -3.98% | 1.65% | 4.02s | 4.07s | -1.28% | 3 | 3 | 2.88M | 86.41M | | 40:SCAN HDFS | 11.83% | 3.71s | 3.88s | -4.36% | 1.87% | 4.01s | 4.04s | -0.69% | 3 | 3 | 2.88M | 86.41M | | 32:SCAN HDFS | 11.72% | 3.68s | 3.84s | -4.12% | 1.52% | 3.96s | 3.98s | -0.40% | 3 | 3 | 4.96M | 86.41M | | 24:SCAN HDFS | 11.60% | 3.64s | 3.83s | -4.88% | 1.99% | 3.97s | 4.06s | -2.07% | 3 | 3 | 4.95M | 86.41M | | 16:SCAN HDFS | 11.93% | 3.74s | 3.91s | -4.21% | 1.57% | 4.00s | 4.12s | -3.01% | 3 | 3 | 3.30M | 86.41M | | 08:SCAN HDFS | 11.97% | 3.76s | 3.92s | -4.19% | 1.63% | 4.03s | 4.08s | -1.08% | 3 | 3 | 860.74K | 86.41M | | 00:SCAN HDFS | 11.92% | 3.74s | 3.94s | -5.09% | 1.92% | 4.06s | 4.11s | -1.17% | 3 | 3 | 432.75K | 86.41M | +--------------+------------+-------+----------+------------+-----------+-------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q29 [parquet / none / none] (1.38s -> 1.29s [-6.19%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | F02:EXCHANGE SENDER | 6.82% | 99.90ms | 101.43ms | -1.50% | 5.83% | 120.00ms | 120.00ms | +0.00% | 3 | 3 | -1 | -1 | | 00:SCAN HDFS | 19.31% | 282.76ms | 305.81ms | -7.54% | * 12.57% * | 368.00ms | 404.00ms | -8.91% | 3 | 3 | 1.77M | 86.41M | | 01:SCAN HDFS | 48.53% | 710.48ms | 764.76ms | -7.10% | 4.13% | 812.00ms | 868.00ms | -6.45% | 3 | 3 | 87.99K | 8.64M | | 02:SCAN HDFS | 8.43% | 123.43ms | 126.95ms | -2.78% | 7.31% | 152.00ms | 148.00ms | +2.70% | 3 | 3 | 2.19M | 43.20M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q79 [parquet / none / none] (0.90s -> 0.85s [-5.17%]) +---------------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | F05:EXCHANGE SENDER | 28.68% | 92.00ms | 92.57ms | -0.62% | 10.00% | 104.00ms | 100.00ms | +4.00% | 1 | 1 | -1 | -1 | +---------------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q31 [parquet / none / none] (2.67s -> 2.53s [-5.49%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | F23:EXCHANGE SENDER | 2.41% | 57.14ms | 59.43ms | -3.85% | * 45.01% * | 108.00ms | 96.00ms | +12.50% | 1 | 1 | -1 | -1 | | 30:SCAN HDFS | 9.21% | 218.76ms | 230.48ms | -5.08% | 9.57% | 312.00ms | 352.00ms | -11.36% | 3 | 3 | 1.15M | 21.60M | | 24:SCAN HDFS | 9.46% | 224.57ms | 251.71ms | -10.78% | * 16.87% * | 332.00ms | 336.00ms | -1.19% | 3 | 3 | 623.49K | 21.60M | | 18:SCAN HDFS | 9.12% | 216.67ms | 204.57ms | +5.91% | * 14.28% * | 324.00ms | 352.00ms | -7.95% | 3 | 3 | 657.31K | 21.60M | | 17:AGGREGATE | 3.41% | 81.05ms | 87.05ms | -6.89% | * 17.38% * | 132.00ms | 128.00ms | +3.13% | 3 | 3 | 5.54K | 1.43M | | 16:HASH JOIN | 3.43% | 81.43ms | 87.05ms | -6.45% | * 19.87% * | 152.00ms | 160.00ms | -5.00% | 3 | 3 | 4.29M | 8.66M | | 12:SCAN HDFS | 2.98% | 70.86ms | 101.62ms | -30.27% | * 28.23% * | 188.00ms | 256.00ms | -26.56% | 3 | 3 | 4.36M | 86.41M | | 10:HASH JOIN | 2.71% | 64.48ms | 60.76ms | +6.11% | * 21.82% * | 132.00ms | 124.00ms | +6.45% | 3 | 3 | 2.31M | 8.66M | | 06:SCAN HDFS | 2.82% | 66.95ms | 70.19ms | -4.61% | * 29.36% * | 168.00ms | 164.00ms | +2.44% | 3 | 3 | 2.33M | 86.41M | | 04:HASH JOIN | 3.01% | 71.52ms | 64.57ms | +10.77% | * 27.22% * | 136.00ms | 112.00ms | +21.43% | 3 | 3 | 2.46M | 8.66M | | F02:EXCHANGE SENDER | 2.39% | 56.86ms | 57.43ms | -0.99% | * 41.89% * | 100.00ms | 120.00ms | -16.67% | 1 | 1 | -1 | -1 | | 00:SCAN HDFS | 3.46% | 82.29ms | 75.14ms | +9.51% | * 29.37% * | 196.00ms | 160.00ms | +22.50% | 3 | 3 | 2.49M | 86.41M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q68 [parquet / none / none] (0.89s -> 0.84s [-5.44%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 10:SCAN HDFS | 62.91% | 382.57ms | 397.43ms | -3.74% | 3.57% | 408.00ms | 412.00ms | -0.97% | 1 | 1 | 433.00K | 433.00K | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q83 [parquet / none / none] (1.06s -> 1.00s [-5.97%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 12:SCAN HDFS | 19.52% | 523.72ms | 563.43ms | -7.05% | * 10.41% * | 592.00ms | 640.00ms | -7.50% | 1 | 1 | 21 | 73.05K | | 22:SCAN HDFS | 18.58% | 498.57ms | 586.57ms | -15.00% | * 14.42% * | 640.00ms | 692.00ms | -7.51% | 1 | 1 | 21 | 73.05K | | 02:SCAN HDFS | 21.67% | 581.43ms | 496.29ms | +17.16% | * 12.06% * | 672.00ms | 584.00ms | +15.07% | 1 | 1 | 21 | 73.05K | | 01:SCAN HDFS | 27.61% | 740.86ms | 700.00ms | +5.84% | 4.44% | 788.00ms | 752.00ms | +4.79% | 1 | 1 | 15.94K | 40.00K | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q61 [parquet / none / none] (1.06s -> 0.99s [-6.31%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 17:SCAN HDFS | 41.12% | 593.43ms | 628.00ms | -5.50% | 1.88% | 608.00ms | 644.00ms | -5.59% | 1 | 1 | 156.60K | 433.00K | | 04:SCAN HDFS | 49.55% | 715.15ms | 751.14ms | -4.79% | 1.72% | 744.00ms | 776.00ms | -4.12% | 1 | 1 | 156.60K | 433.00K | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q45 [parquet / none / none] (1.10s -> 1.03s [-6.52%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 74.33% | 750.29ms | 802.86ms | -6.55% | 1.49% | 776.00ms | 852.00ms | -8.92% | 1 | 1 | 433.00K | 433.00K | | 00:SCAN HDFS | 13.88% | 140.10ms | 157.14ms | -10.85% | 6.91% | 184.00ms | 228.00ms | -19.30% | 3 | 3 | 626.41K | 21.60M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q7 [parquet / none / none] (1.02s -> 0.96s [-5.90%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 00:SCAN HDFS | 64.82% | 179.91ms | 191.52ms | -6.07% | 9.04% | 236.00ms | 260.00ms | -9.23% | 3 | 3 | 230.60K | 86.41M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q91 [parquet / none / none] (0.69s -> 0.65s [-5.14%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | 03:SCAN HDFS | 58.15% | 346.86ms | 351.14ms | -1.22% | 8.94% | 400.00ms | 444.00ms | -9.91% | 1 | 1 | 422 | 433.00K | | 01:SCAN HDFS | 24.94% | 148.76ms | 169.52ms | -12.25% | * 20.87% * | 248.00ms | 272.00ms | -8.82% | 3 | 3 | 50 | 4.32M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q34 [parquet / none / none] (0.88s -> 0.83s [-5.30%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | F05:EXCHANGE SENDER | 46.08% | 130.29ms | 130.57ms | -0.22% | 7.93% | 148.00ms | 152.00ms | -2.63% | 1 | 1 | -1 | -1 | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q82 [parquet / none / none] (0.92s -> 0.87s [-5.90%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 03:SCAN HDFS | 36.29% | 335.52ms | 338.38ms | -0.84% | 5.43% | 380.00ms | 384.00ms | -1.04% | 3 | 3 | 15.63K | 86.41M | | 01:SCAN HDFS | 59.70% | 551.91ms | 588.00ms | -6.14% | 3.24% | 652.00ms | 712.00ms | -8.43% | 3 | 3 | 41 | 3.13M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q94 [parquet / none / none] (0.78s -> 0.74s [-5.37%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 14.78% | 120.10ms | 127.14ms | -5.54% | 7.46% | 156.00ms | 164.00ms | -4.88% | 3 | 3 | 2.12K | 21.60M | | 04:SCAN HDFS | 72.48% | 589.05ms | 629.24ms | -6.39% | 2.74% | 632.00ms | 668.00ms | -5.39% | 3 | 3 | 22.52K | 21.60M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q19 [parquet / none / none] (0.70s -> 0.66s [-5.32%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 03:SCAN HDFS | 59.48% | 410.29ms | 434.57ms | -5.59% | 4.54% | 464.00ms | 476.00ms | -2.52% | 1 | 1 | 433.00K | 433.00K | | 01:SCAN HDFS | 20.36% | 140.48ms | 136.48ms | +2.93% | * 16.99% * | 196.00ms | 196.00ms | +0.00% | 3 | 3 | 45.33K | 86.41M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q30 [parquet / none / none] (1.47s -> 1.39s [-5.41%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 08:SCAN HDFS | 5.26% | 103.90ms | 129.14ms | -19.54% | * 35.17% * | 208.00ms | 204.00ms | +1.96% | 3 | 3 | 410.84K | 2.16M | | 02:SCAN HDFS | 40.73% | 805.14ms | 743.71ms | +8.26% | 2.72% | 868.00ms | 820.00ms | +5.85% | 1 | 1 | 216.00K | 216.00K | | 00:SCAN HDFS | 30.89% | 610.48ms | 585.33ms | +4.30% | 3.07% | 720.00ms | 676.00ms | +6.51% | 3 | 3 | 411.69K | 2.16M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q18A [parquet / none / none] (3.92s -> 3.67s [-6.34%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 18:SCAN HDFS | 2.94% | 357.14ms | 726.57ms | -50.85% | * 14.23% * | 436.00ms | 816.00ms | -46.57% | 1 | 1 | 207.40K | 216.50K | | 15:SCAN HDFS | 7.76% | 943.62ms | 1.10s | -14.46% | 7.58% | 1.32s | 1.39s | -5.19% | 3 | 3 | 3.07M | 43.20M | | 29:SCAN HDFS | 7.67% | 933.52ms | 1.06s | -12.18% | 9.48% | 1.26s | 1.32s | -4.53% | 3 | 3 | 3.07M | 43.20M | | 46:SCAN HDFS | 5.35% | 650.86ms | 164.57ms | +295.49% | 7.21% | 716.00ms | 296.00ms | +141.89% | 1 | 1 | 207.40K | 216.50K | | 43:SCAN HDFS | 7.79% | 947.05ms | 1.04s | -9.05% | 9.97% | 1.31s | 1.35s | -2.67% | 3 | 3 | 3.07M | 43.20M | | F41:EXCHANGE SENDER | 2.26% | 275.14ms | 218.00ms | +26.21% | * 13.37% * | 324.00ms | 320.00ms | +1.25% | 1 | 1 | -1 | -1 | | 60:SCAN HDFS | 6.51% | 791.71ms | 801.14ms | -1.18% | 7.46% | 884.00ms | 904.00ms | -2.21% | 1 | 1 | 207.40K | 216.50K | | 57:SCAN HDFS | 8.40% | 1.02s | 1.01s | +1.23% | 5.59% | 1.25s | 1.35s | -7.42% | 3 | 3 | 3.07M | 43.20M | | 04:SCAN HDFS | 3.94% | 478.86ms | 484.00ms | -1.06% | * 16.46% * | 624.00ms | 640.00ms | -2.50% | 1 | 1 | 207.40K | 216.50K | | 01:SCAN HDFS | 7.95% | 966.67ms | 1.05s | -7.96% | 8.05% | 1.32s | 1.43s | -7.28% | 3 | 3 | 3.07M | 43.20M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q15 [parquet / none / none] (0.78s -> 0.74s [-5.69%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 66.17% | 462.29ms | 499.14ms | -7.38% | 2.26% | 480.00ms | 516.00ms | -6.98% | 1 | 1 | 433.00K | 433.00K | | 00:SCAN HDFS | 17.41% | 121.62ms | 117.33ms | +3.65% | * 13.78% * | 172.00ms | 176.00ms | -2.27% | 3 | 3 | 1.24M | 43.20M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q40 [parquet / none / none] (0.93s -> 0.87s [-6.73%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 82.29% | 636.48ms | 680.38ms | -6.45% | 2.11% | 680.00ms | 716.00ms | -5.03% | 3 | 3 | 277.31K | 4.32M | | 00:SCAN HDFS | 11.61% | 89.81ms | 98.57ms | -8.89% | 7.95% | 120.00ms | 132.00ms | -9.09% | 3 | 3 | 53.35K | 43.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q21 [parquet / none / none] (0.83s -> 0.77s [-6.40%]) +--------------+------------+---------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+---------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 00:SCAN HDFS | 62.44% | 60.00ms | 67.24ms | -10.76% | 8.01% | 192.00ms | 228.00ms | -15.79% | 3 | 3 | 418.00K | 31.32M | +--------------+------------+---------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q13 [parquet / none / none] (2.65s -> 2.47s [-6.59%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | 00:SCAN HDFS | 74.91% | 249.90ms | 254.00ms | -1.61% | 7.88% | 308.00ms | 308.00ms | +0.00% | 3 | 3 | 1.98K | 8.64M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q77 [parquet / none / none] (1.55s -> 1.45s [-6.06%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 18:SCAN HDFS | 6.53% | 72.67ms | 75.90ms | -4.27% | * 12.57% * | 164.00ms | 168.00ms | -2.38% | 3 | 3 | 40.07K | 4.32M | | 14:SCAN HDFS | 18.19% | 202.29ms | 232.10ms | -12.84% | 7.11% | 264.00ms | 324.00ms | -18.52% | 3 | 3 | 959.63K | 43.20M | | 29:SCAN HDFS | 5.53% | 61.52ms | 70.00ms | -12.11% | * 17.51% * | 124.00ms | 120.00ms | +3.33% | 3 | 3 | 13.89K | 2.16M | | 23:SCAN HDFS | 12.79% | 142.29ms | 165.14ms | -13.84% | * 11.93% * | 200.00ms | 224.00ms | -10.71% | 3 | 3 | 481.79K | 21.60M | | 07:SCAN HDFS | 15.02% | 167.05ms | 172.86ms | -3.36% | * 12.20% * | 244.00ms | 256.00ms | -4.69% | 3 | 3 | 88.42K | 8.64M | | 01:SCAN HDFS | 3.90% | 43.43ms | 40.67ms | +6.79% | * 37.49% * | 128.00ms | 96.00ms | +33.33% | 3 | 3 | 1.83M | 86.41M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q98 [parquet / none / none] (1.05s -> 0.97s [-7.04%]) +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q81 [parquet / none / none] (1.47s -> 1.38s [-6.36%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | F06:EXCHANGE SENDER | 2.28% | 44.29ms | 38.76ms | +14.25% | * 11.84% * | 100.00ms | 112.00ms | -10.71% | 3 | 3 | -1 | -1 | | 08:SCAN HDFS | 2.86% | 55.62ms | 54.29ms | +2.46% | * 20.77% * | 136.00ms | 136.00ms | +0.00% | 3 | 3 | 1.40M | 4.32M | | 02:SCAN HDFS | 45.22% | 880.00ms | 848.57ms | +3.70% | 2.45% | 920.00ms | 876.00ms | +5.02% | 1 | 1 | 216.00K | 216.00K | | 00:SCAN HDFS | 26.39% | 513.43ms | 487.71ms | +5.27% | 8.17% | 672.00ms | 636.00ms | +5.66% | 3 | 3 | 1.40M | 4.32M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q8 [parquet / none / none] (0.72s -> 0.68s [-6.08%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | 02:SCAN HDFS | 80.54% | 424.00ms | 459.14ms | -7.65% | 1.85% | 436.00ms | 516.00ms | -15.50% | 1 | 1 | 38 | 78 | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q12 [parquet / none / none] (0.90s -> 0.83s [-7.24%]) +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 68.80% | 98.29ms | 112.67ms | -12.76% | * 13.23% * | 144.00ms | 140.00ms | +2.86% | 3 | 3 | 61.02K | 21.60M | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q16 [parquet / none / none] (0.62s -> 0.59s [-5.71%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | F06:EXCHANGE SENDER | 15.20% | 89.33ms | 89.62ms | -0.32% | 5.38% | 116.00ms | 128.00ms | -9.37% | 3 | 3 | -1 | -1 | | 04:SCAN HDFS | 68.06% | 400.00ms | 439.81ms | -9.05% | 3.27% | 424.00ms | 500.00ms | -15.20% | 3 | 3 | 0 | 43.20M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q5 [parquet / none / none] (1.34s -> 1.25s [-6.33%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 10:SCAN HDFS | 3.72% | 78.76ms | 88.95ms | -11.46% | * 16.93% * | 144.00ms | 160.00ms | -10.00% | 3 | 3 | 463.85K | 43.20M | | 19:SCAN HDFS | 30.07% | 636.48ms | 694.57ms | -8.36% | 9.67% | 768.00ms | 812.00ms | -5.42% | 3 | 3 | 6.50K | 2.16M | | 20:SCAN HDFS | 41.66% | 881.81ms | 862.00ms | +2.30% | 3.70% | 1.01s | 952.00ms | +5.88% | 3 | 3 | 361.37K | 21.60M | | 18:SCAN HDFS | 4.56% | 96.57ms | 114.57ms | -15.71% | * 15.18% * | 144.00ms | 188.00ms | -23.40% | 3 | 3 | 233.38K | 21.60M | | 03:SCAN HDFS | 7.01% | 148.38ms | 164.76ms | -9.94% | 7.98% | 224.00ms | 244.00ms | -8.20% | 3 | 3 | 39.94K | 8.64M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q3 [parquet / none / none] (0.59s -> 0.55s [-6.02%]) +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q66 [parquet / none / none] (1.97s -> 1.83s [-6.75%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 11:SCAN HDFS | 39.17% | 230.19ms | 249.90ms | -7.89% | * 17.10% * | 348.00ms | 352.00ms | -1.14% | 3 | 3 | 327.45K | 43.20M | | 01:SCAN HDFS | 30.17% | 177.33ms | 194.86ms | -8.99% | * 11.15% * | 260.00ms | 300.00ms | -13.33% | 3 | 3 | 166.60K | 21.60M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q73 [parquet / none / none] (0.70s -> 0.65s [-7.75%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | F05:EXCHANGE SENDER | 75.55% | 136.86ms | 127.14ms | +7.64% | 9.64% | 156.00ms | 144.00ms | +8.33% | 1 | 1 | -1 | -1 | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q55 [parquet / none / none] (0.52s -> 0.48s [-6.96%]) +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q37 [parquet / none / none] (0.84s -> 0.77s [-8.91%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | 03:SCAN HDFS | 40.25% | 96.38ms | 105.90ms | -8.99% | * 10.27% * | 112.00ms | 120.00ms | -6.67% | 3 | 3 | 3.96K | 43.20M | | 01:SCAN HDFS | 49.05% | 117.43ms | 130.00ms | -9.67% | 1.74% | 220.00ms | 244.00ms | -9.84% | 3 | 3 | 21 | 3.13M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q42 [parquet / none / none] (0.53s -> 0.50s [-7.14%]) +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q80 [parquet / none / none] (1.81s -> 1.66s [-8.32%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 14:SCAN HDFS | 23.40% | 880.19ms | 898.76ms | -2.07% | 3.13% | 1.00s | 1.02s | -1.57% | 3 | 3 | 787.00K | 4.32M | | 13:SCAN HDFS | 5.62% | 211.33ms | 212.86ms | -0.72% | * 13.34% * | 288.00ms | 320.00ms | -10.00% | 3 | 3 | 53.37K | 43.20M | | 26:SCAN HDFS | 23.49% | 883.53ms | 852.86ms | +3.60% | 5.12% | 984.00ms | 976.00ms | +0.82% | 3 | 3 | 123.35K | 2.16M | | 25:SCAN HDFS | 4.26% | 160.10ms | 174.38ms | -8.19% | * 18.67% * | 256.00ms | 228.00ms | +12.28% | 3 | 3 | 1.23M | 21.60M | | 02:SCAN HDFS | 25.56% | 961.33ms | 980.48ms | -1.95% | 4.27% | 1.10s | 1.10s | +0.37% | 3 | 3 | 492.74K | 8.64M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCDS(30) TPCDS-Q95 [parquet / none / none] (1.77s -> 1.55s [-12.43%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 2.38% | 127.81ms | 128.10ms | -0.22% | 7.86% | 176.00ms | 160.00ms | +10.00% | 3 | 3 | 2.12K | 21.60M | | 05:SCAN HDFS | 18.26% | 980.86ms | 1.01s | -3.35% | 3.25% | 1.10s | 1.09s | +0.73% | 3 | 3 | 22.52K | 21.60M | | 04:SCAN HDFS | 18.01% | 967.53ms | 950.86ms | +1.75% | 1.46% | 1.04s | 1.03s | +0.39% | 3 | 3 | 22.52K | 21.60M | | 07:SCAN HDFS | 17.06% | 916.19ms | 902.57ms | +1.51% | 1.15% | 964.00ms | 952.00ms | +1.26% | 3 | 3 | 2.11M | 2.16M | | 10:HASH JOIN | 3.07% | 164.95ms | 318.95ms | -48.28% | * 16.09% * | 268.00ms | 488.00ms | -45.08% | 3 | 3 | 17.02M | 254.35M | | 09:SCAN HDFS | 17.09% | 918.10ms | 896.38ms | +2.42% | 1.44% | 1.01s | 968.00ms | +4.13% | 3 | 3 | 2.39M | 21.60M | | 08:SCAN HDFS | 16.49% | 885.43ms | 873.14ms | +1.41% | 1.04% | 940.00ms | 924.00ms | +1.73% | 3 | 3 | 1.79M | 21.60M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (V) Significant Variability: TPCDS(30) TPCDS-Q76 [parquet / none / none] (24.90% -> 25.35%) +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | 16:AGGREGATE | 2.60% | 14.11% | 11.92% | +18.32% | 3 | 3 | 1.93K | 1.91M | | 04:HASH JOIN | 2.80% | 14.06% | 16.05% | -12.44% | 3 | 3 | 1.94M | 3.89M | | 01:SCAN HDFS | 31.11% | 76.18% | 71.36% | +6.75% | 3 | 3 | 1.94M | 3.89M | +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ Significant perf change detected.