Thomas Tauber-Marshall has posted comments on this change. Change subject: IMPALA-2805: Order conjuncts based on selectivity and cost ......................................................................
Patch Set 11: Results from tpcds: +--------------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +--------------+-----------------------+---------+------------+------------+----------------+ | TPCDS(_1000) | parquet / none / none | 9.12 | -3.97% | 3.31 | -1.44% | +--------------+-----------------------+---------+------------+------------+----------------+ +--------------+-----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Num Clients | Iters | +--------------+-----------+-----------------------+--------+-------------+------------+-----------+----------------+-------------+-------+ | TPCDS(_1000) | TPCDS-Q53 | parquet / none / none | 1.61 | 1.52 | +6.07% | 0.34% | 0.47% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q96 | parquet / none / none | 3.93 | 3.72 | +5.50% | 0.38% | 0.44% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q3 | parquet / none / none | 1.15 | 1.10 | +3.65% | 5.08% | 0.01% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q98 | parquet / none / none | 1.41 | 1.36 | +3.52% | 4.52% | 0.15% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q65 | parquet / none / none | 30.83 | 29.84 | +3.34% | 1.48% | 0.78% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q8 | parquet / none / none | 1.58 | 1.53 | +3.12% | 0.07% | 0.42% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q89 | parquet / none / none | 2.08 | 2.02 | +2.65% | 4.97% | 2.73% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q55 | parquet / none / none | 1.01 | 1.00 | +1.55% | 4.43% | 6.44% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q68 | parquet / none / none | 2.51 | 2.50 | +0.55% | 1.04% | 0.32% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q46 | parquet / none / none | 3.13 | 3.11 | +0.47% | 0.17% | 2.49% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q34 | parquet / none / none | 2.87 | 2.87 | +0.14% | 3.65% | 2.35% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q19 | parquet / none / none | 1.16 | 1.17 | -0.10% | 0.51% | 0.10% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q7 | parquet / none / none | 2.92 | 2.93 | -0.40% | 1.90% | 0.43% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q42 | parquet / none / none | 1.01 | 1.02 | -1.11% | 0.08% | 4.68% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q6 | parquet / none / none | 77.77 | 78.76 | -1.25% | 0.71% | 2.64% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q43 | parquet / none / none | 3.78 | 3.83 | -1.52% | 1.31% | 1.36% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q61 | parquet / none / none | 2.59 | 2.64 | -1.90% | 2.48% | 4.97% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q79 | parquet / none / none | 2.91 | 2.97 | -1.92% | 1.37% | 0.28% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q63 | parquet / none / none | 1.50 | 1.54 | -3.11% | 1.74% | 4.84% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q27 | parquet / none / none | 2.66 | 2.76 | -3.50% | 1.55% | 1.75% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q88 | parquet / none / none | 13.10 | 13.72 | -4.54% | 0.68% | 0.08% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q73 | parquet / none / none | 1.27 | 1.35 | -5.84% | 2.89% | 3.22% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q47 | parquet / none / none | 43.01 | 47.09 | -8.66% | 0.93% | 0.53% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q52 | parquet / none / none | 0.93 | 1.05 | -11.08% | 2.81% | 8.04% | 1 | 3 | | TPCDS(_1000) | TPCDS-Q59 | parquet / none / none | 21.22 | 25.95 | -18.24% | 0.53% | 4.70% | 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
