Hi Sandro, Could you use "create edge" command instead create link https://github.com/orientechnologies/orientdb/wiki/SQL-Create-Edge ? if still will be an issue could you send me database in stage when data inserted but edges are still not created.
On Sun, Feb 16, 2014 at 7:05 PM, Sandro <[email protected]> wrote: > 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. > -- Best regards, Andrey Lomakin. Orient Technologies the Company behind OrientDB -- --- 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.
