beamrock opened a new issue, #946:
URL: https://github.com/apache/age/issues/946
**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.
<html>
<body>
<!--StartFragment--><google-sheets-html-origin><style type="text/css"><!--td
{border: 1px solid #cccccc;}br {mso-data-placement:same-cell;}--></style>
Load Vertex | | | | Result
-- | -- | -- | -- | --
동작여부 | 구분 | RawData(CSV) | Operations | age11
Y | 사전작업 | SET search_path = ag_catalog, "$user", public,
'movie_graph';SELECT drop_graph('movie_graph',true);SELECT
create_graph('movie_graph');SELECT drop_label('movie_graph','person');SELECT
create_vlabel('movie_graph','person'); | -
N | 딜리미터 ,head Yid컬럼 N | name,born Keanu Reeves,1964 Carrie-Anne Moss,1967
Laurence Fishburne,1961 | select load_labels_from_file('movie_graph', 'person',
'/Data2/MOVIE/person_with_head.csv'); | ERROR: entry_id must be 1 ..
281474976710655
Y | param false 딜리미터 ,head Yid컬럼 N | name,born Keanu Reeves,1964 Carrie-Anne
Moss,1967 Laurence Fishburne,1961 | select load_labels_from_file('movie_graph',
'person', '/Data2/MOVIE/person_with_head.csv',false); | {"id": 844424930131969,
"label": "person", "properties": {"born": "1964", "name": "Keanu Reeves",
"__id__": 1}}::vertex {"id": 844424930131970, "label": "person", "properties":
{"born": "1967", "name": "Carrie-Anne Moss", "__id__": 2}}::vertex {"id":
844424930131971, "label": "person", "properties": {"born": "1961", "name":
"Laurence Fishburne", "__id__": 3}}::vertex
Y | 딜리미터 ,head Yid컬럼 Y | id,name,born 1,Keanu Reeves,1964 2,Carrie-Anne
Moss,1967 3,Laurence Fishburne,1961 | select
load_labels_from_file('movie_graph', 'person',
'/Data2/MOVIE/person_headY_idY.csv'); | {"id": 844424930131969, "label":
"person", "properties": {"born": "1964", "name": "Keanu Reeves", "__id__":
1}}::vertex {"id": 844424930131970, "label": "person", "properties": {"born":
"1967", "name": "Carrie-Anne Moss", "__id__": 2}}::vertex {"id":
844424930131971, "label": "person", "properties": {"born": "1961", "name":
"Laurence Fishburne", "__id__": 3}}::vertex
N | 딜리미터 ,head Nid컬럼 Y | 1,Keanu Reeves,1964 2,Carrie-Anne Moss,1967
3,Laurence Fishburne,1961 | select load_labels_from_file('movie_graph',
'person', '/Data2/MOVIE/person_with_id.csv'); | {"id": 844424930131970,
"label": "person", "properties": {"1": "2", "1964": "1967", "__id__": 2, "Keanu
Reeves": "Carrie-Anne Moss"}}::vertex {"id": 844424930131971, "label":
"person", "properties": {"1": "3", "1964": "1961", "__id__": 3, "Keanu Reeves":
"Laurence Fishburne"}}::vertex {"id": 844424930131972, "label": "person",
"properties": {"1": "4", "1964": "1960", "__id__": 4, "Keanu Reeves": "Hugo
Weaving"}}::vertex
Y | 딜리미터 ,head Yseq Y | seq,name,born1,Keanu Reeves,19642,Carrie-Anne
Moss,19673,Laurence Fishburne,1961 | select
load_labels_from_file('movie_graph', 'person',
'/Data2/MOVIE/person_headY_seqY.csv'); | {"id": 844424930131969, "label":
"person", "properties": {"seq": "1", "born": "1964", "name": "Keanu Reeves",
"__id__": 1}}::vertex {"id": 844424930131970, "label": "person", "properties":
{"seq": "2", "born": "1967", "name": "Carrie-Anne Moss", "__id__": 2}}::vertex
{"id": 844424930131971, "label": "person", "properties": {"seq": "3", "born":
"1961", "name": "Laurence Fishburne", "__id__": 3}}::vertex
N | 딜리미터 ,head Nid컬럼 Last | name,born,id Keanu Reeves,1964,1 Carrie-Anne
Moss,1967,2 Laurence Fishburne,1961,3 | select
load_labels_from_file('movie_graph', 'person',
'/Data2/MOVIE/person_with_head_idLast.csv'); | ERROR: entry_id must be 1 ..
281474976710655
N | 딜리미터 \|head Yid컬럼 Y | id\|name\|born 1\|Keanu Reeves\|1964
2\|Carrie-Anne Moss\|1967 3\|Laurence Fishburne\|196 | select
load_labels_from_file('movie_graph', 'person',
'/Data2/MOVIE/person_headY_idY_delPIPE.csv'); | {"id": 844424930131969,
"label": "person", "properties": {"__id__": 1, "id\|name\|born": "1\|Keanu
Reeves\|1964"}}::vertex {"id": 844424930131970, "label": "person",
"properties": {"__id__": 2, "id\|name\|born": "2\|Carrie-Anne
Moss\|1967"}}::vertex {"id": 844424930131971, "label": "person", "properties":
{"__id__": 3, "id\|name\|born": "3\|Laurence Fishburne\|1961"}}::vertex
Y | 결과확인 | select * FROM cypher('movie_graph', $ MATCH (v:person) RETURN v
limit 3 $) as (v agtype) ; |
<!--EndFragment-->
</body>
</html>
**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);
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
