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 filters based on selectivity and cost
Date Thu, 07 Apr 2016 23:20:59 GMT
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 <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