[
https://issues.apache.org/jira/browse/MADLIB-1141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16130933#comment-16130933
]
Frank McQuillan commented on MADLIB-1141:
-----------------------------------------
this seems to work now
{code}
DROP TABLE IF EXISTS out, out_summary;
SELECT madlib.graph_sssp(
'vertex', -- Vertex table
NULL, -- Vertex id column (NULL means use
default naming)
'edge', -- Edge table
NULL, -- Edge arguments (NULL means use
default naming)
0, -- Source vertex for path calculation
'out', -- Output table of shortest paths
'');
{code}
prodces
{code}
id | weight | parent
----+--------+--------
0 | 0 | 0
2 | 1 | 0
4 | 10 | 0
6 | 3 | 5
1 | 1 | 0
3 | 2 | 2
5 | 2 | 2
7 | 4 | 6
(8 rows)
{code}
> Graph - SSSP with empty string grouping_col fails
> -------------------------------------------------
>
> Key: MADLIB-1141
> URL: https://issues.apache.org/jira/browse/MADLIB-1141
> Project: Apache MADlib
> Issue Type: Bug
> Components: Module: Graph
> Reporter: Nandish Jayaram
> Priority: Minor
> Fix For: v1.12
>
>
> Using the dataset provided in Graph SSSP's user doc page, the following query
> results in an error:
> {code}
> SELECT madlib.graph_sssp(
>
> 'vertex', -- Vertex table
>
> NULL,
> -- Vertix id column (NULL means use default naming)
>
> 'edge', -- Edge table
>
> NULL, -- Edge arguments (NULL
> means use default naming)
> 0,
> -- Source vertex for path calculation
>
> 'out',
> '' -- empty grouping_col);
> {code}
> The error is:
> {code}
> ERROR: spiexceptions.SyntaxError: syntax error at or near ","
> LINE 2: , src AS id, weight,
> ^
> QUERY: CREATE TABLE out AS (SELECT
> , src AS id, weight,
> src AS parent FROM edge LIMIT 0)
> CONTEXT: Traceback (most recent call last):
> PL/Python function "graph_sssp", line 23, in <module>
> return sssp.graph_sssp(**globals())
> PL/Python function "graph_sssp", line 151, in graph_sssp
> PL/Python function "graph_sssp"
> {code}
> Empty grouping_col string must be treated the same as a NULL.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
