[
https://issues.apache.org/jira/browse/MADLIB-1253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jingyi Mei updated MADLIB-1253:
-------------------------------
Description:
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}
was:
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}
> 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)
