7.00.02 - nPath Syntax - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Version 1.0
SELECT * FROM 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 ] 
  ][...]
  Mode ({ OVERLAPPING | NONOVERLAPPING })
  Pattern ('pattern')
  Symbols ( { col_expr = symbol_predicate AS symbol} [,...])
  [ Filter (filter_expression[,...]) ]
  Result ({aggregate_function(col_expr OF symbol) AS alias}[,...])
);

The nPath function is not tied to any Aster Database schema and must not be qualified with a schema name.