It looks as if you’re running into a bug in HepPlanner. I may have run into something similar when I was working on https://issues.apache.org/jira/browse/CALCITE-873 <https://issues.apache.org/jira/browse/CALCITE-873>.
> On Jun 25, 2017, at 8:13 PM, Atri Sharma <[email protected]> wrote: > > Hi All, > > Please advise. > > Regards, > > Atri > > On Jun 25, 2017 11:25 PM, "Atri Sharma" <[email protected]> wrote: > >> Debugging a bit further, I realised that the code flow is stuck in >> applyRules. In the following code: >> >> while (iter.hasNext()) { >> HepRelVertex vertex = iter.next(); >> for (RelOptRule rule : rules) { >> HepRelVertex newVertex = >> applyRule(rule, vertex, forceConversions); >> >> vertex is constantly the top level LogicalSort node, and not moving >> down the plan. >> >> Is there something that I am missing? >> >> Regards, >> >> Atri >> >> On Sun, Jun 25, 2017 at 2:30 PM, Atri Sharma <[email protected]> wrote: >>> Hi All, >>> >>> I am working on removing redundant sorts and am stuck when >>> transforming the call to replace older Sort node with the reduced one. >>> >>> The code works like following: >>> >>> final RelCollation newCollation = RelCollations.of(collationsList); >>> >>> Sort result = sort.copy(sort.getTraitSet(), sort.getInput(), >> newCollation, >>> sort.offset, sort.fetch); >>> >>> call.transformTo(result); >>> >>> The trnasformTo call is stuck forever. >>> >>> The query is: >>> >>> select count(*) as c\n" >>> + "from sales.emp\n" >>> + "where deptno = 10\n" >>> + "group by deptno, sal\n" >>> + "order by deptno, sal"; >>> >>> >>> Please advise >>> >>> Regards, >>> >>> Atri >>> >>> >>> >>> >>> >>> >>> >>> >>> -- >>> Regards, >>> >>> Atri >>> l'apprenant >> >> >> >> -- >> Regards, >> >> Atri >> l'apprenant >>
