1.1 - 8.10 - AllPairsShortestPath Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
Release Date
October 2019
Content Type
Programming Reference
Publication ID
English (United States)
Specify the target key (the names of the Edges table columns that identify the target vertex). If you specify targets_table, the function uses only the vertices in targets_table as targets (which must be a subset of those that this syntax element specifies).
[Optional] Specify the name of the Edges table column that contains edge weights. Each edge_weight is a positive value.
Default: Each edge_weight is 1 (that is, the graph is unweighted)
[Optional] Specify whether the graph is directed.
Default: 'true'
[Optional] Specify the maximum distance between source and target for which the function outputs the vertices. The max_distance must be an integer. If max_distance is negative, the distance between source and target is unbounded.
Default: 10
[Optional] Specify the number of source vertices that run a single-node shortest path (SNSP) algorithm in parallel. If group_size exceeds the number of source vertices in a partition, the number of source vertices in the partition is the group size.
Default behavior: The function uses cluster and query characteristics to determine the optimal group size.