7.00.02 - SQL-GR Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
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 ('end') 
  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;