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.
