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. |