7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

The function has two required input tables, vertices and edges. Each row of the vertices table represents a vertex of the graph, and each row of the edges table represents an edge of the graph.

The function has two optional input tables, sources and targets, which specify the vertices to use as sources and targets, respectively. For a directed graph, these tables are required. By default, all vertices are sources and targets; that is, the graph is undirected.

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

AllPairsShortestPath Vertices Table Schema
Column Name Data Type Description
vertex_key_column Any allowed in PARTITION BY clause Column that is, or is part of, the unique vertex key. Every column that is part of this key must appear in the PARTITION BY clause. This column cannot contain NULL values.
AllPairsShortestPath Edges Table Schema
Column Name Data Type Description
source_vertex_key_column Any allowed in PARTITION BY clause Column that is, or is part of, the key that identifies the source vertex of the edge. This key must be a vertex key in the vertices table. Every column that is part of this key must appear in the PARTITION BY clause. This column cannot contain NULL values.
target_vertex_key_column Same as data type of source_vertex_key_column Column that is, or is part of, the key that identifies the target vertex of the edge. This key must be a vertex key in the vertices table. This column can contain NULL values.
edge_weight SMALLINT, INTEGER, or NUMERIC Column that contains the weights of the edges, which must be positive values. This column is required only for a weighted graph. This column can contain NULL values.
AllPairsShortestPath Sources Table Schema
Column Name Data Type Description
source_vertex_key_column Same as data type of corresponding vertex_key_column in vertices table Column that is, or is part of, the key that identifies a source vertex. This key must be a vertex key in the vertices table. Every column that is part of this key must appear in the PARTITION BY clause.
AllPairsShortestPath Targets Table Schema
Column Name Data Type Description
target_vertex_key_column Same as data type of corresponding vertex_key_column in vertices table Column that is, or is part of, the key that identifies a target vertex. This key must be a vertex key in the vertices table. Every column that is part of this key must appear in the PARTITION BY clause.