[
https://issues.apache.org/jira/browse/MADLIB-1137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16087799#comment-16087799
]
Frank McQuillan commented on MADLIB-1137:
-----------------------------------------
BFS has same problem
{code}
SELECT madlib.graph_bfs(
'vertex', -- Vertex table
NULL, -- Vertix id column (NULL means use
default naming)
'"Edge"', -- Edge table
NULL, -- Edge arguments (NULL means use
default naming)
3, -- Source vertex for BFS
'"OUT"'); -- Output table of nodes reachable
from source_vertex
InternalError: (psycopg2.InternalError) plpy.SPIError: syntax error at or near
"_summary" (plpython.c:4648)
LINE 2: CREATE TABLE "OUT"_summary (
^
QUERY:
CREATE TABLE "OUT"_summary (
vertex_table TEXT,
vertex_id TEXT,
edge_table TEXT,
edge_args TEXT,
source_vertex INTEGER,
out_table TEXT,
max_distance INTEGER,
directed BOOLEAN,
grouping_cols TEXT
)
CONTEXT: Traceback (most recent call last):
PL/Python function "graph_bfs", line 23, in <module>
return bfs.graph_bfs(**globals())
PL/Python function "graph_bfs", line 202, in graph_bfs
PL/Python function "graph_bfs"
[SQL: 'SELECT madlib.graph_bfs(\n \'vertex\', --
Vertex table\n NULL, -- Vertix id column (NULL
means use default naming)\n \'"Edge"\', -- Edge
table\n NULL, -- Edge arguments (NULL means
use default naming)\n 3, -- Source vertex
for BFS\n \'"OUT"\'); -- Output table of nodes
reachable from source_vertex\n -- Default values used
for the other arguments']
{code}
> APSP: Quoted output table name does not work
> --------------------------------------------
>
> Key: MADLIB-1137
> URL: https://issues.apache.org/jira/browse/MADLIB-1137
> Project: Apache MADlib
> Issue Type: Bug
> Components: Module: Graph
> Reporter: Rahul Iyer
> Assignee: Orhan Kislal
> Priority: Minor
> Fix For: v1.12
>
>
> Using the example doc:
> {code}
> SELECT madlib.graph_apsp(
> 'vertex', -- Vertex table
>
>
>
> 'id', -- Vertix id column (NULL means use default naming)
>
>
>
> 'edge', -- Edge table
>
>
>
> 'src=src_id, dest=dest_id, weight=edge_weight',
>
>
>
> '"OUT_APSP"'); -- Output table of shortest paths
> ERROR: spiexceptions.SyntaxError: syntax error at or near "_summary"
> LINE 1: CREATE TABLE "OUT_APSP"_summary (
> ^
> QUERY: CREATE TABLE "OUT_APSP"_summary (
> vertex_table TEXT,
> vertex_id TEXT,
> edge_table TEXT,
> edge_args TEXT,
> out_table TEXT,
> grouping_cols TEXT)
> CONTEXT: Traceback (most recent call last):
> PL/Python function "graph_apsp", line 23, in <module>
> return apsp.graph_apsp(**globals())
> PL/Python function "graph_apsp", line 171, in graph_apsp
> PL/Python function "graph_apsp"
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
