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
