Input
Input tables are from AllPairsShortestPath Example: 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
callerid callername pagerank -------- ---------- ------------------- 1 john 0.08901149252559355 2 carla 0.12265780532507689 3 simon 0.09574075508549022 4 celine 0.14442118900896703 5 winston 0.08901149252559355 6 diana 0.4591572655292789
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.