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_nested from the Jenkins run, updated to a more recent baseline: 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_NESTED(_300) | parquet / none / none | 43.43 | +0.78% | 18.68 | +0.75% | +-------------------+-----------------------+---------+------------+------------+----------------+ +-------------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +-------------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | TPCH_NESTED(_300) | TPCH-Q20 | parquet / none / none | 18.13 | 16.80 | +7.94% | 0.70% | 1.05% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q11 | parquet / none / none | 3.82 | 3.55 | +7.57% | 0.00% | 0.88% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q16 | parquet / none / none | 16.84 | 15.92 | +5.76% | 4.73% | 4.15% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q2 | parquet / none / none | 20.38 | 19.41 | +4.98% | 0.45% | 0.80% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q21 | parquet / none / none | 68.70 | 66.69 | +3.02% | 2.68% | 0.79% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q7 | parquet / none / none | 60.34 | 58.92 | +2.42% | 0.47% | 0.95% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q19 | parquet / none / none | 157.94 | 155.83 | +1.35% | 2.33% | 0.47% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q13 | parquet / none / none | 10.77 | 10.67 | +1.00% | 0.97% | 2.17% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q5 | parquet / none / none | 18.77 | 18.60 | +0.91% | 0.06% | 0.44% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q17 | parquet / none / none | 132.96 | 131.77 | +0.90% | 1.08% | 2.02% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q1 | parquet / none / none | 19.83 | 19.73 | +0.51% | 0.16% | 0.89% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q18 | parquet / none / none | 74.84 | 74.63 | +0.27% | 0.07% | 0.57% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q14 | parquet / none / none | 6.86 | 6.87 | -0.14% | 0.77% | 0.27% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q10 | parquet / none / none | 8.96 | 8.97 | -0.17% | 0.62% | 1.69% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q9 | parquet / none / none | 265.60 | 267.33 | -0.65% | 2.84% | 0.59% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q15 | parquet / none / none | 6.70 | 6.76 | -0.80% | 0.70% | 0.79% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q3 | parquet / none / none | 8.17 | 8.27 | -1.24% | 4.01% | 1.68% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q4 | parquet / none / none | 7.03 | 7.14 | -1.62% | 3.93% | 1.87% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q8 | parquet / none / none | 35.16 | 35.99 | -2.30% | 0.69% | 1.19% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q12 | parquet / none / none | 6.77 | 6.95 | -2.54% | 1.10% | 2.88% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q22 | parquet / none / none | 2.19 | 2.28 | -3.81% | 1.97% | 0.90% | 1 | 3 | | TPCH_NESTED(_300) | TPCH-Q6 | parquet / none / none | 4.59 | 4.86 | -5.44% | 1.18% | 1.54% | 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: Henry Robinson <[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
