Michael Smith has posted comments on this change. ( http://gerrit.cloudera.org:8080/25030 )
Change subject: IMPALA-15489: Inefficient CTE plans with trivial IS NOT NULL filters ...................................................................... Patch Set 1: > Patch Set 1: > > > Patch Set 1: > > > > @Joe, Michael, Steve: Can someone launch a small scale TPC-DS run similar > > to https://jenkins.impala.io/job/perf-AB-test-ub2204/46/ > > > > I don't have permissions to use this Jenkins job. > > https://jenkins.impala.io/job/perf-AB-test-ub2204/53/ https://jenkins.impala.io/job/perf-AB-test-ub2204/53/artifact/Impala/perf_results/latest/performance_result.txt: +-----------+-----------------------+---------+------------+------------+----------------+ | Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) | +-----------+-----------------------+---------+------------+------------+----------------+ | TPCDS(20) | parquet / none / none | 0.79 | -3.23% | 0.44 | -3.78% | +-----------+-----------------------+---------+------------+------------+----------------+ Q88 does significantly worse (1.38s -> 2.89s [+109.52%]); Q65, Q80A, Q31, Q14-2, Q81, Q1, and a dozen others see strong improvement. -- To view, visit http://gerrit.cloudera.org:8080/25030 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: Id5084b4b03cb0277a945338855a2d85f6c04a211 Gerrit-Change-Number: 25030 Gerrit-PatchSet: 1 Gerrit-Owner: Stamatis Zampetakis <[email protected]> Gerrit-Reviewer: Impala Public Jenkins <[email protected]> Gerrit-Reviewer: Joe McDonnell <[email protected]> Gerrit-Reviewer: Michael Smith <[email protected]> Gerrit-Reviewer: Stamatis Zampetakis <[email protected]> Gerrit-Reviewer: Steve Carlin <[email protected]> Gerrit-Comment-Date: Wed, 07 Oct 2026 18:18:04 +0000 Gerrit-HasComments: No
