Re: [Help] UNION queries with one or more SELECTs containing a JOIN are significantly slower after 1.24

2022-03-17 Thread Gramana, Zachary (GE Digital)
I just sent a PR with a test case: https://github.com/apache/calcite/pull/2747 I will file a new JIRA report tomorrow. Regards, Zack On 3/11/22, 10:36 PM, "Haisheng Yuan" wrote: Hi Zack, Looks like it is a regression. Are you able to provide a reproducible test case? You can log

Re: [Help] UNION queries with one or more SELECTs containing a JOIN are significantly slower after 1.24

2022-03-12 Thread Ruben Q L
Hello, At first glance, it could also be possible that the regression is originated in the RelFieldTrimmer. Just a hypothesis. Best, Ruben On Sat, Mar 12, 2022 at 6:35 AM Haisheng Yuan wrote: > Hi Zack, > > Looks like it is a regression. > Are you able to provide a reproducible test case? Yo

Re: [Help] UNION queries with one or more SELECTs containing a JOIN are significantly slower after 1.24

2022-03-11 Thread Haisheng Yuan
Hi Zack, Looks like it is a regression. Are you able to provide a reproducible test case? You can log a JIRA along with the test case, so people can do the root cause analysis. Thanks, Haisheng Yuan On 2022/03/12 01:26:53 "Gramana, Zachary (GE Digital)" wrote: > Hello all! > > I would apprecia

[Help] UNION queries with one or more SELECTs containing a JOIN are significantly slower after 1.24

2022-03-11 Thread Gramana, Zachary (GE Digital)
Hello all! I would appreciate some help/guidance with troubleshooting a big performance regression we saw on our UNION queries after updating our application from 1.24 to 1.29. Many of the tables in the queries are wide (> 50 columns) so we use a custom push-down Project class. These custom Pro