Mostafa Mokhtar has posted comments on this change. Change subject: Renamed conjunct_ordering.test to primitive_conjunct_ordering.test in targeted-perf ......................................................................
Patch Set 1: -Code-Review
Just noticed that this query is not valid as the predicates are not pushed to
the scan and are applied at the join.
| Explain String
|
| Estimated Per-Host Requirements: Memory=4.43GB VCores=2
|
|
|
| 06:AGGREGATE [FINALIZE]
|
| | output: sum:merge(l_extendedprice * (1 - l_discount))
|
| |
|
| 05:EXCHANGE [UNPARTITIONED]
|
| |
|
| 03:AGGREGATE
|
| | output: sum(l_extendedprice * (1 - l_discount))
|
| |
|
| 02:HASH JOIN [INNER JOIN, BROADCAST]
|
| | hash predicates: l_partkey = p_partkey
|
| | other predicates: ((p_brand = 'Brand#12' AND p_container IN ('SM CASE',
'SM BOX', 'SM PACK', 'SM PKG') AND l_quantity >= 1 AND l_quantity <= 11 AND
p_size BETWEEN 1 AND 5 AND l_shipmode IN ('AIR', 'AIR REG') AND l_shipinstruct
= 'DELIVER IN PERSON') OR (p_brand = 'Brand#23' AND p_container IN ('MED BAG',
'MED BOX', 'MED PKG', 'MED PACK') AND l_quantity >= 10 AND l_quantity <= 20 AND
p_size BETWEEN 1 AND 10 AND l_shipmode IN ('AIR', 'AIR REG') AND l_shipinstruct
= 'DELIVER IN PERSON') OR (p_brand = 'Brand#34' AND p_container IN ('LG CASE',
'LG BOX', 'LG PACK', 'LG PKG') AND l_quantity >= 20 AND l_quantity <= 30 AND
p_size BETWEEN 1 AND 15 AND l_shipmode IN ('AIR', 'AIR REG') AND l_shipinstruct
= 'DELIVER IN PERSON')), (p_partkey = 0 OR l_partkey = 0) |
| | runtime filters: RF000 <- p_partkey
|
| |
|
| |--04:EXCHANGE [BROADCAST]
|
| | |
|
| | 01:SCAN HDFS [tpch_300_parquet.part]
|
| | partitions=1/1 files=9 size=1.92GB
|
| |
|
| 00:SCAN HDFS [tpch_300_parquet.lineitem]
|
| partitions=1/1 files=264 size=64.36GB
|
| runtime filters: RF000 -> l_partkey
|
--
To view, visit http://gerrit.cloudera.org:8080/3021
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: Ica8db68141ef653b0b01a7cfa7773302717a35a2
Gerrit-PatchSet: 1
Gerrit-Project: Impala
Gerrit-Branch: cdh5-trunk
Gerrit-Owner: Thomas Tauber-Marshall <[email protected]>
Gerrit-Reviewer: Mostafa Mokhtar <[email protected]>
Gerrit-HasComments: No
