[CALCITE-4378] Included ProjectJoinTransposeRule into the BASE rules (Jiatao Tao)

[Aaaaaaron]

[chunweilei]

The CI failed. Could you resolve it?

[Aaaaaaron]

The CI failed. Could you resolve it?

Sure

[Aaaaaaron]

TPCH test OOM, I'll take a look.

UnknownClass > executionError failure marker
FAILURE   0.0sec, UnknownClass > executionError
    org.junit.platform.commons.JUnitException: TestEngine with ID 'junit-jupiter' failed to execute tests
        at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:254)
        at org.junit.platform.launcher.core.DefaultLauncher.lambda$execute$5(DefaultLauncher.java:211)
        at org.junit.platform.launcher.core.DefaultLauncher.withInterceptedStreams(DefaultLauncher.java:226)
        at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:199)
        at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:132)
        Caused by: org.junit.platform.commons.JUnitException: Error executing tests for engine junit-jupiter
            at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:54)
            at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:248)
            ... 4 more
            Caused by: java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError
                at java.util.concurrent.ForkJoinTask.get(ForkJoinTask.java:1006)
                at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)
                ... 5 more
                Caused by: java.lang.OutOfMemoryError
                    at java.util.concurrent.ForkJoinTask.getThrowableException(ForkJoinTask.java:598)
                    at java.util.concurrent.ForkJoinTask.get(ForkJoinTask.java:1005)
                    ... 6 more
                    Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded
                        at java.util.Arrays.copyOf(Arrays.java:3181)
                        at java.util.ArrayList.grow(ArrayList.java:267)
                        at java.util.ArrayList.ensureExplicitCapacity(ArrayList.java:241)
                        at java.util.ArrayList.ensureCapacityInternal(ArrayList.java:233)
                        at java.util.ArrayList.add(ArrayList.java:464)
                        at org.apache.calcite.plan.volcano.RelSubset.getRelList(RelSubset.java:430)
                        at org.apache.calcite.plan.volcano.VolcanoRuleCall.matchRecurse(VolcanoRuleCall.java:394)
                        at org.apache.calcite.plan.volcano.VolcanoRuleCall.match(VolcanoRuleCall.java:278)
                        at org.apache.calcite.plan.volcano.VolcanoPlanner.fireRules(VolcanoPlanner.java:1103)
                        at org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1370)
                        at org.apache.calcite.plan.volcano.VolcanoPlanner.register(VolcanoPlanner.java:611)
                        at org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:626)
                        at org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:154)
                        at org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:269)
                        at org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:284)Picked up _JAVA_OPTIONS: -XX:GCTimeLimit=90 -XX:GCHeapFreeLimit=35

                        at org.apache.calcite.rel.rules.ProjectMergeRule.onMatch(ProjectMergeRule.java:142)
                        at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:239)
                        at org.apache.calcite.plan.volcano.IterativeRuleDriver.drive(IterativeRuleDriver.java:61)
                        at org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:529)
                        at org.apache.calcite.tools.Programs.lambda$standard$3(Programs.java:274)
                        at org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:334)
                        at org.apache.calcite.prepare.Prepare.optimize(Prepare.java:172)
                        at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:306)
                        at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:215)
                        at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:647)
                        at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:513)
                        at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:483)
                        at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:236)
                        at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:562)
                        at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:675)
                        at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156)