Examples with Join org.apache.calcite.rel.core.Join used on opensource projects

Example 21 with Join

use of org.apache.calcite.rel.core.Join in project drill by axbaretto.

the class JoinUtils method checkCartesianJoin.

/**
 * Check if the given RelNode contains any Cartesian join.
 * Return true if find one. Otherwise, return false.
 *
 * @param relNode     the RelNode to be inspected.
 * @param leftKeys    a list used for the left input into the join which has
 *                    equi-join keys. It can be empty or not (but not null),
 *                    this method will clear this list before using it.
 * @param rightKeys   a list used for the right input into the join which has
 *                    equi-join keys. It can be empty or not (but not null),
 *                    this method will clear this list before using it.
 * @param filterNulls The join key positions for which null values will not
 *                    match.
 * @return            Return true if the given relNode contains Cartesian join.
 *                    Otherwise, return false
 */
public static boolean checkCartesianJoin(RelNode relNode, List<Integer> leftKeys, List<Integer> rightKeys, List<Boolean> filterNulls) {
    if (relNode instanceof Join) {
        leftKeys.clear();
        rightKeys.clear();
        Join joinRel = (Join) relNode;
        RelNode left = joinRel.getLeft();
        RelNode right = joinRel.getRight();
        RexNode remaining = RelOptUtil.splitJoinCondition(left, right, joinRel.getCondition(), leftKeys, rightKeys, filterNulls);
        if (joinRel.getJoinType() == JoinRelType.INNER) {
            if (leftKeys.isEmpty() || rightKeys.isEmpty()) {
                return true;
            }
        } else {
            if (!remaining.isAlwaysTrue() || leftKeys.isEmpty() || rightKeys.isEmpty()) {
                return true;
            }
        }
    }
    for (RelNode child : relNode.getInputs()) {
        if (checkCartesianJoin(child, leftKeys, rightKeys, filterNulls)) {
            return true;
        }
    }
    return false;
}

Example 22 with Join

use of org.apache.calcite.rel.core.Join in project drill by apache.

the class JoinUtils method checkCartesianJoin.

/**
 * Check if the given RelNode contains any Cartesian join.
 * Return true if find one. Otherwise, return false.
 *
 * @param relNode     the RelNode to be inspected.
 * @param leftKeys    a list used for the left input into the join which has
 *                    equi-join keys. It can be empty or not (but not null),
 *                    this method will clear this list before using it.
 * @param rightKeys   a list used for the right input into the join which has
 *                    equi-join keys. It can be empty or not (but not null),
 *                    this method will clear this list before using it.
 * @param filterNulls The join key positions for which null values will not
 *                    match.
 * @return            Return true if the given relNode contains Cartesian join.
 *                    Otherwise, return false
 */
public static boolean checkCartesianJoin(RelNode relNode, List<Integer> leftKeys, List<Integer> rightKeys, List<Boolean> filterNulls) {
    if (relNode instanceof Join) {
        leftKeys.clear();
        rightKeys.clear();
        Join joinRel = (Join) relNode;
        RelNode left = joinRel.getLeft();
        RelNode right = joinRel.getRight();
        RexNode remaining = RelOptUtil.splitJoinCondition(left, right, joinRel.getCondition(), leftKeys, rightKeys, filterNulls);
        if (joinRel.getJoinType() == JoinRelType.INNER) {
            if (leftKeys.isEmpty() || rightKeys.isEmpty()) {
                return true;
            }
        } else {
            if (!remaining.isAlwaysTrue() || leftKeys.isEmpty() || rightKeys.isEmpty()) {
                return true;
            }
        }
    }
    for (RelNode child : relNode.getInputs()) {
        if (checkCartesianJoin(child, leftKeys, rightKeys, filterNulls)) {
            return true;
        }
    }
    return false;
}

Example 23 with Join

use of org.apache.calcite.rel.core.Join in project drill by apache.

the class PhoenixJoinRule method convert.

@Override
public RelNode convert(RelNode rel) {
    final List<RelNode> newInputs = new ArrayList<>();
    final Join join = (Join) rel;
    for (RelNode input : join.getInputs()) {
        if (input.getConvention() != getOutTrait()) {
            input = convert(input, input.getTraitSet().replace(out));
        }
        newInputs.add(input);
    }
    try {
        JdbcJoin jdbcJoin = new JdbcJoin(join.getCluster(), join.getTraitSet().replace(out), newInputs.get(0), newInputs.get(1), join.getCondition(), join.getVariablesSet(), join.getJoinType());
        return jdbcJoin;
    } catch (InvalidRelException e) {
        return null;
    }
}

Example 24 with Join

use of org.apache.calcite.rel.core.Join in project flink by apache.

the class FlinkAggregateJoinTransposeRule method matches.

@Override
public boolean matches(RelOptRuleCall call) {
    // avoid push aggregates through dim join
    Join join = call.rel(1);
    RelNode right = join.getRight();
    // right tree should not contain temporal table
    return !containsSnapshot(right);
}

Example 25 with Join

use of org.apache.calcite.rel.core.Join in project flink by apache.

the class FlinkSemiAntiJoinProjectTransposeRule method onMatch.

// ~ Methods ----------------------------------------------------------------
public void onMatch(RelOptRuleCall call) {
    LogicalJoin join = call.rel(0);
    LogicalProject project = call.rel(1);
    // convert the semi/anti join condition to reflect the LHS with the project
    // pulled up
    RexNode newCondition = adjustCondition(project, join);
    Join newJoin = LogicalJoin.create(project.getInput(), join.getRight(), join.getHints(), newCondition, join.getVariablesSet(), join.getJoinType());
    // Create the new projection. Note that the projection expressions
    // are the same as the original because they only reference the LHS
    // of the semi/anti join and the semi/anti join only projects out the LHS
    final RelBuilder relBuilder = call.builder();
    relBuilder.push(newJoin);
    relBuilder.project(project.getProjects(), project.getRowType().getFieldNames());
    call.transformTo(relBuilder.build());
}