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 19:57:48 GMT
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 <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