[
https://issues.apache.org/jira/browse/MADLIB-1253?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16547147#comment-16547147
]
Frank McQuillan commented on MADLIB-1253:
-----------------------------------------
Table is no longer empty for completely connected graph with grouping:
{code}
user_id | id | pagerank
---------+----+-------------------
1 | 0 | 0.333333333333333
1 | 2 | 0.333333333333333
1 | 1 | 0.333333333333333
(3 rows)
{code}
LGTM
> 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
> Priority: Major
> Fix For: v1.15
>
>
> 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_full 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)
