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)
