impala-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Tauber-Marshall (Code Review)" <ger...@cloudera.org>
Subject [Impala-CR](cdh5-trunk) IMPALA-2805: Order conjuncts based on selectivity and cost
Date Wed, 13 Apr 2016 18:24:13 GMT
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 <tmarshall@cloudera.com>
Gerrit-Reviewer: Alex Behm <alex.behm@cloudera.com>
Gerrit-Reviewer: Henry Robinson <henry@cloudera.com>
Gerrit-Reviewer: Marcel Kornacker <marcel@cloudera.com>
Gerrit-Reviewer: Matthew Jacobs <mj@cloudera.com>
Gerrit-Reviewer: Mostafa Mokhtar <mmokhtar@cloudera.com>
Gerrit-Reviewer: Thomas Tauber-Marshall <tmarshall@cloudera.com>
Gerrit-Reviewer: Tim Armstrong <tarmstrong@cloudera.com>
Gerrit-HasComments: No

Mime
View raw message