Hi, I think the problem is that we don't have an equivalent of "create link" that transform field values aka RDBMS foreign keys, into edges but only "links".
Lvc@ On 17 February 2014 11:51, Andrey Lomakin <[email protected]> wrote: > Also I would be appreciate if you send me your db anyway ))) we will check > why links were not created. > > > On Mon, Feb 17, 2014 at 12:48 PM, Andrey Lomakin <[email protected] > > wrote: > >> 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 >> >> > > > -- > 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. > -- --- 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.
