git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: JoinPushThroughJoinRule not applied on plan



On 2018/05/04 14:23:00, Michael Mior <mmior@xxxxxxxxxxxx> wrote: 
> I have no immediate answers, but it would be helpful if you could provide a
> complete working example of code that exhibits the problem.
> 
> --
> Michael Mior
> mmior@xxxxxxxxxxxx
> 
> 
> Le ven. 4 mai 2018 à 03:58, Valli Annamalai <aishwaryaanns@xxxxxxxxx> a
> écrit :
> 
> > I wanted to apply JoinPushThroughJoinRule.LEFT and
> > JoinPushThroughJoinRule.RIGHT to the plan for optimization. So I added
> > those 2 rules to Program and ran it as a sequence of programs.
> >
> > But I am not getting plan applied with these rules
> >
> > I did read [here
> > <
> > https://issues.apache.org/jira/browse/CALCITE-457?focusedCommentId=14205221&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14205221
> > >]
> > that adding rules does not mean that the plan will be better. So sanity
> > checks may fail. In my case, during onMatch() checks (in matchRecurse()
> > from ValcanoRuleCall.java), it fails because of no parents for the subsets
> > (getParentRels() returns empty list) .
> >
> > Thus there are no successors and the recursion has not been trigerred. So
> > the rules has not been fired (onMatch() in JoinPushThroughJoinRule.java has
> > not been called at all). What can be done for that?
> >
> > Any other flags need to be enabled or rules to be added??
> >
> >
> > Thanks in advance
> >
>