nPath Input - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-02-17
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The function requires at least one partitioned input table, and can have additional input tables that are either partitioned or DIMENSION tables.

If an additional input table has CLOB columns, it cannot be a DIMENSION table. See nPath Results.
If the input to nPath is nondeterministic, the results are nondeterministic.

Input Table Schema

Column Data Type Description
partition_column INTEGER or VARCHAR Column by which every partitioned input table is partitioned.
order_column INTEGER or VARCHAR Column by which every input table is ordered.
input_column INTEGER or VARCHAR Contains data to search for patterns.