The function requires at least one partitioned input table, and can have additional input tables that are either partitioned or DIMENSION tables.
Column Name | 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. |
If the input to nPath is nondeterministic, the results are nondeterministic.