Version 1.1
This function requires "@coprocessor".
SELECT * FROM nPath@coprocessor ( 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 (col_expr OF symbol) AS alias_1 }[,...]) ) AS alias_2;
The nPath function is not tied to any schema and must not be qualified with a schema name.