[ https://issues.apache.org/jira/browse/MADLIB-1137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16087855#comment-16087855 ]
Frank McQuillan commented on MADLIB-1137: ----------------------------------------- SSSP too {code} 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 InternalError: (psycopg2.InternalError) plpy.SPIError: syntax error at or near "_summary" (plpython.c:4648) LINE 1: 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, grouping_cols TEXT) 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 162, in graph_sssp PL/Python function "graph_sssp" [SQL: 'SELECT madlib.graph_sssp(\n \'vertex\', -- Vertex table\n NULL, -- Vertex id column (NULL means use default naming)\n \'edge\', -- Edge table\n NULL, -- Edge arguments (NULL means use default naming)\n 0, -- Source vertex for path calculation\n \'"Out"\'); -- Output table of shortest paths'] {code} > Graph: Quoted output table name does not work for some modules > -------------------------------------------------------------- > > 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)