That's a good idea. I have a number of other alternatives to consider:
1) Allow for the class to be set, by setting the "@class" property
2) Allow for classes to be changed after nodes are created
3) Overload the addVertex method to allow both class and Id.
Looking at how vertices are stored in OrientDB, @class property is already
used. It would be great if we could dictate which class a new record
should be created by setting the @class property.
With #3, one could initially store all objects as V, and subsequently
re-categorize them based on changing needs.
We tried to set the @class property for new records, but they were still
created as V. And, we tried to change their class type, but had no luck in
that either.
Sandro
On Monday, February 17, 2014 5:07:45 PM UTC-8, Lvc@ wrote:
>
> So at this point we'd need something that set the class to use. Something
> like:
>
> g.setDefaultVertexClass("Myclass");
>
> so all the further addVertex() will use this class. The same for edges.
>
> WDYT?
>
> Lvc@
>
>
>
> On 18 February 2014 01:40, Sandro <[email protected] <javascript:>> wrote:
>
>> I see two issues with that approach: 1) Blueprints thrown an error if id
>> is not provided, and 2) inability to reference vertices in the same
>> transaction if we don't provide a blueprints-specific ID.
>>
>> In other words, if we don't provide a unique id in addVertex, we get a
>> different error: Vertex with id already exists: Class:user
>>
>>>
>>> gremlin> new File("/Users/sandro/vertices.csv").each({ line ->
>>> gremlin> (username, age) = line.split(",")
>>> gremlin> user = bg.addVertex("Class:user")
>>> gremlin> ElementHelper.setProperties(user,
>>> ["username":username,"age":age.toInteger()])
>>> gremlin> })
>>> Vertex with id already exists: Class:user
>>> Display stack trace? [yN]
>>
>>
>> Also, there will be no way for us to quickly look up the needed vertices
>> by ID, as in the following code:
>>
>>> new File("/Users/sandro/edges.csv").each({ line ->
>>> (source, label, target) = line.split(",")
>>> v1 = bg.getVertex(sourceId)
>>> v2 = bg.getVertex(targetId)
>>>
>>>
>>> bg.addEdge(null, v1, v2, label,[weight:0.75f])
>>> })
>>>
>>
>>
>>
>>
>> On Monday, February 17, 2014 4:30:03 PM UTC-8, Lvc@ wrote:
>>
>>> Ok, id is reserver in Blueprints, try using another field name.
>>>
>>> Lvc@
>>>
>>>
>>>
>>> On 18 February 2014 01:12, Sandro <[email protected]> wrote:
>>>
>>>> Luca,
>>>>
>>>> I tried to set the Id property in a subsequent call, but received an
>>>> error message stating something to the effect of "Id is a readonly field."
>>>>
>>>> Here is the exact error:
>>>>
>>>> gremlin> new File("/Users/sandro/vertices.csv").each({ line ->
>>>>>
>>>>> gremlin> (username, age) = line.split(",")
>>>>>
>>>>> gremlin> user = bg.addVertex("Class:user")
>>>>>
>>>>> gremlin> ElementHelper.setProperties(user,
>>>>> ["Class":"user",id:username,"username":username,"age":age.
>>>>> toInteger()])
>>>>>
>>>>> gremlin> })
>>>>>
>>>>> Property key is reserved for all elements: id
>>>>>
>>>>> Display stack trace? [yN]
>>>>>
>>>> Sandro
>>>>
>>>>
>>>> On Monday, February 17, 2014 3:32:50 PM UTC-8, Lvc@ wrote:
>>>>
>>>>> Can you setup the id as field after having indexed it?
>>>>>
>>>>> Lvc@
>>>>>
>>>>>
>>>>>
>>>>> On 18 February 2014 00:28, Sandro <[email protected]> wrote:
>>>>>
>>>>>> Thank you for creating an issue for CREATE LINK functionality. Will
>>>>>> retry when it will become available.
>>>>>>
>>>>>> As workaround, we have been trying to upload the data using Gremlin,
>>>>>> by following this example: http://stackoverflow.com/ques
>>>>>> tions/19006616/how-to-import-a-csv-file-into-titan-graph-database
>>>>>>
>>>>>> Sample code:
>>>>>>
>>>>>>
>>>>>>
>>>>>>> g = new OrientGraph("remote:localhost/cars")
>>>>>>> bg = new BatchGraph(g, VertexIDType.STRING, 1000)
>>>>>>> new File("/Users/sandro/vertices.csv").each({ line ->
>>>>>>> (username, age) = line.split(",")
>>>>>>> user = bg.addVertex(username)
>>>>>>> ElementHelper.setProperties(user, ["username":username,"age":age
>>>>>>> .toInteger()])
>>>>>>> })
>>>>>>> bg.commit()
>>>>>>> new File("/Users/sandro/edges.csv").each({ line ->
>>>>>>> (source, label, target) = line.split(",")
>>>>>>> v1 = bg.getVertex(source)
>>>>>>> v2 = bg.getVertex(target)
>>>>>>> bg.addEdge(null, v1, v2, label,[weight:0.75f])
>>>>>>> })
>>>>>>> bg.commit()
>>>>>>
>>>>>>
>>>>>> However, we ran into a challenge with bg.addVertex(id).
>>>>>>
>>>>>> We need to pass an Id to bg.addVertex, so that we can reference this
>>>>>> vertex in the subsequent operation and bind it to an edge.
>>>>>>
>>>>>> However, if we pass an Id into addVertex(id), then all vertices are
>>>>>> created as generic V's. On the other hand, if we pass class name by
>>>>>> calling bg.addVertex("class:MyClass"), then we cannot pass an id, and
>>>>>> therefore cannot reference this vertex by Id in the subsequent call to
>>>>>> bind
>>>>>> it to an edge.
>>>>>>
>>>>>> Is there a way in which we can load our graph using Gremlin, while
>>>>>> still retaining the inheritance class structure of Vertices?
>>>>>>
>>>>>> Sandro
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Monday, February 17, 2014 4:31:54 AM UTC-8, Lvc@ wrote:
>>>>>>
>>>>>>> I've created an issue for this: https://github.com/orien
>>>>>>> technologies/orientdb/issues/2045
>>>>>>>
>>>>>>> Lvc@
>>>>>>>
>>>>>>>
>>>>>>> On 17 February 2014 13:25, Luca Garulli <[email protected]> wrote:
>>>>>>>
>>>>>>>> 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-Creat
>>>>>>>>>> e-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/orientechno
>>>>>>>>>>>> logies/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.
>>>>>>
>>>>>
>>>>> --
>>>>
>>>> ---
>>>> 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] <javascript:>.
>> 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.
