You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@madlib.apache.org by "Frank McQuillan (JIRA)" <ji...@apache.org> on 2017/07/17 18:39:00 UTC
[jira] [Commented] (MADLIB-1141) Graph - SSSP with empty string
grouping_col fails
[ https://issues.apache.org/jira/browse/MADLIB-1141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16090305#comment-16090305 ]
Frank McQuillan commented on MADLIB-1141:
-----------------------------------------
Please check other graph modules as well .
> 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)