Github user jingyimei commented on a diff in the pull request: https://github.com/apache/madlib/pull/244#discussion_r177915601 --- Diff: src/ports/postgres/modules/graph/pagerank.py_in --- @@ -647,6 +778,26 @@ SELECT * FROM pagerank_out ORDER BY user_id, pagerank DESC; -- View the summary table to find the number of iterations required for -- convergence for each group. SELECT * FROM pagerank_out_summary; + +-- Compute the Personalized PageRank: +DROP TABLE IF EXISTS pagerank_out, pagerank_out_summary; +SELECT madlib.pagerank( + 'vertex', -- Vertex table + 'id', -- Vertix id column + 'edge', -- Edge table + 'src=src, dest=dest', -- Comma delimted string of edge arguments + 'pagerank_out', -- Output table of PageRank + NULL, -- Default damping factor (0.85) + NULL, -- Default max iters (100) + NULL, -- Default Threshold + NULL, -- No Grouping --- End diff -- move those NULLs one space left
---