Orhan Kislal created MADLIB-1253:
------------------------------------
Summary: Pagerank grouping does not give any output on complete
graphs
Key: MADLIB-1253
URL: https://issues.apache.org/jira/browse/MADLIB-1253
Project: Apache MADlib
Issue Type: Bug
Components: Module: Graph
Reporter: Orhan Kislal
If we use a completely connected graph with grouping, there is no output.
Non-grouping calls do not have this issue.
{code:java}
CREATE TABLE vertex(
id INTEGER
);
CREATE TABLE edge_full(
src INTEGER,
dest INTEGER,
user_id INTEGER
);
INSERT INTO vertex VALUES
(0),
(1),
(2);
INSERT INTO "EDGE" VALUES
(0, 1, 1),
(0, 2, 1),
(1, 2, 1),
(2, 1, 1),
(1, 0, 1),
(2, 0, 1);
DROP TABLE IF EXISTS pagerank_grp_out_summary, pagerank_grp_out;
SELECT pagerank(
'vertex', -- Vertex table
'id', -- Vertix id column
'edge_full', -- "EDGE" table
'src=src, dest=dest', -- "EDGE" args
'pagerank_grp_out', -- Output table of PageRank
NULL, -- Default damping factor (0.85)
NULL, -- Default max iters (100)
NULL, -- Default Threshold
'user_id');
{code}
{code:java}
select * from pagerank_grp_out;
user_id | id | pagerank
---------+----+----------
(0 rows)
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
