org.apache.calcite.rel.metadata.RelMdUtil.computeSemiJoinSelectivity java code examples

Add the Codota plugin to your IDE and get smart completions

private void myMethod () {
 Point p =new Point(x, y)
new Point()
MouseEvent e;e.getPoint()
Smart code suggestions by Tabnine
}

/**
 * Computes the selectivity of a semijoin filter if it is applied on a fact
 * table. The computation is based on the selectivity of the dimension
 * table/columns and the number of distinct values in the fact table
 * columns.
 *
 * @param factRel fact table participating in the semijoin
 * @param dimRel  dimension table participating in the semijoin
 * @param rel     semijoin rel
 * @return calculated selectivity
 */
public static double computeSemiJoinSelectivity(RelMetadataQuery mq,
  RelNode factRel, RelNode dimRel, SemiJoin rel) {
 return computeSemiJoinSelectivity(mq, factRel, dimRel, rel.getLeftKeys(),
   rel.getRightKeys());
}

/**
 * Computes the selectivity of a semijoin filter if it is applied on a fact
 * table. The computation is based on the selectivity of the dimension
 * table/columns and the number of distinct values in the fact table
 * columns.
 *
 * @param factRel fact table participating in the semijoin
 * @param dimRel  dimension table participating in the semijoin
 * @param rel     semijoin rel
 * @return calculated selectivity
 */
public static double computeSemiJoinSelectivity(RelMetadataQuery mq,
  RelNode factRel, RelNode dimRel, SemiJoin rel) {
 return computeSemiJoinSelectivity(mq, factRel, dimRel, rel.getLeftKeys(),
   rel.getRightKeys());
}

/**
 * Computes the selectivity of a semijoin filter if it is applied on a fact
 * table. The computation is based on the selectivity of the dimension
 * table/columns and the number of distinct values in the fact table
 * columns.
 *
 * @param rel semijoin rel
 * @return calculated selectivity
 */
public static double computeSemiJoinSelectivity(RelMetadataQuery mq,
  SemiJoin rel) {
 return computeSemiJoinSelectivity(mq, rel.getLeft(), rel.getRight(),
   rel.getLeftKeys(), rel.getRightKeys());
}

/**
 * Computes the selectivity of a semijoin filter if it is applied on a fact
 * table. The computation is based on the selectivity of the dimension
 * table/columns and the number of distinct values in the fact table
 * columns.
 *
 * @param rel semijoin rel
 * @return calculated selectivity
 */
public static double computeSemiJoinSelectivity(RelMetadataQuery mq,
  SemiJoin rel) {
 return computeSemiJoinSelectivity(mq, rel.getLeft(), rel.getRight(),
   rel.getLeftKeys(), rel.getRightKeys());
}

/**
 * Creates a RexNode that stores a selectivity value corresponding to the
 * selectivity of a semijoin. This can be added to a filter to simulate the
 * effect of the semijoin during costing, but should never appear in a real
 * plan since it has no physical implementation.
 *
 * @param rel the semijoin of interest
 * @return constructed rexnode
 */
public static RexNode makeSemiJoinSelectivityRexNode(RelMetadataQuery mq,
  SemiJoin rel) {
 RexBuilder rexBuilder = rel.getCluster().getRexBuilder();
 double selectivity =
   computeSemiJoinSelectivity(mq, rel.getLeft(), rel.getRight(), rel);
 return rexBuilder.makeCall(ARTIFICIAL_SELECTIVITY_FUNC,
   rexBuilder.makeApproxLiteral(new BigDecimal(selectivity)));
}

/**
 * Creates a RexNode that stores a selectivity value corresponding to the
 * selectivity of a semijoin. This can be added to a filter to simulate the
 * effect of the semijoin during costing, but should never appear in a real
 * plan since it has no physical implementation.
 *
 * @param rel the semijoin of interest
 * @return constructed rexnode
 */
public static RexNode makeSemiJoinSelectivityRexNode(RelMetadataQuery mq,
  SemiJoin rel) {
 RexBuilder rexBuilder = rel.getCluster().getRexBuilder();
 double selectivity =
   computeSemiJoinSelectivity(mq, rel.getLeft(), rel.getRight(), rel);
 return rexBuilder.makeCall(ARTIFICIAL_SELECTIVITY_FUNC,
   rexBuilder.makeApproxLiteral(new BigDecimal(selectivity)));
}

  RelMdUtil.computeSemiJoinSelectivity(mq, factRel, dimRel, semiJoin);
if (selectivity > .5) {
 return 0;

  RelMdUtil.computeSemiJoinSelectivity(mq, factRel, dimRel, semiJoin);
if (selectivity > .5) {
 return 0;

Javadoc

Computes the selectivity of a semijoin filter if it is applied on a fact table. The computation is based on the selectivity of the dimension table/columns and the number of distinct values in the fact table columns.

Popular methods of RelMdUtil

guessSelectivity
Returns default estimates for selectivities, in the absence of stats.
areColumnsDefinitelyUnique
Returns true if the columns represented in a bit mask are definitely known to form a unique column s
areColumnsDefinitelyUniqueWhenNullsFiltered
Returns true if the columns represented in a bit mask are definitely known to form a unique column s
getJoinDistinctRowCount
Computes the number of distinct rows for a set of keys returned from a join. Also known as NDV (numb
minusPreds
Takes the difference between two predicates, removing from the first any predicates also in the seco
estimateFilteredRows
linear
Returns a point on a line.The result is always a value between minY and maxY, even if x is not betwe
getJoinRowCount
Returns an estimate of the number of rows returned by a Join.
areColumnsUnique
areColumnsUniqueWhenNullsFiltered
capInfinity
Caps a double value at Double.MAX_VALUE if it's currently infinity
cardOfProjExpr
Computes the cardinality of a particular expression from the projection list.

Popular in Java

Creating JSON documents from java classes using gson
onCreateOptionsMenu (Activity)
scheduleAtFixedRate (Timer)
startActivity (Activity)
HttpServer (com.sun.net.httpserver)
This class implements a simple HTTP server. A HttpServer is bound to an IP address and port number a
Container (java.awt)
A generic Abstract Window Toolkit(AWT) container object is a component that can contain other AWT co
Comparator (java.util)
A Comparator is used to compare two objects to determine their ordering with respect to each other.
Timer (java.util)
Timers schedule one-shot or recurring TimerTask for execution. Prefer java.util.concurrent.Scheduled
Stream (java.util.stream)
A sequence of elements supporting sequential and parallel aggregate operations. The following exampl
Annotation (javassist.bytecode.annotation)
The annotation structure.An instance of this class is returned bygetAnnotations() in AnnotationsAttr
Top plugins for WebStorm

How to use computeSemiJoinSelectivitymethodin org.apache.calcite.rel.metadata.RelMdUtil

Best Java code snippets using org.apache.calcite.rel.metadata.RelMdUtil.computeSemiJoinSelectivity (Showing top 8 results out of 315)

How to use
computeSemiJoinSelectivity
method
in
org.apache.calcite.rel.metadata.RelMdUtil