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/08/17 17:45:00 UTC
[jira] [Commented] (MADLIB-1137) Graph: Quoted output table name
does not work for some modules
[ https://issues.apache.org/jira/browse/MADLIB-1137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16130897#comment-16130897 ]
Frank McQuillan commented on MADLIB-1137:
-----------------------------------------
APSP
{code}
DROP TABLE IF EXISTS "OUT", "OUT_summary";
SELECT madlib.graph_apsp(
'vertex', -- Vertex table
NULL, -- Vertix id column (NULL means use default naming)
'edge', -- Edge table
NULL, -- Edge arguments (NULL means use default naming)
'"OUT"'); -- Output table of shortest paths
SELECT * FROM "OUT_summary";
{code}
produces
{code}
graph_apsp
------------
(1 row)
madlib=# SELECT * FROM "OUT_summary";
vertex_table | vertex_id | edge_table | edge_args | out_table | grouping_cols
--------------+-----------+------------+-----------+-----------+---------------
vertex | | edge | | "OUT" |
(1 row)
{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
> Priority: Minor
> Fix For: v1.12
>
>
> Summary
> Looks like it affects:
> * APSP
> * BFS
> * SSSP
> * PageRank
> Weakly connected components does not create a <out>_summary table so that one seems to work
> -------------------------
> APSP: 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)