Thomas Tauber-Marshall has posted comments on this change. Change subject: IMPALA-2805: Order conjuncts based on selectivity and cost ......................................................................
Patch Set 11: TPCH results from the latest changes: +------------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +------------+-----------------------+---------+------------+------------+----------------+ | TPCH(_300) | parquet / none / none | 39.80 | -1.66% | 22.62 | -1.72% | +------------+-----------------------+---------+------------+------------+----------------+ +------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +------------+----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | TPCH(_300) | TPCH-Q20 | parquet / none / none | 16.40 | 15.96 | +2.77% | 1.91% | 0.54% | 1 | 3 | | TPCH(_300) | TPCH-Q16 | parquet / none / none | 10.17 | 9.92 | +2.54% | 1.04% | 5.21% | 1 | 3 | | TPCH(_300) | TPCH-Q17 | parquet / none / none | 132.03 | 129.90 | +1.65% | 4.70% | 3.78% | 1 | 3 | | TPCH(_300) | TPCH-Q19 | parquet / none / none | 155.72 | 153.95 | +1.15% | 0.19% | 0.15% | 1 | 3 | | TPCH(_300) | TPCH-Q1 | parquet / none / none | 19.13 | 19.01 | +0.61% | 0.78% | 0.65% | 1 | 3 | | TPCH(_300) | TPCH-Q11 | parquet / none / none | 7.06 | 7.04 | +0.27% | 0.74% | 0.57% | 1 | 3 | | TPCH(_300) | TPCH-Q18 | parquet / none / none | 91.15 | 91.11 | +0.05% | 1.87% | 0.86% | 1 | 3 | | TPCH(_300) | TPCH-Q8 | parquet / none / none | 9.12 | 9.15 | -0.26% | 1.61% | 2.78% | 1 | 3 | | TPCH(_300) | TPCH-Q22 | parquet / none / none | 8.01 | 8.04 | -0.42% | 0.37% | 1.27% | 1 | 3 | | TPCH(_300) | TPCH-Q2 | parquet / none / none | 9.07 | 9.14 | -0.84% | 7.77% | 4.40% | 1 | 3 | | TPCH(_300) | TPCH-Q9 | parquet / none / none | 43.62 | 44.11 | -1.12% | 3.06% | 1.04% | 1 | 3 | | TPCH(_300) | TPCH-Q15 | parquet / none / none | 5.97 | 6.04 | -1.30% | 2.19% | 0.87% | 1 | 3 | | TPCH(_300) | TPCH-Q10 | parquet / none / none | 20.74 | 21.02 | -1.32% | 4.27% | 0.58% | 1 | 3 | | TPCH(_300) | TPCH-Q4 | parquet / none / none | 33.13 | 34.17 | -3.06% | 0.61% | 1.55% | 1 | 3 | | TPCH(_300) | TPCH-Q14 | parquet / none / none | 6.15 | 6.36 | -3.29% | 0.38% | 1.15% | 1 | 3 | | TPCH(_300) | TPCH-Q6 | parquet / none / none | 3.64 | 3.78 | -3.92% | 0.42% | 2.72% | 1 | 3 | | TPCH(_300) | TPCH-Q5 | parquet / none / none | 54.22 | 56.61 | -4.23% | 0.58% | 1.71% | 1 | 3 | | TPCH(_300) | TPCH-Q7 | parquet / none / none | 48.60 | 50.79 | -4.32% | 4.15% | 2.08% | 1 | 3 | | TPCH(_300) | TPCH-Q12 | parquet / none / none | 17.02 | 17.87 | -4.77% | 1.09% | 0.88% | 1 | 3 | | TPCH(_300) | TPCH-Q13 | parquet / none / none | 32.18 | 33.86 | -4.96% | 6.77% | 0.87% | 1 | 3 | | TPCH(_300) | TPCH-Q3 | parquet / none / none | 33.06 | 34.95 | -5.39% | 0.16% | 0.91% | 1 | 3 | | TPCH(_300) | TPCH-Q21 | parquet / none / none | 119.47 | 127.64 | -6.40% | 1.32% | 1.05% | 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: 11 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
