Aman Sinha has posted comments on this change. ( http://gerrit.cloudera.org:8080/16346 )
Change subject: IMPALA-10064: Support constant propagation for eligible range predicates ...................................................................... Patch Set 11: > Patch Set 10: > > Was able to find some time to look for local joins in TPCDS. There are not > many at all. > > query2.sql:WHERE d_week_seq1 = d_week_seq2 - 53 > query59.sql: AND d_week_seq1 = d_week_seq2 - 52 > query59.sql:WHERE s_store_id1 = s_store_id2 > > Sounds like they can be used for the min/max filtering at least. Thanks Qifan. Looking at query2, the d_week_seq1, d_week_seq2 come from different derived tables 'y' and 'z' even though the underlying base table is the same. From the planner perspective, they would be treated as a regular join. -- To view, visit http://gerrit.cloudera.org:8080/16346 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I811a1f8d605c27c7704d7fc759a91510c6db3c2b Gerrit-Change-Number: 16346 Gerrit-PatchSet: 11 Gerrit-Owner: Aman Sinha <amsi...@cloudera.com> Gerrit-Reviewer: Aman Sinha <amsi...@cloudera.com> Gerrit-Reviewer: Impala Public Jenkins <impala-public-jenk...@cloudera.com> Gerrit-Reviewer: Qifan Chen <qc...@cloudera.com> Gerrit-Reviewer: Shant Hovsepian <sh...@cloudera.com> Gerrit-Reviewer: Tim Armstrong <tarmstr...@cloudera.com> Gerrit-Comment-Date: Wed, 02 Sep 2020 07:16:27 +0000 Gerrit-HasComments: No