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

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.