You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@madlib.apache.org by "Nandish Jayaram (JIRA)" <ji...@apache.org> on 2017/07/17 17:58:00 UTC
[jira] [Created] (MADLIB-1141) Graph - SSSP with empty string
grouping_col fails
Nandish Jayaram created MADLIB-1141:
---------------------------------------
Summary: 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
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)