Hi Alessandro,
Currently there is only one class called NODE having three fields
id, name, parent_id
All I wish to do is create "Parent -> Child" edges in nodes created using
above class.
Here is sample class and data creation script (Note that I have to add more
than 10k offices in real life):
create class NodeX extends V
create property NodeX.id string
create property NodeX.name string
create property NodeX.parent_id string
CREATE VERTEX NodeX CONTENT {"id":"Corp", "name" : "Corporate Office",
"parent_id" : "Corp" }
CREATE VERTEX NodeX CONTENT {"id":"D1", "name" : "District Office 1",
"parent_id" : "Corp" }
CREATE VERTEX NodeX CONTENT {"id":"D2", "name" : "District Office 2",
"parent_id" : "Corp" }
CREATE VERTEX NodeX CONTENT {"id":"SO1", "name" : "Small Office 1",
"parent_id" : "D1" }
CREATE VERTEX NodeX CONTENT {"id":"SO2", "name" : "Small Office 2",
"parent_id" : "D2" }
CREATE VERTEX NodeX CONTENT {"id":"SO3", "name" : "Small Office 3",
"parent_id" : "D1" }
On Friday, 29 May 2015 13:11:04 UTC+5:30, [email protected] wrote:
>
> Hi Kapil,
> have you got a screenshot of your schema ?
>
> Bye, Alessandro
>
> Il giorno venerdì 29 maggio 2015 09:12:37 UTC+2, Kapil Ranade ha scritto:
>>
>> I have imported hierarchical data into OrientDB from RDMBS using OETL.
>>
>> In RDBMS we used to store parentId in the same row. e.g. the table
>> structure is something like this:
>>
>> ID - Name - Parent_ID
>>
>> Corp - Corporate Office - Corp
>>
>> D1 - District Office 1 - Corp
>>
>> D2 - District Office 2 - Corp
>>
>> SO1 - Small Office 1 - D1
>>
>> SO2 - Small Office 2 - D2
>>
>> SO3 - Small Office 3 - D1
>>
>> Now each row is a node in orientdb. I want to create an edge (ParentOf)
>> from say Corp to D1 and D1 to SO1 and so on.
>>
>> How can I write a query to achieve this? Something along the line of
>> following?
>>
>> create edge parentOf from (select from node)a to (select from node where
>> a.id = parent_id)
>>
>>
>>
--
---
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/d/optout.
