Report Generated on 2023-08-24 Run Description: "fe02f2e5c28d7e91f75b8e683bb8b4faeb028736 vs 951b51b994ec0db07c90d928a5fc4addfc52e9f7" Cluster Name: UNKNOWN Lab Run Info: UNKNOWN Impala Version: impalad version 4.3.0-SNAPSHOT RELEASE (2023-08-23) Baseline Impala Version: impalad version 4.3.0-SNAPSHOT RELEASE (2023-08-23) +----------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +----------+-----------------------+---------+------------+------------+----------------+ | TPCH(2) | parquet / none / none | 0.46 | -28.65% | 0.41 | -28.21% | +----------+-----------------------+---------+------------+------------+----------------+ +----------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+---------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Iters | Median Diff(%) | MW Zval | Tval | +----------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+---------+ | TPCH(2) | TPCH-Q1 | parquet / none / none | 0.60 | 0.55 | R +7.87% | 5.69% | 4.49% | 50 | R +7.98% | 5.55 | 7.33 | | TPCH(2) | TPCH-Q6 | parquet / none / none | 0.21 | 0.21 | -0.24% | 1.28% | 1.36% | 50 | -0.06% | -2.00 | -0.91 | | TPCH(2) | TPCH-Q12 | parquet / none / none | 0.35 | 0.39 | I -8.23% | 6.95% | 6.89% | 50 | I -4.68% | -5.00 | -6.20 | | TPCH(2) | TPCH-Q17 | parquet / none / none | 0.38 | 0.44 | I -12.44% | 6.30% | 6.12% | 50 | I -15.39% | -8.11 | -10.68 | | TPCH(2) | TPCH-Q14 | parquet / none / none | 0.30 | 0.37 | I -18.10% | 6.96% | 5.44% | 50 | I -16.44% | -8.35 | -16.24 | | TPCH(2) | TPCH-Q13 | parquet / none / none | 0.54 | 0.64 | I -16.11% | 4.46% | 4.04% | 50 | I -19.36% | -8.53 | -20.70 | | TPCH(2) | TPCH-Q9 | parquet / none / none | 0.89 | 1.09 | I -18.70% | 2.77% | 4.19% | 50 | I -23.58% | -8.53 | -27.78 | | TPCH(2) | TPCH-Q4 | parquet / none / none | 0.26 | 0.33 | I -21.04% | 5.40% | 7.23% | 50 | I -21.83% | -8.52 | -17.73 | | TPCH(2) | TPCH-Q18 | parquet / none / none | 0.78 | 0.99 | I -20.71% | 3.54% | 2.81% | 50 | I -25.93% | -8.53 | -36.85 | | TPCH(2) | TPCH-Q21 | parquet / none / none | 1.12 | 1.51 | I -25.42% | 3.41% | 1.82% | 50 | I -35.34% | -8.53 | -57.38 | | TPCH(2) | TPCH-Q10 | parquet / none / none | 0.57 | 0.83 | I -31.65% | 4.27% | 2.58% | 50 | I -44.18% | -8.53 | -57.40 | | TPCH(2) | TPCH-Q22 | parquet / none / none | 0.21 | 0.30 | I -30.14% | 9.82% | 8.97% | 50 | I -46.17% | -8.42 | -18.88 | | TPCH(2) | TPCH-Q8 | parquet / none / none | 0.61 | 0.88 | I -31.23% | 4.44% | 2.36% | 50 | I -45.31% | -8.53 | -57.16 | | TPCH(2) | TPCH-Q20 | parquet / none / none | 0.41 | 0.62 | I -33.39% | 5.37% | 1.26% | 50 | I -46.86% | -8.53 | -62.30 | | TPCH(2) | TPCH-Q7 | parquet / none / none | 0.46 | 0.69 | I -33.15% | 6.90% | 4.07% | 50 | I -51.36% | -8.53 | -38.08 | | TPCH(2) | TPCH-Q3 | parquet / none / none | 0.38 | 0.57 | I -33.64% | 6.04% | 2.18% | 50 | I -55.39% | -8.53 | -52.13 | | TPCH(2) | TPCH-Q15 | parquet / none / none | 0.35 | 0.56 | I -36.63% | 6.50% | 3.59% | 50 | I -55.03% | -8.53 | -47.42 | | TPCH(2) | TPCH-Q16 | parquet / none / none | 0.27 | 0.44 | I -38.50% | 4.47% | 5.37% | 50 | I -57.73% | -8.53 | -45.15 | | TPCH(2) | TPCH-Q2 | parquet / none / none | 0.31 | 0.52 | I -39.59% | 9.85% | 4.35% | 50 | I -62.31% | -8.53 | -37.98 | | TPCH(2) | TPCH-Q11 | parquet / none / none | 0.23 | 0.40 | I -42.42% | 7.91% | 6.45% | 50 | I -70.18% | -8.53 | -37.99 | | TPCH(2) | TPCH-Q5 | parquet / none / none | 0.47 | 0.84 | I -43.91% | 7.87% | 2.71% | 50 | I -75.82% | -8.53 | -59.96 | | TPCH(2) | TPCH-Q19 | parquet / none / none | 0.45 | 1.09 | I -58.27% | 6.40% | 1.27% | 50 | I -136.02% | -8.53 | -139.34 | +----------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+---------+ (R) Regression: TPCH(2) TPCH-Q1 [parquet / none / none] (0.55s -> 0.60s [+7.87%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | 01:AGGREGATE | 95.61% | 470.34ms | 196.14ms | +139.80% | 3.54% | 568.00ms | 240.00ms | +136.66% | 3 | 3 | 12 | 6 | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCH(2) TPCH-Q12 [parquet / none / none] (0.39s -> 0.35s [-8.23%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 01:SCAN HDFS | 42.38% | 218.26ms | 162.23ms | +34.53% | 4.83% | 264.00ms | 208.00ms | +26.92% | 3 | 3 | 61.98K | 641.32K | | 00:SCAN HDFS | 54.04% | 278.29ms | 279.84ms | -0.56% | 5.10% | 308.00ms | 332.01ms | -7.23% | 3 | 3 | 58.23K | 3.00M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCH(2) TPCH-Q17 [parquet / none / none] (0.44s -> 0.38s [-12.44%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 34.31% | 178.07ms | 122.09ms | +45.85% | 6.91% | 236.00ms | 164.00ms | +43.91% | 3 | 3 | 11.98K | 12.00M | | 02:SCAN HDFS | 60.21% | 312.52ms | 306.74ms | +1.88% | 6.47% | 372.00ms | 367.99ms | +1.09% | 3 | 3 | 11.98K | 12.00M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCH(2) TPCH-Q14 [parquet / none / none] (0.37s -> 0.30s [-18.10%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 00:SCAN HDFS | 73.41% | 222.83ms | 259.19ms | -14.03% | 4.73% | 276.00ms | 320.01ms | -13.75% | 3 | 3 | 150.48K | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q13 [parquet / none / none] (0.64s -> 0.54s [-16.11%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 03:AGGREGATE | 12.83% | 77.52ms | 42.07ms | +84.28% | * 11.72% * | 116.00ms | 92.00ms | +26.09% | 3 | 3 | 300.00K | 300.00K | | 02:HASH JOIN | 12.66% | 76.52ms | 46.89ms | +63.20% | * 13.76% * | 128.00ms | 88.00ms | +45.45% | 3 | 3 | 3.07M | 300.00K | | F00:EXCHANGE SENDER | 45.49% | 274.94ms | 259.81ms | +5.82% | 4.19% | 364.00ms | 348.01ms | +4.60% | 3 | 3 | -1 | -1 | | 01:SCAN HDFS | 22.01% | 133.04ms | 209.47ms | -36.49% | * 13.30% * | 216.00ms | 308.01ms | -29.87% | 3 | 3 | 2.97M | 300.00K | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q9 [parquet / none / none] (1.09s -> 0.89s [-18.70%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 09:HASH JOIN | 4.37% | 75.84ms | 22.53ms | +236.60% | * 22.60% * | 192.00ms | 328.00ms | -41.46% | 3 | 3 | 651.85K | 1.16M | | F05:EXCHANGE SENDER | 4.84% | 84.04ms | 75.96ms | +10.64% | * 19.54% * | 168.00ms | 116.00ms | +44.83% | 2 | 2 | -1 | -1 | | 01:SCAN HDFS | 24.39% | 423.35ms | 613.14ms | -30.95% | 5.10% | 472.01ms | 648.00ms | -27.16% | 1 | 1 | 20.00K | 20.00K | | F02:EXCHANGE SENDER | 11.46% | 198.91ms | 138.72ms | +43.39% | 7.99% | 308.00ms | 180.00ms | +71.11% | 3 | 3 | -1 | -1 | | F00:EXCHANGE SENDER | 4.96% | 86.07ms | 79.37ms | +8.43% | 9.87% | 128.00ms | 140.00ms | -8.57% | 3 | 3 | -1 | -1 | | 00:SCAN HDFS | 26.65% | 462.54ms | 689.39ms | -32.91% | 4.95% | 508.01ms | 728.00ms | -30.22% | 1 | 1 | 21.73K | 40.00K | | 02:SCAN HDFS | 10.92% | 189.53ms | 164.74ms | +15.05% | * 16.03% * | 280.00ms | 448.00ms | -37.50% | 3 | 3 | 651.85K | 12.00M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q4 [parquet / none / none] (0.33s -> 0.26s [-21.04%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 63.65% | 171.57ms | 207.70ms | -17.40% | 9.04% | 232.00ms | 268.00ms | -13.43% | 3 | 3 | 291.96K | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q18 [parquet / none / none] (0.99s -> 0.78s [-20.71%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | 14:AGGREGATE | 14.40% | 304.57ms | 123.48ms | +146.66% | 5.64% | 364.00ms | 152.00ms | +139.48% | 3 | 3 | 117 | 308.78K | | F04:EXCHANGE SENDER | 5.30% | 112.00ms | 104.60ms | +7.08% | 8.77% | 156.00ms | 144.00ms | +8.34% | 3 | 3 | -1 | -1 | | 04:AGGREGATE | 10.89% | 230.37ms | 162.85ms | +41.46% | 5.64% | 308.00ms | 248.00ms | +24.20% | 3 | 3 | 3.00M | 3.09M | | 01:SCAN HDFS | 29.14% | 616.25ms | 760.69ms | -18.99% | 2.80% | 672.01ms | 831.99ms | -19.23% | 3 | 3 | 117 | 3.00M | | 02:SCAN HDFS | 33.13% | 700.47ms | 835.36ms | -16.15% | 2.98% | 760.01ms | 903.99ms | -15.93% | 3 | 3 | 819 | 12.00M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCH(2) TPCH-Q21 [parquet / none / none] (1.51s -> 1.12s [-25.42%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 10:HASH JOIN | 6.96% | 125.42ms | 73.60ms | +70.39% | 9.96% | 180.00ms | 124.00ms | +45.16% | 3 | 3 | 8.15K | 15.54K | | 00:SCAN HDFS | 4.06% | 73.23ms | 568.81ms | -87.13% | * 21.60% * | 108.00ms | 604.00ms | -82.12% | 1 | 1 | 820 | 20.00K | | F03:EXCHANGE SENDER | 4.05% | 73.01ms | 64.24ms | +13.64% | 7.62% | 108.00ms | 108.00ms | +0.00% | 3 | 3 | -1 | -1 | | 01:SCAN HDFS | 16.99% | 306.13ms | 670.96ms | -54.37% | 5.94% | 388.00ms | 748.00ms | -48.13% | 3 | 3 | 168.17K | 1.20M | | 04:SCAN HDFS | 24.03% | 433.18ms | 826.52ms | -47.59% | 5.38% | 504.01ms | 887.99ms | -43.24% | 3 | 3 | 704.38K | 12.00M | | F00:EXCHANGE SENDER | 31.01% | 558.86ms | 525.60ms | +6.33% | 2.98% | 672.01ms | 640.00ms | +5.00% | 3 | 3 | -1 | -1 | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q10 [parquet / none / none] (0.83s -> 0.57s [-31.65%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | F03:EXCHANGE SENDER | 3.05% | 22.94ms | 21.99ms | +4.33% | * 24.15% * | 116.00ms | 32.00ms | +262.50% | 3 | 3 | -1 | -1 | | F02:EXCHANGE SENDER | 25.51% | 191.92ms | 160.25ms | +19.76% | 7.27% | 216.00ms | 168.00ms | +28.57% | 1 | 1 | -1 | -1 | | 01:SCAN HDFS | 38.54% | 289.88ms | 535.63ms | -45.88% | 5.28% | 324.00ms | 612.01ms | -47.06% | 3 | 3 | 114.54K | 300.00K | | 02:SCAN HDFS | 16.03% | 120.55ms | 107.59ms | +12.04% | 6.45% | 168.00ms | 152.00ms | +10.53% | 3 | 3 | 229.95K | 4.00M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q22 [parquet / none / none] (0.30s -> 0.21s [-30.14%]) +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 01:SCAN HDFS | 30.43% | 80.65ms | 25.14ms | +220.78% | * 13.93% * | 124.00ms | 32.00ms | +287.51% | 1 | 1 | 76.55K | 30.00K | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCH(2) TPCH-Q8 [parquet / none / none] (0.88s -> 0.61s [-31.23%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 04:SCAN HDFS | 7.32% | 86.86ms | 459.84ms | -81.11% | * 21.66% * | 136.00ms | 516.00ms | -73.64% | 1 | 1 | 59.76K | 300.00K | | 02:SCAN HDFS | 27.90% | 331.13ms | 484.54ms | -31.66% | 8.91% | 400.01ms | 560.00ms | -28.57% | 3 | 3 | 85.19K | 12.00M | | 03:SCAN HDFS | 41.47% | 492.22ms | 662.75ms | -25.73% | 3.98% | 556.01ms | 740.00ms | -24.86% | 3 | 3 | 5.03K | 300.00K | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCH(2) TPCH-Q20 [parquet / none / none] (0.62s -> 0.41s [-33.39%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | 04:SCAN HDFS | 65.99% | 293.47ms | 397.11ms | -26.10% | 6.32% | 352.00ms | 456.00ms | -22.81% | 3 | 3 | 818 | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCH(2) TPCH-Q7 [parquet / none / none] (0.69s -> 0.46s [-33.15%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 02:SCAN HDFS | 19.66% | 124.98ms | 394.67ms | -68.33% | 5.45% | 168.00ms | 452.00ms | -62.83% | 3 | 3 | 242.45K | 3.00M | | 01:SCAN HDFS | 53.30% | 338.78ms | 502.75ms | -32.61% | 5.96% | 432.01ms | 568.00ms | -23.94% | 3 | 3 | 23.26K | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q3 [parquet / none / none] (0.57s -> 0.38s [-33.64%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 03:HASH JOIN | 20.56% | 76.16ms | 34.48ms | +120.92% | 9.70% | 104.00ms | 52.00ms | +100.00% | 3 | 3 | 61.42K | 116.57K | | 01:SCAN HDFS | 22.41% | 83.05ms | 307.97ms | -73.03% | 6.82% | 112.00ms | 356.00ms | -68.54% | 3 | 3 | 294.43K | 300.00K | | 02:SCAN HDFS | 43.23% | 160.17ms | 119.21ms | +34.36% | 5.22% | 204.00ms | 152.00ms | +34.21% | 3 | 3 | 62.22K | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q15 [parquet / none / none] (0.56s -> 0.35s [-36.63%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 03:SCAN HDFS | 35.56% | 181.09ms | 106.09ms | +70.69% | 8.14% | 236.00ms | 160.00ms | +47.50% | 3 | 3 | 451.99K | 1.20M | | 01:SCAN HDFS | 44.49% | 226.59ms | 359.53ms | -36.98% | 7.23% | 296.00ms | 423.99ms | -30.19% | 3 | 3 | 451.99K | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q16 [parquet / none / none] (0.44s -> 0.27s [-38.50%]) +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCH(2) TPCH-Q2 [parquet / none / none] (0.52s -> 0.31s [-39.59%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | 01:SCAN HDFS | 10.56% | 58.29ms | 302.61ms | -80.74% | * 26.63% * | 100.00ms | 348.00ms | -71.26% | 1 | 1 | 3.97K | 20.00K | | 02:SCAN HDFS | 19.02% | 105.02ms | 224.24ms | -53.17% | * 16.54% * | 156.00ms | 284.00ms | -45.07% | 2 | 2 | 1.26K | 1.60M | | 05:SCAN HDFS | 24.78% | 136.82ms | 57.63ms | +137.40% | * 13.25% * | 188.00ms | 128.00ms | +46.88% | 2 | 2 | 1.26K | 1.60M | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCH(2) TPCH-Q11 [parquet / none / none] (0.40s -> 0.23s [-42.42%]) +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 20.10% | 52.65ms | 28.37ms | +85.61% | * 21.71% * | 100.00ms | 44.00ms | +127.27% | 2 | 2 | 64.32K | 1.60M | +--------------+------------+---------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCH(2) TPCH-Q5 [parquet / none / none] (0.84s -> 0.47s [-43.91%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 01:SCAN HDFS | 22.49% | 120.79ms | 561.85ms | -78.50% | 6.11% | 160.00ms | 616.00ms | -74.03% | 3 | 3 | 91.37K | 300.00K | | 02:SCAN HDFS | 40.65% | 218.32ms | 144.35ms | +51.24% | 7.33% | 304.00ms | 176.00ms | +72.73% | 3 | 3 | 73.42K | 12.00M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCH(2) TPCH-Q19 [parquet / none / none] (1.09s -> 0.45s [-58.27%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | 00:SCAN HDFS | 78.16% | 241.25ms | 127.78ms | +88.80% | * 10.18% * | 336.00ms | 152.00ms | +121.06% | 3 | 3 | 583 | 395.11K | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ Significant perf change detected.