The function requires at least one partitioned input table, and can have additional input tables that are either partitioned or DIMENSION tables.
If the input to nPath is nondeterministic, the results are nondeterministic. For more information, see Nondeterministic Results.
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 | Data to search for patterns. |