Would Luca or anyone with Bulk Insert experience be able to comment on our issue, please? Our inability to bulk insert multiple records is stopping us on our tracks
Thank you, Sandro On Saturday, February 15, 2014 9:14:04 AM UTC-8, Sandro wrote: > > Hello, > > We love the concept of OrientDB, however have been struggling with > uploading our graph data (with a massiveinsert operation). > > *Background* > > We would like to migrate OrientDB away from an RDBMS. In RDBMS, we had 3 > tables: Person, School, and Education. We successfully imported data from > these three tables into OrientDB, however are struggling with linking them > together by with creating (Person <-- [Education] --> School) edges in > OrientDB. > > Here are details of the original RDBMS tables: > > *Person:* > > Fields: Id (int), Name (string) > > Record Count: 28M > > *School:* > > Fields: Id (int), Name (string) > > Record Count: 7M > > *Education:* > > Fields: Id (int), PersonId_FK, SchoolId_FK > > Record Count: 35M > > > > > *OrientDB release?* > > orientdb-community-1.7-rc2-SNAPSHOT > > > *What steps will reproduce the problem?* > 1. We followed the tutorial > https://github.com/orientechnologies/orientdb/wiki/Import-From-RDBMS > > > connect remote:localhost/db admin admin > > DECLARE INTENT massiveinsert > > DROP CLASS Person > CREATE CLASS Person > > DROP CLASS School > CREATE CLASS School > > DROP CLASS Education > CREATE CLASS Education > > INSERT INTO Person(Id, Name) > VALUES (1, 'John Doe') > .. > INSERT INTO School(Id, Name) > VALUES (1, 'State University') > .. > INSERT INTO Education(Id, PersonId, SchoolId) > VALUES (1, 1, 1) > ... > *>>Successfully imported all Person, School, and Education records in > respective OrientDB classes!* > > > 2. After successfully loading the raw data in OrientDB Classes, we are > unable to create Edge links in bulk. > > > CREATE LINK schools TYPE linkset FROM Education.PersonId To Person.id > INVERSE > > *>> Created 0 link(s) in 342.528992 sec(s).* > CREATE LINK students TYPE linkset FROM Education.SchoolId To School.id > INVERSE > > *>> Created 0 link(s) in 348.332344 sec(s).* > NOTE: We are expecting to build the graph from our data, so that we can > use .in() and .out() calls on edges and vertices. We have doubts that > CREATE LINK operation builds proper graph linkages, because based on the > documentation that we read CREATE LINK does not create a bidirectional Edge > link. > > > *If you're using custom settings please provide them below* > > We are not using any custom settings for the OrientDB server or JVM > > > *What is the expected output? What do you see instead?* > > Our expected output is a proper graph compiled from our data, stored in > OrientDB. Instead, we are unable to create 2-way Education edges between > Person and School vertices. Just to reiterate, all three classes are > successfully populated, but we are unable to establish edge links. > > > *Additional notes:* > > After import, the current DB size is 20GB > > Indexes have not been created > > Currently, we are attempting this operation on a Mac with the following > specs > > 1.7 GHz Intel Core i7 > > 8GB 1600 MHz DDR3 RAM > > 500GB SSD HD > > > > > > Please help, > Sandro > > > > > > > > -- --- 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/groups/opt_out.
