1.0 - 8.00 - AllPairsShortestPath Example 3: Weighted, Bounded Graph with Sources - 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)

SQL Call

SELECT * FROM AllPairsShortestPath (
  ON callers AS vertices PARTITION BY callerid
  ON calls AS edges PARTITION BY callerfrom
  ON (SELECT callerid FROM callers
    WHERE callerid IN (1, 2)) AS sources PARTITION BY callerid
  USING
  TargetKey ('callerto')
  MaxDistance (8)
  EdgeWeight ('calls')
) AS dt ORDER BY source, target;

Output

source target distance
1 3 2
1 4 5
1 6 3
2 4 7