Modularity Input - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢
Table Description
Vertices Each row represents a vertex of the graph.
Edges Each row represents an edge of the graph.
Sources [Optional] Specifies vertices to use as sources. This table is a subset of the Vertices table. If you specify this table, the function uses only the nodes in this table as sources.

Vertices Schema

Column Data Type Description
vertex_key_column Any allowed in PARTITION BY clause [Column appears once for each specified vertex_key_column.] All or part of unique vertex key. Cannot be NULL.
accumulate_column Any [Column appears once for each specified accumulate_column.] Column to copy to community Vertices table.

Edges Schema

Column Data Type Description
source_vertex_key_column Any allowed in PARTITION BY clause Column appears once for each specified source_vertex_key_column.] All or part of key that identifies source vertex of edge. Must be a vertex_key_column in Vertices table. Cannot be NULL.
target_key_column Same as source_vertex_key_column Column appears once for each specified target_key_column.] All or part of key that identifies target vertex of edge. Must be a vertex_key_column in Vertices table. Can be NULL.
edge_weight SMALLINT, INTEGER, or NUMERIC [Required only for weighted graph.] Edge weight, a positive value. Can be NULL.

Sources Schema

Column Data Type Description
source_vertex_key_column Same as corresponding vertex_key_column in Vertices table Column appears once for each specified source_vertex_key_column.] All or part of key that identifies source vertex of edge. Must be a vertex_key_column in Vertices table. Cannot be NULL.