[MADLIB-1137] Graph: Quoted output table name does not work for some modules

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: v1.12
• Component/s: Module: Graph
• Assignee: Unassigned
• Reporter: Rahul Iyer
• Created: 14/Jul/17 18:11
• Updated: 17/Aug/17 17:55
• Resolved: 26/Jul/17 22:09

Description

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:

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"