當前位置: 首頁>>代碼示例>>Java>>正文

Java TableNode.join方法代碼示例

本文整理匯總了Java中com.taobao.tddl.optimizer.core.ast.query.TableNode.join方法的典型用法代碼示例。如果您正苦於以下問題：Java TableNode.join方法的具體用法？Java TableNode.join怎麽用？Java TableNode.join使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類com.taobao.tddl.optimizer.core.ast.query.TableNode的用法示例。


在下文中一共展示了TableNode.join方法的7個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。

示例1: TableNode

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //導入方法依賴的package包/類
@Test
public void test_join條件下推_子表_case4_下推IDNAME() {
    TableNode table1 = new TableNode("TABLE1");
    TableNode table2 = new TableNode("TABLE2");
    table1.alias("A");
    table2.alias("B");

    JoinNode join = table1.join(table2);
    join.setJoinStrategy(JoinStrategy.INDEX_NEST_LOOP);
    join.orderBy("A.ID");
    join.orderBy("A.NAME");
    join.build();

    OrderByPusher.optimize(join);

    Assert.assertEquals(2, table1.getOrderBys().size());
    Assert.assertEquals("TABLE1.ID", table1.getOrderBys().get(0).getColumn().toString());
    Assert.assertEquals("TABLE1.NAME", table1.getOrderBys().get(1).getColumn().toString());
}
開發者ID:beebeandwer，項目名稱:TDDL，代碼行數:20，代碼來源:OrderByPusherTest.java

示例2: TableNode

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //導入方法依賴的package包/類
@Test
public void test_join條件下推_子表_case1_下推NAME() {
    TableNode table1 = new TableNode("TABLE1");
    TableNode table2 = new TableNode("TABLE2");
    table1.alias("A");
    table1.orderBy("ID");
    table2.alias("B");

    JoinNode join = table1.join(table2);
    join.setJoinStrategy(JoinStrategy.INDEX_NEST_LOOP);
    join.orderBy("A.ID");
    join.orderBy("A.NAME");
    join.build();

    OrderByPusher.optimize(join);

    Assert.assertEquals(2, table1.getOrderBys().size());
    Assert.assertEquals("TABLE1.ID", table1.getOrderBys().get(0).getColumn().toString());
    Assert.assertEquals("TABLE1.NAME", table1.getOrderBys().get(1).getColumn().toString());
}
開發者ID:loye168，項目名稱:tddl5，代碼行數:21，代碼來源:OrderByPusherTest.java

示例3: TableNode

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //導入方法依賴的package包/類
@Test
public void test_where條件下推_多級join() {
    TableNode table1 = new TableNode("TABLE1");
    TableNode table2 = new TableNode("TABLE2");
    TableNode table3 = new TableNode("TABLE3");

    JoinNode join = table1.join(table2);
    join.select("TABLE1.ID AS ID , TABLE1.NAME AS NAME");
    join.query("TABLE1.ID>5 AND TABLE2.ID<10 AND TABLE1.NAME = TABLE2.NAME");
    join.build();

    JoinNode nextJoin = join.join(table3);
    nextJoin.query("TABLE1.NAME = 6 AND TABLE1.ID = TABLE3.ID");
    nextJoin.build();
    FilterPusher.optimize(nextJoin);

    Assert.assertEquals("(TABLE1.NAME = 6 AND TABLE1.ID > 5)", ((JoinNode) nextJoin.getLeftNode()).getLeftNode()
        .getWhereFilter()
        .toString());
    Assert.assertEquals("(TABLE2.ID < 10 AND TABLE2.NAME = 6)", ((JoinNode) nextJoin.getLeftNode()).getRightNode()
        .getWhereFilter()
        .toString());
    Assert.assertEquals("TABLE1.ID = TABLE3.ID", nextJoin.getJoinFilter().get(0).toString());
}
開發者ID:beebeandwer，項目名稱:TDDL，代碼行數:25，代碼來源:FilterPusherTest.java

示例4: TableNode

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //導入方法依賴的package包/類
@Test
public void test_兩表Join_主鍵_存在二級索引條件() {
    TableNode table = new TableNode("TABLE1");
    JoinNode join = table.join("TABLE2", "ID", "ID");
    join.query("TABLE2.NAME = 1");
    IQueryTree qc = (IQueryTree) optimizer.optimizeAndAssignment(join, null, extraCmd);
    Assert.assertTrue(qc instanceof IMerge);
    Assert.assertTrue(((IMerge) qc).getSubNodes().get(0) instanceof IJoin);
    IJoin subJoin = (IJoin) ((IMerge) qc).getSubNodes().get(0);
    Assert.assertTrue(subJoin.getRightNode() instanceof IJoin);
    Assert.assertEquals(JoinStrategy.NEST_LOOP_JOIN, subJoin.getJoinStrategy());
}
開發者ID:loye168，項目名稱:tddl5，代碼行數:13，代碼來源:OptimizerTest.java

示例5: TableNode

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //導入方法依賴的package包/類
@Test
public void test_三表Join_主鍵索引_存在主鍵索引條件() {
    TableNode table = new TableNode("TABLE1");
    JoinNode join = table.join("TABLE2", "TABLE1.ID", "TABLE2.ID");
    join = join.join("TABLE3", "TABLE1.ID", "TABLE3.ID");
    join.query("TABLE3.ID IN (1,2)");
    IQueryTree qc = (IQueryTree) optimizer.optimizeAndAssignment(join, null, extraCmd);
    Assert.assertTrue(qc instanceof IMerge);
    Assert.assertTrue(((IMerge) qc).getSubNode().get(0) instanceof IJoin);
    IJoin subJoin = (IJoin) ((IMerge) qc).getSubNode().get(0);
    Assert.assertTrue(subJoin.getLeftNode() instanceof IJoin);
    Assert.assertEquals(JoinStrategy.INDEX_NEST_LOOP, subJoin.getJoinStrategy());
}
開發者ID:beebeandwer，項目名稱:TDDL，代碼行數:14，代碼來源:OptimizerTest.java

示例6: TableNode

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //導入方法依賴的package包/類
@Test
public void test_where中無匹配條件不下推() {
    TableNode table1 = new TableNode("TABLE1");
    TableNode table2 = new TableNode("TABLE2");

    JoinNode join = table1.join(table2);
    join.query("(TABLE1.ID>5 OR TABLE2.ID<10) AND TABLE1.NAME = TABLE2.NAME");
    join.build();
    FilterPreProcessor.optimize(join, true, null);
    FilterPusher.optimize(join);

    Assert.assertEquals(null, join.getLeftNode().getWhereFilter());
    Assert.assertEquals(null, join.getRightNode().getWhereFilter());
    Assert.assertTrue(join.getJoinFilter().isEmpty());
}
開發者ID:loye168，項目名稱:tddl5，代碼行數:16，代碼來源:FilterPusherTest.java

示例7: TableNode

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //導入方法依賴的package包/類
@Test
public void test_Join左是子查詢_右是TableNode_轉化為最左樹() {
    TableNode table1 = new TableNode("TABLE1");
    QueryNode query = new QueryNode(table1);
    query.build();

    TableNode table2 = new TableNode("TABLE2");

    JoinNode join = table1.join(table2, "NAME", "NAME");
    join.setJoinStrategy(JoinStrategy.INDEX_NEST_LOOP);
    join.query("TABLE1.NAME = 1 AND TABLE1.ID > 3 AND TABLE1.SCHOOL = 1");// 原本條件應該是加在join下的，這裏省區推導的過程
    join.select("(TABLE2.ID + TABLE2.NAME) AS NEWNAME"); // 設置為函數
    join.orderBy("TABLE1.SCHOOL", false);// 增加一個隱藏列
    join.groupBy("NEWNAME");
    join.build();

    QueryTreeNode qn = FilterPusher.optimize(join);// 先把條件推導子節點上，構建子節點join
    build(table1);
    build(table2);
    qn = qn.convertToJoinIfNeed();

    Assert.assertTrue(qn instanceof JoinNode);
    Assert.assertEquals("TABLE2$_NAME.ID = TABLE2.ID", ((JoinNode) qn).getJoinFilter().get(0).toString());

    Assert.assertTrue(((JoinNode) qn).getLeftNode() instanceof JoinNode);
    Assert.assertEquals("TABLE1.NAME = TABLE2$_NAME.NAME",
        ((JoinNode) ((JoinNode) qn).getLeftNode()).getJoinFilter().get(0).toString());

    Assert.assertTrue(((JoinNode) ((JoinNode) qn).getLeftNode()).getLeftNode() instanceof JoinNode);
    JoinNode jn = (JoinNode) ((JoinNode) ((JoinNode) qn).getLeftNode()).getLeftNode();
    Assert.assertEquals("TABLE1._NAME.NAME = 1", jn.getLeftNode().getKeyFilter().toString());
    Assert.assertEquals("TABLE1._NAME.ID > 3", jn.getLeftNode().getResultFilter().toString());
    Assert.assertEquals("TABLE1.SCHOOL = 1", jn.getRightNode().getResultFilter().toString());
    Assert.assertEquals("TABLE1._NAME.ID = TABLE1.ID", jn.getJoinFilter().get(0).toString());
}
開發者ID:loye168，項目名稱:tddl5，代碼行數:36，代碼來源:JoinChooserTest.java


注：本文中的com.taobao.tddl.optimizer.core.ast.query.TableNode.join方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。