Hi, I am also new to OrientDB. I think your classes should extend V. See if it works after this change.
Regards, Ameer On 15 Feb 2014 23:39, "Sandro" <[email protected]> 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. > -- --- 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.
