Re: Rules to squash redundant join sides?

I agree with Stamatis that this would be a useful feature. The first step would be log a jira case with a clear description of the problem. Can you describe exactly what you mean by ‘mergeable’, ‘redundant' and ’squash’? I can’t follow your example, Ian. Can you find a simpler example, or

Re: What is difference between The UnifyRule and MaterializedViewRule?

Hi Chunwei, Thank you very much for your answer. Best, LakeShen Chunwei Lei 于2022年5月9日周一 14:22写道： > Hi, LakeShen. > > You may find the answer in this doc[1]. > > [1] https://calcite.apache.org/docs/materialized_views.html > > > Best, > Chunwei > > > On Sat, May 7, 2022 at 9:17 AM LakeShen

Re: The question about the Apache Calcite 2.0's progress

Hi Stamatis, Thank you very much for your answer,It really helped me. Best, LakeShen Stamatis Zampetakis 于2023年3月30日周四 16:46写道： > Hi LakeShen, > > The last discussion about this topic was back in 2021 [1]. > > Apart from cleanup there is nothing major to be done as part of 2.0 so > there is

[jira] [Created] (CALCITE-5626) Query with EXISTS function gives Table ... not found error

Roman Churganov created CALCITE-5626: Summary: Query with EXISTS function gives Table ... not found error Key: CALCITE-5626 URL: https://issues.apache.org/jira/browse/CALCITE-5626 Project: Calcite

[jira] [Created] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

Oliver Lee created CALCITE-5625: --- Summary: Expand SEARCH RexNode when converting toJson Key: CALCITE-5625 URL: https://issues.apache.org/jira/browse/CALCITE-5625 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5624) Cannot parse array udf for Spark Dialect

Guillaume Massé created CALCITE-5624: Summary: Cannot parse array udf for Spark Dialect Key: CALCITE-5624 URL: https://issues.apache.org/jira/browse/CALCITE-5624 Project: Calcite Issue

Re: Re: Rules to squash redundant join sides?

Stamatis, Thanks! I’ll take a look at this. Is it possible to avoid the creation of these kinds of joins correlated subqueries? Or does that still have the same issue as general joins? Thanks! -Ian From: Stamatis Zampetakis Date: Thursday, March 30, 2023 at 1:41 AM To: dev@calcite.apache.org

[jira] [Created] (CALCITE-5623) assert

Ran Tao created CALCITE-5623: Summary: assert Key: CALCITE-5623 URL: https://issues.apache.org/jira/browse/CALCITE-5623 Project: Calcite Issue Type: Bug Reporter: Ran Tao

[jira] [Created] (CALCITE-5622) Cast is lost from Plan to Postgres Statement

Corvin Kuebler created CALCITE-5622: --- Summary: Cast is lost from Plan to Postgres Statement Key: CALCITE-5622 URL: https://issues.apache.org/jira/browse/CALCITE-5622 Project: Calcite Issue

Re: CI requiring approval for external contributors

It's true that I've never seen a fake PR so far in the ASF repos but at the same time I am not following every single PR. I can understand the approval for first time contributors but keeping the approval for everyone seems a bit too much. Best, Stamatis On Wed, Mar 29, 2023 at 5:04 AM 王鹏

Re: The question about the Apache Calcite 2.0's progress

Hi LakeShen, The last discussion about this topic was back in 2021 [1]. Apart from cleanup there is nothing major to be done as part of 2.0 so there is no big rush to get it out. Best, Stamatis [1] https://lists.apache.org/thread/p6svy4hps193g4knhsksv7psx0osgvq7 On Wed, Mar 29, 2023 at 8:51 

Re: Rules to squash redundant join sides?

Hey Ian, I think you are referring to the problem of query minimization and at the moment we don't have any such rules in Calcite but it would be a valuable contribution. Apart from the algorithm itself, it might be necessary to introduce some new metadata provider for PK-FK relationships