1.1 - 8.10 - AllPairsShortestPath Input - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
Table Description
Vertices Each row represents a vertex of the graph.
Edges Each row represents an edge of the graph.

For undirected graph, this table might have duplicate rows. Remove them, using code in Deleting Duplicate Edges Table Rows.

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.