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.