@Test public void testProjectCorrelateTranspose() { ProjectCorrelateTransposeRule customPCTrans = new ProjectCorrelateTransposeRule(expr -> true, RelFactories.LOGICAL_BUILDER); checkPlanning(customPCTrans, "select t1.name, t2.ename " + "from DEPT_NESTED as t1, " + "unnest(t1.employees) as t2"); }
@Test public void testProjectCorrelateTransposeWithExprCond() { ProjectCorrelateTransposeRule customPCTrans = new ProjectCorrelateTransposeRule(skipItem, RelFactories.LOGICAL_BUILDER); checkPlanning(customPCTrans, "select t1.name, t2.ename " + "from DEPT_NESTED as t1, " + "unnest(t1.employees) as t2"); }
@Test public void testProjectCorrelateTransposeWithExprCond() { ProjectCorrelateTransposeRule customPCTrans = new ProjectCorrelateTransposeRule(skipItem, RelFactories.LOGICAL_BUILDER); checkPlanning(customPCTrans, "select t1.name, t2.ename " + "from DEPT_NESTED as t1, " + "unnest(t1.employees) as t2"); }
@Test public void testProjectCorrelateTranspose() { ProjectCorrelateTransposeRule customPCTrans = new ProjectCorrelateTransposeRule(expr -> true, RelFactories.LOGICAL_BUILDER); checkPlanning(customPCTrans, "select t1.name, t2.ename " + "from DEPT_NESTED as t1, " + "unnest(t1.employees) as t2"); }
@Test public void testProjectCorrelateTransposeDynamic() { ProjectCorrelateTransposeRule customPCTrans = new ProjectCorrelateTransposeRule(skipItem, RelFactories.LOGICAL_BUILDER); HepProgramBuilder programBuilder = HepProgram.builder() .addRuleInstance(customPCTrans); String query = "select t1.c_nationkey, t2.a as fake_col2 " + "from SALES.CUSTOMER as t1, " + "unnest(t1.fake_col) as t2(a)"; checkPlanning( createDynamicTester(), null, new HepPlanner(programBuilder.build()), query, true); }
@Test public void testProjectCorrelateTransposeDynamic() { ProjectCorrelateTransposeRule customPCTrans = new ProjectCorrelateTransposeRule(skipItem, RelFactories.LOGICAL_BUILDER); HepProgramBuilder programBuilder = HepProgram.builder() .addRuleInstance(customPCTrans); String query = "select t1.c_nationkey, t2.a as fake_col2 " + "from SALES.CUSTOMER as t1, " + "unnest(t1.fake_col) as t2(a)"; checkPlanning( createDynamicTester(), null, new HepPlanner(programBuilder.build()), query, true); }