本文整理匯總了Java中com.taobao.tddl.optimizer.core.ast.query.JoinNode.having方法的典型用法代碼示例。如果您正苦於以下問題：Java JoinNode.having方法的具體用法？Java JoinNode.having怎麽用？Java JoinNode.having使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類com.taobao.tddl.optimizer.core.ast.query.JoinNode的用法示例。
在下文中一共展示了JoinNode.having方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。
示例1: convertPlanToAst
import com.taobao.tddl.optimizer.core.ast.query.JoinNode; //導入方法依賴的package包/類
public static JoinNode convertPlanToAst(IJoin join) {
JoinNode node = new JoinNode();
node.setRightNode(convertPlanToAst(join.getRightNode()));
node.setLeftNode(convertPlanToAst(join.getLeftNode()));
node.setJoinStrategy(join.getJoinStrategy());
if (join.getLeftOuter() && join.getRightOuter()) {
node.setInnerJoin();
} else if (join.getLeftOuter()) {
node.setLeftOuterJoin();
} else if (join.getRightOuter()) {
node.setRightOuterJoin();
} else {
node.setOuterJoin();
}
int size = join.getLeftJoinOnColumns().size();
for (int i = 0; i < size; i++) {
node.addJoinKeys(join.getLeftJoinOnColumns().get(i), join.getRightJoinOnColumns().get(i));
}
node.setOrderBys(join.getOrderBys());
node.setLimitFrom(join.getLimitFrom());
node.setLimitTo(join.getLimitTo());
node.setConsistent(join.getConsistent());
node.setResultFilter(join.getValueFilter());
node.having(join.getHavingFilter());
node.setAlias(join.getAlias());
node.setGroupBys(join.getGroupBys());
node.setSubQuery(join.isSubQuery());
node.setOtherJoinOnFilter(join.getOtherJoinOnFilter());
node.select((join.getColumns()));
node.setAllWhereFilter(join.getWhereFilter());
node.setExistAggregate(join.isExistAggregate());
node.executeOn(join.getDataNode());
node.setSubqueryOnFilterId(join.getSubqueryOnFilterId());
node.setSubqueryFilter(join.getSubqueryFilter());
node.build();
node = node.deepCopy();
return node;
}
示例2: TableNode
import com.taobao.tddl.optimizer.core.ast.query.JoinNode; //導入方法依賴的package包/類
@Test
public void test_兩表join_orderby_groupby_limit條件() {
TableNode table = new TableNode("TABLE1");
JoinNode join = table.join("TABLE2", "ID", "ID");
join.select(OptimizerUtils.createColumnFromString("TABLE1.ID AS JID"),
OptimizerUtils.createColumnFromString("CONCAT(TABLE1.NAME,TABLE1.SCHOOL) AS JNAME"));
join.orderBy("JID");
join.groupBy("JNAME");
join.having("COUNT(JID) > 0");
IQueryTree qc = (IQueryTree) optimizer.optimizeAndAssignment(join, null, extraCmd);
Assert.assertTrue(qc instanceof IMerge);
Assert.assertEquals(QUERY_CONCURRENCY.CONCURRENT, ((IMerge) qc).getQueryConcurrency());// 串行
}