1.0 - 8.00 - PSALSA Input - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)
Table Description
vertices Each row represents a vertex of the graph.
edges Each row represents an edge of the graph.
sources [Required for directed graph, optional for undirected graph.] Vertices to use as sources.

By default, all vertices are both sources and targets (that is, the graph is undirected).

targets [Required for directed graph, optional for undirected graph.] Vertices to use as targets.

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.

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_vertex_key_column Same as source_vertex_key_column Column appears once for each specified target_vertex_key_column.] All or part of key that identifies target vertex of edge. Must be a vertex_key_column in vertices table. Cannot 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.

targets Schema

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