How to create a new vertex by splitting an existing vertex

GSQL Graph Schema
,
#1

Hi There.

I am trying to split an existing vertex into two. Eg - User to User and City.
We are interested to see the users within a city…
In the user data we also have city information which is added as an attribute.

Now I need to split the city vertex into city and location vertices and join them with edge located_in.

I tried schema_change job but it is only changing the schema and the number of vertices in location is still 0.

Can anyone help me with an optimal solution for the same.

#2

Hello @Dharmin,

When initiating a schema change job, it won’t automatically redistribute the data in your graph. To ensure your data aligns with the updated schema, you should follow these steps:

  1. After the completion of the schema change job, re-execute the new load job with the correct mapping to your updated schema.
  2. To verify the successful data load, you can either utilize a REST endpoint or navigate to the Load Data tab in GraphStudio.

Feel free to reach out if you have any further questions or need additional assistance.

#3

Hi Jon

Thanks for the reply. I dont have a seperate data for the location. I will have to read the user vertices select the location attribute and re-insert it as Location vertices.

Regards
Dharmin