ProjectRemoveRule replaces project with its input ignoring alias

2021-11-23 Thread Yanjing Wang
Hi, team I'm using ProjectRemoveRule to simplify my logical plan, But the plan sometimes miss its project alias, I find the rule hasn't checked the alias for project row type identity equation, so I think it may be a bug, I have tried to reproduce the problem, but I failed to build two projects.

[jira] [Created] (CALCITE-4899) Support hint for lateral table syntax

2021-11-23 Thread tartarus (Jira)
tartarus created CALCITE-4899: - Summary: Support hint for lateral table syntax Key: CALCITE-4899 URL: https://issues.apache.org/jira/browse/CALCITE-4899 Project: Calcite Issue Type: Improvement

Re: [DISCUSS] Calcite 1.29.0 release

2021-11-23 Thread Rui Wang
Thanks Julian. That sounds good. I will revisit the release process at the beginning of Dec to check what preparation work I need to do. -Rui On Tue, Nov 23, 2021 at 8:34 AM Julian Hyde wrote: > In my opinion, the more often we release, the better. A release around > 15th of December would be

Re: Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2021-11-23 Thread Jacques Nadeau
I'd love to do an ocerview of my exploration with graalvm and substrait. On Tue, Nov 23, 2021, 10:35 AM Julian Hyde wrote: > +1 for Jan 19 > > It would be great if Stamatis repeated one or two of the segments of > his tutorial at BOSS. (I was co-presenter but you've all heard enough > from me.)

Re: Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2021-11-23 Thread Julian Hyde
+1 for Jan 19 It would be great if Stamatis repeated one or two of the segments of his tutorial at BOSS. (I was co-presenter but you've all heard enough from me.) The material about adapters is foundational to understanding Calcite. It could happen on Jan 19 or at another meetup in a couple of mon

Re: [DISCUSS] Calcite 1.29.0 release

2021-11-23 Thread Julian Hyde
In my opinion, the more often we release, the better. A release around 15th of December would be 2 months since the previous release, and probably not too much work, as things have been fairly quiet since 1.28. Thanks for volunteering to be RM. As always, we should make a push to get any PRs th

[jira] [Created] (CALCITE-4898) Upgrading Elasticsearch version from 7.0.1 to 7.15 in Elasticsearch Adapter

2021-11-23 Thread ZheHu (Jira)
ZheHu created CALCITE-4898: -- Summary: Upgrading Elasticsearch version from 7.0.1 to 7.15 in Elasticsearch Adapter Key: CALCITE-4898 URL: https://issues.apache.org/jira/browse/CALCITE-4898 Project: Calcite

Re: Why calcite does not support outer join in materialized view

2021-11-23 Thread hongkang jiang
Hi, Chunwei. Thank you very much for your reply and I read it carefully. Then I tried running a test in the MaterializedViewSubstitutionVisitorTest unit test class. I expected it to rewrite successfully, but not. The test is as follows: @Test void test() { String mv = "" + "select \"emps

Re: Re: [DISCUSS] Apache Calcite Online Meetup January 2022

2021-11-23 Thread Stamatis Zampetakis
Thanks everyone for the feedback! @ Vladimir O, Vladimir S: Thanks for proposing to give a talk. I believe both topics will be very interesting for the community. When you settle up on what you would like to present please share an abstract & duration for the talk. Since there is interest and we

Re: Why calcite does not support outer join in materialized view

2021-11-23 Thread Chunwei Lei
Hi, Hongkang. Calcite has two ways to do query-rewriting, namely substitution, and rules[1]. MaterializedViewRule builds on the ideas presented in the paper[2], which does not talk much about outer-join rewriting. If you want to support outer join, you can try to use MaterializedViewSubstitutionVi