1.0 - 8.00 - nPath Filters - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

The Filter argument specifies filters to impose on the matched rows. Filtering out most matches can improve performance, but memory fragmentation can degrade it. Memory fragmentation can occur in these cases:

  • The mode is NONOVERLAPPING and the pattern includes the end anchor operator ($) but not the start anchor operator (^).
  • The mode is OVERLAPPING and the pattern does not include the start anchor operator.
  • The first symbol in the pattern can match an infinite number of input rows.
  • The data partition is huge.
  • The Java Virtual Machine (JVM) is too small.

If nPath runs much slower with the Filter argument, increase the size of the JVM. If the problem persists, alter the pattern.