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
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 = i1.i_man
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 s
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
(SqlStdOperatorTable.in
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
Projec
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: https://issues.apache.org/jira/browse/CALCITE
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 hav
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]
>
> https://githu
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 Pr
