I have a very similar problem. I have two csv files - one that has user
data in the format "id, nam", and the other has friends data with format
"fromId, toId". I have already run the vertext create ETL to create User
vertices from the first CSV file. How do I only create edges between the
created vertices, using edge ETL?
On Tuesday, June 30, 2015 at 1:48:47 PM UTC-7, Keyu Wang wrote:
>
> Hi David,
>
> I have the same issue and need your help. Have you solved the edge import
> problem? Maybe you can give me some advise. I am completely new with
> OrientDB and can not go further with the example from the office docs to
> get a solution.
>
> Thanks,
>
>
>
> On Thursday, January 29, 2015 at 4:54:23 PM UTC+1, David Sedeño wrote:
>>
>> Hi Emin,
>>
>> Could you solve your problem? I have similar issue, how to get an
>> orientdocument and create an edge to another one (both just inserted
>> previously into orientdb).
>>
>> Thanks
>> ---
>> David Sedeño
>>
>> El martes, 9 de diciembre de 2014, 4:34:42 (UTC+1), Emin Agassi escribió:
>>>
>>> Hello Lvc,
>>>
>>> Thank you for your reply. I did look at the CSV to Graph load example
>>> however my use case is a bit different.
>>> Currently, I have the ETL Json file that loads all Vertexes from one
>>> RDBMS table.
>>> Second, I have the table that contains relationships between the
>>> concepts.
>>> Basically, I have a graph stored in RDBMS. I am trying to load this
>>> graph into OrientDB.
>>> The first ETL is very fast. I can load 1.5 million records into OrientDB
>>> Vertexes in 8 minutes.
>>>
>>> I am not sure how to load Edges, the relationships between Vertexes
>>> which I have loaded from a separate table.
>>> I tried this:
>>>
>>> "transformers" : [
>>> {
>>> "command" : {
>>> "command" : "create edge from (select flatten(@rid) from V where
>>> Id = ${input.c1}) to (select flatten(@rid) from V where Id = ${input.c2})",
>>> "output" : "edge"
>>> }
>>> }
>>> ],
>>>
>>> where c1 and c2 are Ids of left and right concepts in the relationships
>>> respectively. However, this ETL ran for more than 1 hour and finally failed
>>> OutOfMemory.
>>> Again, my use case is different from CSV in that I have:
>>>
>>> Table1
>>> Id Name
>>> 1 Bob
>>> 2 Mary
>>> 3 Ken
>>>
>>> Table2
>>> Id1 Rel Id2
>>> 1 MarriedTo 2
>>> 1 hasSon 3
>>> 2 hasSon 3
>>> 3 hasParents 1
>>> 3 hasParents 2
>>>
>>> Thanks for help
>>> Emin
>>>
>>>
>>>
>>> On Monday, December 8, 2014 3:19:46 PM UTC-5, Lvc@ wrote:
>>>>
>>>> Hi Emin,
>>>> Take a look at this guide:
>>>>
>>>>
>>>> http://www.orientechnologies.com/docs/last/orientdb-etl.wiki/Import-from-CSV-to-a-Graph.html
>>>>
>>>> Lvc@
>>>>
>>>>
>>>> On 8 December 2014 at 19:06, Emin Agassi <[email protected]> wrote:
>>>>
>>>>>
>>>>> Hi All,
>>>>>
>>>>> I am using the OrientDb community version 2.0 M3.
>>>>>
>>>>> I am importing data from RDBMS using the new ETL process.
>>>>> I have a JSON etl file to first import all concepts from table A.
>>>>> Then, I have a JSON etl file to import Edges from the table B. Table
>>>>> B contains triplets: Concept1 Id - RelTo - Concept2 Id.
>>>>>
>>>>> I cannot figure out how to create Edges using ETL and from my Table B
>>>>> that contains all relationships between concepts.
>>>>>
>>>>> Any help is appreciated!
>>>>>
>>>>> --
>>>>>
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "OrientDB" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to [email protected].
>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>
>>>>
>>>>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
