SQL-GR Call - 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
SELECT * FROM gTree (
  ON gtree_vertices AS vertices PARTITION BY nodeid, nodestring
  ON gtree_edges AS edges PARTITION BY nodeid, nodestring
  ON gtree_root AS root PARTITION BY nodeid, nodestring
  TargetKey ('endnodeid', 'endnodestring')
  AllowCycles ('t')
  MaxIterNum (10)
  Output ('all')
  Results (
    'Propagate (nodeid) AS start_vertex',
    'Current (nodeid) AS end_vertex',
    'Path (nodestring)',
    'Sum (value)',
    'Cycle()',
    'Leaf()'
  )
  EdgeResults ('PATH(nodestring, endnodestring) AS edgepath')
) ORDER BY 1,2,7;