Package org.teiid.query.sql.lang

Examples of org.teiid.query.sql.lang.Criteria

255
256
257
258
259
260
261
262
263
264
265
     * TODO: it would be good to have a hint to force
     */
  private PlanNode planMergeJoin(PlanNode current, PlanNode root, AnalysisRecord analysisRecord) throws QueryMetadataException,
      TeiidComponentException {
    float sourceCost = NewCalculateCostUtil.computeCostForTree(current.getFirstChild(), metadata);
    Criteria crit = (Criteria)current.getProperty(NodeConstants.Info.SELECT_CRITERIA);
   
    PlannedResult plannedResult = findSubquery(crit);
    if (plannedResult.query == null) {
      return current;
    }
View Full Code Here
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
    Set<SingleElementSymbol> requiredExpressions = new LinkedHashSet<SingleElementSymbol>();
    final SymbolMap refs = plannedResult.query.getCorrelatedReferences();
    boolean addGroupBy = false;
    if (refs != null) {
      boolean hasAggregates = plannedResult.query.hasAggregates();
      Criteria where = plannedResult.query.getCriteria();
      if (plannedResult.query.getGroupBy() == null) {
        plannedResult.query.setCriteria(null);
      }
      Criteria having = plannedResult.query.getHaving();
      plannedResult.query.setHaving(null);
      if (hasCorrelatedReferences(plannedResult.query, refs)) {
        return false;
      }
      if (plannedResult.query.getGroupBy() == null) {
View Full Code Here
560
561
562
563
564
565
566
567
568
569
570
      return;
    }
    List<Criteria> crits = Criteria.separateCriteriaByAnd((Criteria)joinCriteria.clone());

    for (Iterator<Criteria> critIter = crits.iterator(); critIter.hasNext();) {
      Criteria conjunct = critIter.next();
      List<SingleElementSymbol> aggregates = new LinkedList<SingleElementSymbol>();
      List<SingleElementSymbol> elements = new LinkedList<SingleElementSymbol>();
      AggregateSymbolCollectorVisitor.getAggregates(conjunct, aggregates, elements);
      ReferenceReplacementVisitor emv = new ReferenceReplacementVisitor(refs);
      DeepPostOrderNavigator.doVisit(conjunct, emv);
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
     */
    private void validateAccessPatterns(PlanNode node) throws QueryPlannerException {
        if (!node.hasCollectionProperty(NodeConstants.Info.ACCESS_PATTERNS)) {
            return;
        }
        Criteria criteria = null;
        if(node.hasProperty(NodeConstants.Info.ATOMIC_REQUEST) ) {
            Object req = node.getProperty(NodeConstants.Info.ATOMIC_REQUEST);
            if(req instanceof Insert) {
                return;
            }
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
        if ((joinType == JoinType.JOIN_LEFT_OUTER || joinType == JoinType.JOIN_RIGHT_OUTER)
                        && outerGroups.containsAll(critNode.getGroups())) {
            return null;
        }
       
        Criteria crit = (Criteria)critNode.getProperty(NodeConstants.Info.SELECT_CRITERIA);

        boolean isNullDepdendent = isNullDependent(metadata, innerGroups, crit);
       
        JoinType result = JoinType.JOIN_INNER;
       
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
147
148
149
     *  given all null values for elements in the inner groups
     */
    public static boolean isNullDependent(QueryMetadataInterface metadata,
                                            final Collection<GroupSymbol> innerGroups,
                                            Criteria crit) {
        Criteria simplifiedCrit = (Criteria)replaceWithNullValues(innerGroups, crit);
        try {
            simplifiedCrit = QueryRewriter.rewriteCriteria(simplifiedCrit, null, null, metadata);
        } catch (TeiidException err) {
            //log the exception
            return true;
        }
        return !(simplifiedCrit.equals(QueryRewriter.FALSE_CRITERIA) || simplifiedCrit.equals(QueryRewriter.UNKNOWN_CRITERIA));
    }
View Full Code Here
184
185
186
187
188
189
190
191
192
193
        assertEquals("Parse string does not match: ", expectedString, actualString); //$NON-NLS-1$
        assertEquals("CriteriaSelector does not match: ", expectedSelector, actualSelector);              //$NON-NLS-1$
    }
 
    private void helpCriteriaTest(String crit, String expectedString, Criteria expectedCrit) throws QueryParserException {
        Criteria actualCrit = QueryParser.getQueryParser().parseCriteria(crit);
        String actualString = actualCrit.toString();
        assertEquals("Parse string does not match: ", expectedString, actualString); //$NON-NLS-1$
        assertEquals("Criteria does not match: ", expectedCrit, actualCrit);              //$NON-NLS-1$
    }
View Full Code Here
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
    select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
   
    GroupBy groupBy = new GroupBy();
    groupBy.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
   
    Criteria having = new CompareCriteria(
      new AggregateSymbol("count", "COUNT", false, new ElementSymbol("b", false)), //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
      CompareCriteria.GT,
      new Constant(new Integer(0)) );
       
    Query query = new Query();
View Full Code Here
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
        Select select = new Select();
        ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
        select.addSymbol(a);

        Criteria crit = new IsNullCriteria(a);

        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);
View Full Code Here
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
    Select select = new Select();
    ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
    select.addSymbol(a);

    Criteria crit = new NotCriteria(new IsNullCriteria(a));

    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setCriteria(crit);
View Full Code Here
TOP

Related Classes of org.teiid.query.sql.lang.Criteria

  • org.teiid.dqp.internal.datamgr.LanguageBridgeFactory
  • org.teiid.query.eval.Evaluator
  • org.teiid.query.optimizer.relational.PlanToProcessConverter
  • org.teiid.query.optimizer.relational.plantree.PlanNode
  • org.teiid.query.optimizer.relational.rules.FrameUtil
  • org.teiid.query.optimizer.relational.rules.JoinRegion
  • org.teiid.query.optimizer.relational.rules.JoinUtil
  • org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil
  • org.teiid.query.optimizer.relational.rules.RuleAccessPatternValidation
  • org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.