PageRank Example - Teradata Vantage

Input

Input tables are from AllPairsShortestPath Example 1: Unweighted, Unbounded Graph:

• vertices: callers
• edges: calls

SQL Call

SELECT * FROM PageRank (
  ON callers AS vertices PARTITION BY callerid
  ON calls AS edges PARTITION BY callerfrom
  USING
  Targetkey ('callerto')
  EdgeWeight ('calls')
  Accumulate ('callerid', 'callername')
) AS dt ORDER BY callerid;

Output