byFunction Predicates Overview - Aster Execution Engine

Teradata Aster® Developer Guide

Product
Aster Execution Engine
Release Number
7.00.02
Published
July 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
xnl1494366523182.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
ffu1489104705746
lifecycle
previous
Product Category
Software

Only predicates marked with the flag 'isSimple' are eligible to be applied as byFunction. The Planner marks predicates that meet the following criteria as simple.

  • The predicate is of the form 'col op val' or 'col IS/IS NOT NULL', where col is a simple column reference and not an expression.
  • 'op' is one of the comparison operators '=','<','<=','>','>='.'!=','<>' and value is a simple constant.

The Planner may add other kinds of predicates as simple predicates in the future, so the 
SQL-MapReduce function should rely on the 'isSimple' flag rather than 'op' and 'value' to determine whether a predicate is a simple predicate. If the function classifies a predicate as byFunction, it needs to apply that predicate at execution time by calling the 'evaluate' method on that predicate for each row being output.