Report Generated on 2023-08-30 Run Description: "e2a52907c836544b0ca68dc6806d3166e71b4474 vs e4156b47a7ab92f21faf179e6fa4a90bc8981e6e" Cluster Name: UNKNOWN Lab Run Info: UNKNOWN Impala Version: impalad version 4.3.0-SNAPSHOT RELEASE (2023-08-30) Baseline Impala Version: impalad version 4.3.0-SNAPSHOT RELEASE (2023-08-30) +----------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +----------+-----------------------+---------+------------+------------+----------------+ | TPCH(2) | parquet / none / none | 0.47 | -30.34% | 0.42 | -30.16% | +----------+-----------------------+---------+------------+------------+----------------+ +----------+----------+-----------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+---------+ | 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.61 | 0.58 | +4.47% | 5.05% | 3.31% | 50 | +6.44% | 3.46 | 5.08 | | TPCH(2) | TPCH-Q6 | parquet / none / none | 0.21 | 0.21 | -0.59% | 1.20% | 3.60% | 50 | -0.04% | -1.07 | -1.10 | | TPCH(2) | TPCH-Q17 | parquet / none / none | 0.39 | 0.44 | I -11.29% | 6.14% | 5.67% | 50 | I -12.40% | -8.18 | -10.15 | | TPCH(2) | TPCH-Q12 | parquet / none / none | 0.35 | 0.40 | I -13.13% | 8.06% | 5.89% | 50 | I -14.09% | -7.10 | -10.15 | | TPCH(2) | TPCH-Q13 | parquet / none / none | 0.54 | 0.66 | I -17.56% | 4.64% | 4.37% | 50 | I -19.10% | -8.53 | -21.38 | | TPCH(2) | TPCH-Q9 | parquet / none / none | 0.92 | 1.12 | I -17.66% | 2.63% | 2.46% | 50 | I -21.70% | -8.53 | -38.13 | | TPCH(2) | TPCH-Q4 | parquet / none / none | 0.27 | 0.34 | I -21.33% | 6.90% | 7.31% | 50 | I -22.58% | -8.11 | -16.56 | | TPCH(2) | TPCH-Q14 | parquet / none / none | 0.31 | 0.40 | I -22.59% | 4.88% | 6.00% | 50 | I -32.29% | -8.44 | -22.52 | | TPCH(2) | TPCH-Q18 | parquet / none / none | 0.79 | 1.03 | I -23.46% | 3.81% | 2.70% | 50 | I -32.46% | -8.53 | -41.72 | | TPCH(2) | TPCH-Q21 | parquet / none / none | 1.13 | 1.55 | I -27.51% | 2.96% | 1.82% | 50 | I -35.94% | -8.53 | -69.17 | | TPCH(2) | TPCH-Q8 | parquet / none / none | 0.62 | 0.90 | I -30.77% | 5.61% | 2.87% | 50 | I -46.24% | -8.53 | -45.05 | | TPCH(2) | TPCH-Q22 | parquet / none / none | 0.21 | 0.31 | I -32.01% | 6.10% | 3.95% | 50 | I -46.27% | -8.53 | -39.51 | | TPCH(2) | TPCH-Q3 | parquet / none / none | 0.39 | 0.58 | I -31.90% | 6.06% | 3.72% | 50 | I -48.20% | -8.53 | -40.62 | | TPCH(2) | TPCH-Q10 | parquet / none / none | 0.58 | 0.87 | I -33.56% | 4.63% | 2.29% | 50 | I -51.30% | -8.53 | -61.87 | | TPCH(2) | TPCH-Q7 | parquet / none / none | 0.47 | 0.71 | I -34.57% | 7.03% | 3.91% | 50 | I -53.30% | -8.53 | -40.49 | | TPCH(2) | TPCH-Q20 | parquet / none / none | 0.41 | 0.65 | I -36.39% | 5.52% | 4.00% | 50 | I -58.06% | -8.53 | -48.38 | | TPCH(2) | TPCH-Q15 | parquet / none / none | 0.35 | 0.57 | I -38.60% | 7.10% | 2.58% | 50 | I -56.76% | -8.53 | -53.91 | | TPCH(2) | TPCH-Q16 | parquet / none / none | 0.27 | 0.47 | I -41.47% | 3.74% | 3.52% | 50 | I -73.81% | -8.53 | -70.68 | | TPCH(2) | TPCH-Q2 | parquet / none / none | 0.31 | 0.55 | I -43.05% | * 16.10% * | 4.53% | 50 | I -82.15% | -8.53 | -29.77 | | TPCH(2) | TPCH-Q5 | parquet / none / none | 0.49 | 0.87 | I -44.26% | 4.76% | 1.69% | 50 | I -83.26% | -8.53 | -99.50 | | TPCH(2) | TPCH-Q11 | parquet / none / none | 0.22 | 0.42 | I -48.26% | * 10.69% * | 2.41% | 50 | I -88.33% | -8.53 | -56.58 | | TPCH(2) | TPCH-Q19 | parquet / none / none | 0.46 | 1.14 | I -60.01% | 8.16% | 1.06% | 50 | I -140.99% | -8.53 | -123.65 | +----------+----------+-----------------------+--------+-------------+------------+------------+----------------+-------+----------------+---------+---------+ (I) Improvement: TPCH(2) TPCH-Q17 [parquet / none / none] (0.44s -> 0.39s [-11.29%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 00:SCAN HDFS | 34.47% | 185.55ms | 127.40ms | +45.64% | 6.93% | 236.00ms | 172.00ms | +37.21% | 3 | 3 | 11.98K | 12.00M | | 02:SCAN HDFS | 59.81% | 321.95ms | 317.46ms | +1.41% | 4.63% | 363.99ms | 379.99ms | -4.21% | 3 | 3 | 11.98K | 12.00M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCH(2) TPCH-Q12 [parquet / none / none] (0.40s -> 0.35s [-13.13%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 01:SCAN HDFS | 42.39% | 217.96ms | 166.15ms | +31.18% | 4.84% | 268.00ms | 208.00ms | +28.85% | 3 | 3 | 61.98K | 641.32K | | 00:SCAN HDFS | 53.83% | 276.73ms | 288.13ms | -3.96% | 6.11% | 324.00ms | 324.00ms | +0.00% | 3 | 3 | 58.23K | 3.00M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCH(2) TPCH-Q13 [parquet / none / none] (0.66s -> 0.54s [-17.56%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 03:AGGREGATE | 15.41% | 99.56ms | 63.84ms | +55.97% | 9.83% | 144.00ms | 96.00ms | +50.00% | 3 | 3 | 300.00K | 300.00K | | 02:HASH JOIN | 14.46% | 93.44ms | 69.99ms | +33.51% | * 12.55% * | 140.00ms | 108.00ms | +29.63% | 3 | 3 | 3.07M | 300.00K | | F00:EXCHANGE SENDER | 42.93% | 277.41ms | 264.49ms | +4.89% | 3.44% | 355.99ms | 343.99ms | +3.49% | 3 | 3 | -1 | -1 | | 01:SCAN HDFS | 20.80% | 134.39ms | 223.48ms | -39.86% | * 13.48% * | 228.00ms | 367.99ms | -38.04% | 3 | 3 | 2.97M | 300.00K | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q9 [parquet / none / none] (1.12s -> 0.92s [-17.66%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 09:HASH JOIN | 3.89% | 70.99ms | 21.03ms | +237.52% | * 27.83% * | 176.00ms | 84.00ms | +109.52% | 3 | 3 | 651.85K | 1.16M | | F05:EXCHANGE SENDER | 4.46% | 81.55ms | 76.69ms | +6.33% | * 17.58% * | 148.00ms | 108.00ms | +37.04% | 2 | 2 | -1 | -1 | | 01:SCAN HDFS | 24.67% | 450.85ms | 629.38ms | -28.37% | 3.92% | 495.99ms | 679.99ms | -27.06% | 1 | 1 | 20.00K | 20.00K | | F02:EXCHANGE SENDER | 11.10% | 202.85ms | 139.13ms | +45.80% | 7.54% | 300.00ms | 192.00ms | +56.25% | 3 | 3 | -1 | -1 | | F00:EXCHANGE SENDER | 4.98% | 90.94ms | 84.95ms | +7.05% | * 10.08% * | 128.00ms | 128.00ms | +0.00% | 3 | 3 | -1 | -1 | | 00:SCAN HDFS | 27.18% | 496.73ms | 704.32ms | -29.47% | 4.27% | 543.99ms | 771.99ms | -29.53% | 1 | 1 | 21.73K | 40.00K | | 02:SCAN HDFS | 10.63% | 194.17ms | 170.07ms | +14.18% | * 12.18% * | 288.00ms | 244.00ms | +18.03% | 3 | 3 | 651.85K | 12.00M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q4 [parquet / none / none] (0.34s -> 0.27s [-21.33%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 01:SCAN HDFS | 63.89% | 173.25ms | 215.67ms | -19.67% | 7.13% | 228.00ms | 268.00ms | -14.93% | 3 | 3 | 291.96K | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q14 [parquet / none / none] (0.40s -> 0.31s [-22.59%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 00:SCAN HDFS | 73.16% | 223.07ms | 272.76ms | -18.22% | 4.92% | 284.00ms | 347.99ms | -18.39% | 3 | 3 | 150.48K | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q18 [parquet / none / none] (1.03s -> 0.79s [-23.46%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | 14:AGGREGATE | 14.44% | 308.51ms | 126.64ms | +143.62% | 5.13% | 355.99ms | 168.00ms | +111.90% | 3 | 3 | 117 | 308.78K | | F04:EXCHANGE SENDER | 5.48% | 117.14ms | 111.62ms | +4.95% | 9.07% | 172.00ms | 144.00ms | +19.44% | 3 | 3 | -1 | -1 | | 04:AGGREGATE | 10.66% | 227.89ms | 172.62ms | +32.01% | 7.41% | 312.00ms | 232.00ms | +34.48% | 3 | 3 | 3.00M | 3.09M | | 01:SCAN HDFS | 28.87% | 617.05ms | 788.70ms | -21.76% | 3.10% | 699.99ms | 883.99ms | -20.81% | 3 | 3 | 117 | 3.00M | | 02:SCAN HDFS | 32.92% | 703.64ms | 868.80ms | -19.01% | 3.34% | 763.99ms | 963.99ms | -20.75% | 3 | 3 | 819 | 12.00M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCH(2) TPCH-Q21 [parquet / none / none] (1.55s -> 1.13s [-27.51%]) +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ | 10:HASH JOIN | 7.24% | 133.44ms | 82.12ms | +62.49% | * 10.46% * | 192.00ms | 128.00ms | +50.00% | 3 | 3 | 8.15K | 15.54K | | F03:EXCHANGE SENDER | 4.26% | 78.48ms | 65.82ms | +19.22% | * 11.22% * | 120.00ms | 104.00ms | +15.38% | 3 | 3 | -1 | -1 | | 01:SCAN HDFS | 17.11% | 315.23ms | 698.11ms | -54.84% | 5.81% | 395.99ms | 751.99ms | -47.34% | 3 | 3 | 168.17K | 1.20M | | 04:SCAN HDFS | 23.71% | 436.95ms | 854.84ms | -48.89% | 5.60% | 527.99ms | 919.99ms | -42.61% | 3 | 3 | 704.38K | 12.00M | | F00:EXCHANGE SENDER | 30.41% | 560.35ms | 533.33ms | +5.07% | 3.04% | 651.99ms | 647.99ms | +0.62% | 3 | 3 | -1 | -1 | | 05:SCAN HDFS | 2.63% | 48.52ms | 36.38ms | +33.36% | * 19.08% * | 128.00ms | 84.00ms | +52.38% | 3 | 3 | 7.58M | 1.20M | +---------------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q8 [parquet / none / none] (0.90s -> 0.62s [-30.77%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ | 04:SCAN HDFS | 5.90% | 70.37ms | 478.85ms | -85.31% | * 23.51% * | 112.00ms | 523.99ms | -78.63% | 1 | 1 | 59.76K | 300.00K | | 02:SCAN HDFS | 29.31% | 349.52ms | 496.89ms | -29.66% | 6.56% | 443.99ms | 591.99ms | -25.00% | 3 | 3 | 85.19K | 12.00M | | 03:SCAN HDFS | 42.22% | 503.48ms | 680.07ms | -25.97% | 5.24% | 615.99ms | 755.99ms | -18.52% | 3 | 3 | 5.03K | 300.00K | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCH(2) TPCH-Q22 [parquet / none / none] (0.31s -> 0.21s [-32.01%]) +--------------+------------+---------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+---------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 05:AGGREGATE | 26.96% | 71.26ms | 45.66ms | +56.08% | 7.94% | 104.00ms | 76.00ms | +36.84% | 3 | 3 | 583.05K | 204.41K | +--------------+------------+---------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q3 [parquet / none / none] (0.58s -> 0.39s [-31.90%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 03:HASH JOIN | 21.80% | 83.35ms | 37.01ms | +125.22% | 8.59% | 108.00ms | 56.00ms | +92.86% | 3 | 3 | 61.42K | 116.57K | | 01:SCAN HDFS | 22.74% | 86.94ms | 322.83ms | -73.07% | 8.11% | 144.00ms | 383.99ms | -62.50% | 3 | 3 | 294.43K | 300.00K | | 02:SCAN HDFS | 42.53% | 162.56ms | 120.65ms | +34.73% | 5.52% | 208.00ms | 160.00ms | +30.00% | 3 | 3 | 62.22K | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q10 [parquet / none / none] (0.87s -> 0.58s [-33.56%]) +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | F02:EXCHANGE SENDER | 25.77% | 196.00ms | 163.67ms | +19.75% | 7.42% | 220.00ms | 188.00ms | +17.02% | 1 | 1 | -1 | -1 | | 01:SCAN HDFS | 38.46% | 292.49ms | 561.57ms | -47.92% | 5.45% | 348.00ms | 647.99ms | -46.30% | 3 | 3 | 114.54K | 300.00K | | 02:SCAN HDFS | 16.44% | 125.03ms | 113.66ms | +10.01% | 8.95% | 196.00ms | 148.00ms | +32.43% | 3 | 3 | 229.95K | 4.00M | +---------------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q7 [parquet / none / none] (0.71s -> 0.47s [-34.57%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 02:SCAN HDFS | 18.90% | 119.02ms | 409.82ms | -70.96% | 8.58% | 168.00ms | 479.99ms | -65.00% | 3 | 3 | 242.45K | 3.00M | | 01:SCAN HDFS | 55.34% | 348.57ms | 523.64ms | -33.43% | 6.09% | 431.99ms | 595.99ms | -27.52% | 3 | 3 | 23.26K | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q20 [parquet / none / none] (0.65s -> 0.41s [-36.39%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ | 04:SCAN HDFS | 66.45% | 292.54ms | 415.18ms | -29.54% | 6.76% | 348.00ms | 479.99ms | -27.50% | 3 | 3 | 818 | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCH(2) TPCH-Q15 [parquet / none / none] (0.57s -> 0.35s [-38.60%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ | 03:SCAN HDFS | 34.99% | 181.30ms | 103.78ms | +74.70% | 7.90% | 236.00ms | 148.00ms | +59.46% | 3 | 3 | 451.99K | 1.20M | | 01:SCAN HDFS | 43.07% | 223.18ms | 373.55ms | -40.25% | 7.57% | 288.00ms | 419.99ms | -31.43% | 3 | 3 | 451.99K | 1.20M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+---------+-----------+ (I) Improvement: TPCH(2) TPCH-Q16 [parquet / none / none] (0.47s -> 0.27s [-41.47%]) +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ | 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.55s -> 0.31s [-43.05%]) +--------------+------------+----------+----------+------------+-------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-------------+----------+----------+------------+--------+-------+-------+-----------+ | 02:SCAN HDFS | 22.53% | 91.55ms | 242.16ms | -62.19% | * 31.90% * | 252.00ms | 304.00ms | -17.11% | 2 | 2 | 1.26K | 1.60M | | 06:SCAN HDFS | 5.12% | 20.82ms | 336.97ms | -93.82% | * 125.44% * | 144.00ms | 387.99ms | -62.89% | 1 | 1 | 3.97K | 20.00K | | 05:SCAN HDFS | 29.84% | 121.26ms | 72.20ms | +67.95% | * 31.70% * | 292.00ms | 148.00ms | +97.30% | 2 | 2 | 1.26K | 1.60M | +--------------+------------+----------+----------+------------+-------------+----------+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCH(2) TPCH-Q5 [parquet / none / none] (0.87s -> 0.49s [-44.26%]) +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ | 01:SCAN HDFS | 22.40% | 122.94ms | 580.10ms | -78.81% | 6.09% | 164.00ms | 631.99ms | -74.05% | 3 | 3 | 91.37K | 300.00K | | 02:SCAN HDFS | 41.79% | 229.36ms | 155.24ms | +47.75% | 6.19% | 296.00ms | 216.00ms | +37.04% | 3 | 3 | 73.42K | 12.00M | +--------------+------------+----------+----------+------------+-----------+----------+----------+------------+--------+-------+--------+-----------+ (I) Improvement: TPCH(2) TPCH-Q11 [parquet / none / none] (0.42s -> 0.22s [-48.26%]) +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ +----------+------------+-----+----------+------------+-----------+-----+----------+------------+--------+-------+-------+-----------+ (I) Improvement: TPCH(2) TPCH-Q19 [parquet / none / none] (1.14s -> 0.46s [-60.01%]) +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | Operator | % of Query | Avg | Base Avg | Delta(Avg) | StdDev(%) | Max | Base Max | Delta(Max) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ | 00:SCAN HDFS | 78.41% | 241.60ms | 129.71ms | +86.26% | * 11.02% * | 336.00ms | 160.00ms | +110.00% | 3 | 3 | 583 | 395.11K | +--------------+------------+----------+----------+------------+------------+----------+----------+------------+--------+-------+-------+-----------+ (V) Significant Variability: TPCH(2) TPCH-Q2 [parquet / none / none] (4.53% -> 16.10%) +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Inst | #Rows | Est #Rows | +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ | 04:SCAN HDFS | 2.51% | 71.74% | 63.43% | +13.10% | 1 | 1 | 1 | 1 | | 03:SCAN HDFS | 6.91% | 36.34% | 8.09% | +349.17% | 1 | 1 | 5 | 25 | | 01:SCAN HDFS | 9.72% | 27.72% | 7.55% | +267.06% | 1 | 1 | 3.97K | 20.00K | | 00:SCAN HDFS | 8.22% | 20.90% | 30.61% | -31.74% | 1 | 1 | 1.58K | 2.53K | | 02:SCAN HDFS | 22.53% | 31.90% | 10.03% | +217.92% | 2 | 2 | 1.26K | 1.60M | | 07:SCAN HDFS | 2.79% | 120.09% | 5.85% | +1953.00% | 1 | 1 | 5 | 25 | | 06:SCAN HDFS | 5.12% | 125.44% | 5.42% | +2212.65% | 1 | 1 | 3.97K | 20.00K | | 05:SCAN HDFS | 29.84% | 31.70% | 37.98% | -16.54% | 2 | 2 | 1.26K | 1.60M | +--------------+------------+-----------+----------------+------------------+--------+-------+-------+-----------+ (V) Significant Variability: TPCH(2) TPCH-Q11 [parquet / none / none] (2.41% -> 10.69%) +---------------------+------------+-----------+----------------+------------------+--------+-------+--------+-----------+ | Operator | % of Query | StdDev(%) | Base StdDev(%) | Delta(StdDev(%)) | #Hosts | #Inst | #Rows | Est #Rows | +---------------------+------------+-----------+----------------+------------------+--------+-------+--------+-----------+ | 12:NESTED LOOP JOIN | 6.07% | 27.25% | 93.43% | -70.83% | 2 | 2 | 10 | 63.99K | | 11:AGGREGATE | 5.20% | 32.84% | 210.82% | -84.42% | 2 | 2 | 2 | 1 | | 08:SCAN HDFS | 3.31% | 71.30% | 244.95% | -70.89% | 1 | 1 | 1 | 1 | | 09:HASH JOIN | 2.25% | 69.14% | 98.90% | -30.09% | 2 | 2 | 64.32K | 1.60M | | 07:SCAN HDFS | 9.67% | 26.34% | 6.07% | +334.10% | 1 | 1 | 804 | 20.00K | | 06:SCAN HDFS | 22.38% | 15.20% | 12.71% | +19.59% | 2 | 2 | 64.32K | 1.60M | | 17:AGGREGATE | 3.25% | 38.89% | 74.32% | -47.67% | 2 | 2 | 60.55K | 63.99K | | 05:AGGREGATE | 8.03% | 45.72% | 82.32% | -44.46% | 2 | 2 | 60.55K | 63.99K | | 02:SCAN HDFS | 2.02% | 96.76% | 226.38% | -57.26% | 1 | 1 | 1 | 1 | | 03:HASH JOIN | 2.51% | 62.39% | 120.00% | -48.01% | 2 | 2 | 64.32K | 1.60M | | 01:SCAN HDFS | 7.19% | 60.86% | 4.62% | +1216.46% | 1 | 1 | 804 | 20.00K | | 00:SCAN HDFS | 21.81% | 20.87% | 14.82% | +40.88% | 2 | 2 | 64.32K | 1.60M | +---------------------+------------+-----------+----------------+------------------+--------+-------+--------+-----------+ Significant perf change detected.