Thomas Tauber-Marshall has posted comments on this change. Change subject: IMPALA-2805: Order filters based on selectivity and cost ......................................................................
Patch Set 6: Results for tpch from the Jenkins run, updated to a more recent baseline, per Tim's suggestion: Report Generated on 2016-04-07 Cluster Name: UNKNOWN Lab Run Info: UNKNOWN Impala Version: impalad version 2.6.0-cdh5-INTERNAL RELEASE () Baseline Impala Version: impalad version 2.6.0-cdh5-INTERNAL RELEASE (2016-04-06) +------------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +------------+-----------------------+---------+------------+------------+----------------+ | TPCH(_300) | parquet / none / none | 39.15 | -0.38% | 22.35 | -0.64% | +------------+-----------------------+---------+------------+------------+----------------+ +------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | TPCH(_300) | TPCH-Q2 | parquet / none / none | 9.64 | 8.72 | +10.65% | 0.76% | 0.74% | 1 | 3 | | TPCH(_300) | TPCH-Q16 | parquet / none / none | 10.41 | 9.76 | +6.69% | 0.86% | 0.58% | 1 | 3 | | TPCH(_300) | TPCH-Q11 | parquet / none / none | 6.82 | 6.58 | +3.65% | 3.65% | 1.53% | 1 | 3 | | TPCH(_300) | TPCH-Q17 | parquet / none / none | 128.74 | 124.53 | +3.39% | 1.07% | 4.26% | 1 | 3 | | TPCH(_300) | TPCH-Q12 | parquet / none / none | 16.70 | 16.38 | +1.95% | 5.60% | 4.59% | 1 | 3 | | TPCH(_300) | TPCH-Q19 | parquet / none / none | 162.30 | 160.06 | +1.40% | 1.46% | 4.56% | 1 | 3 | | TPCH(_300) | TPCH-Q8 | parquet / none / none | 9.06 | 8.95 | +1.28% | 1.22% | 2.20% | 1 | 3 | | TPCH(_300) | TPCH-Q15 | parquet / none / none | 6.15 | 6.08 | +1.16% | 4.06% | 0.44% | 1 | 3 | | TPCH(_300) | TPCH-Q20 | parquet / none / none | 16.19 | 16.01 | +1.11% | 0.20% | 0.09% | 1 | 3 | | TPCH(_300) | TPCH-Q4 | parquet / none / none | 33.84 | 33.84 | +0.02% | 0.81% | 1.39% | 1 | 3 | | TPCH(_300) | TPCH-Q18 | parquet / none / none | 86.02 | 86.03 | -0.02% | 0.98% | 0.83% | 1 | 3 | | TPCH(_300) | TPCH-Q1 | parquet / none / none | 19.20 | 19.24 | -0.22% | 0.85% | 0.82% | 1 | 3 | | TPCH(_300) | TPCH-Q9 | parquet / none / none | 40.39 | 40.63 | -0.59% | 2.35% | 1.81% | 1 | 3 | | TPCH(_300) | TPCH-Q10 | parquet / none / none | 20.94 | 21.08 | -0.63% | 0.27% | 0.13% | 1 | 3 | | TPCH(_300) | TPCH-Q21 | parquet / none / none | 117.72 | 119.52 | -1.51% | 0.66% | 0.67% | 1 | 3 | | TPCH(_300) | TPCH-Q22 | parquet / none / none | 8.09 | 8.26 | -2.14% | 1.33% | 4.04% | 1 | 3 | | TPCH(_300) | TPCH-Q5 | parquet / none / none | 48.16 | 49.31 | -2.34% | 2.25% | 1.37% | 1 | 3 | | TPCH(_300) | TPCH-Q14 | parquet / none / none | 6.16 | 6.44 | -4.34% | 1.66% | 2.01% | 1 | 3 | | TPCH(_300) | TPCH-Q3 | parquet / none / none | 32.68 | 34.31 | -4.74% | 0.26% | 3.31% | 1 | 3 | | TPCH(_300) | TPCH-Q7 | parquet / none / none | 45.87 | 48.96 | -6.31% | 2.92% | 1.29% | 1 | 3 | | TPCH(_300) | TPCH-Q13 | parquet / none / none | 32.72 | 35.98 | -9.04% | 0.06% | 2.35% | 1 | 3 | | TPCH(_300) | TPCH-Q6 | parquet / none / none | 3.44 | 3.87 | -11.08% | 0.66% | 2.61% | 1 | 3 | +------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ -- To view, visit http://gerrit.cloudera.org:8080/2598 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-MessageType: comment Gerrit-Change-Id: I02279a26fbc6308ac5eb819d78345fc010469034 Gerrit-PatchSet: 6 Gerrit-Project: Impala Gerrit-Branch: cdh5-trunk Gerrit-Owner: Thomas Tauber-Marshall <[email protected]> Gerrit-Reviewer: Alex Behm <[email protected]> Gerrit-Reviewer: Marcel Kornacker <[email protected]> Gerrit-Reviewer: Matthew Jacobs <[email protected]> Gerrit-Reviewer: Mostafa Mokhtar <[email protected]> Gerrit-Reviewer: Thomas Tauber-Marshall <[email protected]> Gerrit-Reviewer: Tim Armstrong <[email protected]> Gerrit-HasComments: No
