nPath (version 1.0) - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
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}[,...])
);