nPath Syntax - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software
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.