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.
