nPath ( ON { table | view | (query) } PARTITION BY partition_column ORDER BY order_column [ ASC | DESC ][...] [ ON { table | view | (query) } [ PARTITION BY partition_column | DIMENSION ] ORDER BY order_column [ ASC | DESC ] ][...] USING Mode ({ OVERLAPPING | NONOVERLAPPING }) Pattern ('pattern') Symbols ({ col_expr = symbol_predicate AS symbol}[,...]) [ Filter (filter_expression[,...]) ] Result ({ aggregate_function (expression OF [ANY] symbol [,...]) AS alias_1 }[,...]) )
You can call this function from:
- The FROM clause of a SELECT statement
- As part of a CREATE TABLE statement
- As part of a CREATE VIEW statement