age icon indicating copy to clipboard operation
age copied to clipboard

Loading the CSV Files by Functions is so difficult and inconvenient.

Open beamrock opened this issue 1 year ago • 0 comments

Is your feature request related to a problem? Please describe.

In the table below, there are many constraints to run the function normally. And the source file constraints for creating Edge are unrealistic.

image

Describe the solution you'd like A clear and concise description of what you want to happen.

Using the clause Load ~ Match ~ CREATE/MERGE of neo4j or agensgraph is the best.

on Neo4j By CSV Files

LOAD CSV WITH HEADERS FROM  'file:///static/tag_hasType_tagclass_0_0.csv' as row FIELDTERMINATOR '|'  
MATCH (r:tag{id:row.`Tag.id`}), (s:tagclass{id:row.`TagClass.id`}) 
CREATE (r) - [e:hastype] -> (s);

on AgensGraph By RDB Table

LOAD FROM forum_containerOf_post as row
 MATCH (r:Forum{id:row.forumId}), (s:Post{id:row.postId})
CREATE (r) - [e:ContainerOf] -> (s);

beamrock avatar May 24 '23 07:05 beamrock