orientdb - Create Edges by ETL in same Class -
1) class items itemid , name ready in database. 2) csv-file: 2 columns,
itemid1,itemid2001  itemid1,itemid2345  itemid1,itemid2381 ...
itemid2,itemid8393  itemid2,itemid8743 .. etc.
question:
how define etl json-file create edges between itemid1 , itemid's in col#2, , between itemid2 , col#2-peers.
i tried reproduce problem.
i had items
and code connected them
{   "source": { "file": { "path": "mypath/item.csv" } },   "extractor": {"row": {}},     "transformers": [{         "csv": {             "separator": ","         }     },     {     "command" : {             "command" : "create edge (select item iditem= '${input.iditem1}') (select item iditem= '${input.iditem2}')",             "output" : "edge"         }     }   ],   "loader": {     "orientdb": {        "dburl": "plocal:mypath/mydb",        "dbtype": "graph"     }   } } and got
hope helps.


Comments
Post a Comment