Re: Nested loop joins

2021-02-28 Thread Fan Liya
Hi Priyendra, We have FilterReduceExpressionsRule which reduces filter conditions. It performs the simplification based on org.apache.calcite.rex.RexSimplify. Best, Liya Fan On Mon, Mar 1, 2021 at 1:45 PM Priyendra Deshwal wrote: > Hello friends, > > I am playing around with TPC-DS schema and

Nested loop joins

2021-02-28 Thread Priyendra Deshwal
Hello friends, I am playing around with TPC-DS schema and playing with the following simplified variant of query41. select distinct(i_product_name) from item i1 where i_manufact_id between 738 and 738+40 and (select count(*) as item_cnt from item where (i_manufact =

Re: Google Summer of Code 2021

2021-02-28 Thread Rui Wang
Sounds good. My understanding at this moment is that, if there is an interesting idea, make sure creating a JIRA and label that by "mentor" and "gsoc2021" [1]. Once ASF is confirmed as a mentoring organization, there will be a process to register a project in the GSOC website, and then all will

Re: Assistance with basic calcite program

2021-02-28 Thread Ruben Q L
Thanks for the feedback. I modified your initial TpcdsDeshwalTest to add a SUBSTR predicate in the WHERE clause, I ran the test, I got your initial "No match found for function signature SUBSTR(, , )" exception. Then I just modified the SqlStdOperatorTable to use the chain

[jira] [Created] (CALCITE-4517) $node isAlwaysTrue, so it should simplify to TRUE unknownAsFalse

2021-02-28 Thread Vladimir Sitnikov (Jira)
Vladimir Sitnikov created CALCITE-4517: -- Summary: $node isAlwaysTrue, so it should simplify to TRUE unknownAsFalse Key: CALCITE-4517 URL: https://issues.apache.org/jira/browse/CALCITE-4517

[jira] [Created] (CALCITE-4516) ...had non-nullable type BOOLEAN, and it was optimized to..that has nullable type BOOLEAN

2021-02-28 Thread Vladimir Sitnikov (Jira)
Vladimir Sitnikov created CALCITE-4516: -- Summary: ...had non-nullable type BOOLEAN, and it was optimized to..that has nullable type BOOLEAN Key: CALCITE-4516 URL:

Re: Google Summer of Code 2021

2021-02-28 Thread Stamatis Zampetakis
Hi Rui, Nice idea. Indeed it would be great if Calcite could participate in GSoC. It crossed my mind a few times but then I thought about the amount of open PRs that we have in our backlog and it didn't really make sense at that point. Personally, I would prefer to invest my free time (when I

Re: Pre-packaged set of optimizer rules?

2021-02-28 Thread Priyendra Deshwal
Thanks a lot for the pointer. I indeed tried using it and it is working nicely for me. On Sun, Feb 28, 2021 at 1:22 AM Stamatis Zampetakis wrote: > Hello, > > I think the closest thing to what you are asking is > RelOptUtil#registerDefaultRules [1]. > > Best, > Stamatis > > [1] > >

Re: Pre-packaged set of optimizer rules?

2021-02-28 Thread Stamatis Zampetakis
Hello, I think the closest thing to what you are asking is RelOptUtil#registerDefaultRules [1]. Best, Stamatis [1] https://github.com/apache/calcite/blob/94502f51e6a12cd53cec88b39d21b4fec6070428/core/src/main/java/org/apache/calcite/plan/RelOptUtil.java#L2050 On Sun, Feb 28, 2021 at 12:38 AM