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