7.00.02 - Input - 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

The gTree function has three required input tables:

  • vertices, which defines the set of vertices in the graph
  • edges, which defines the set of edges in the graph
  • root, which defines the set of root vertices from which the function starts traversing the graph
gTree Vertices Table Schema
Column Name Data Type Description
nodeid INTEGER Numerical ID of the vertex.
nodestring VARCHAR Name of the vertex.
value SQL numeric data type Value of the vertex.
gTree Edges Table Schema
Column Name Data Type Description
nodeid INTEGER Numerical ID of the vertex at which the edge starts (the source node of the edge).
nodestring VARCHAR Name of the vertex at which the edge starts.
endnodeid SQL numeric data type Numerical ID of the vertex at which the edge ends (the target node of the edge).
endnodestring VARCHAR Name of the vertex at which the edge ends.
gTree Root Table Schema
Column Name Data Type Description
nodeid INTEGER Numerical ID of the root vertex.
nodestring VARCHAR Name of the root vertex.
value SQL numeric data type Value of the root vertex.