[GitHub] [incubator-age] johnnyMick commented on issue #50: Importing Data from Relationnel Table into Graph DB

[GitBox <gi...@apache.org>]

johnnyMick commented on issue #50:
URL: https://github.com/apache/incubator-age/issues/50#issuecomment-819677848


   in the AGE pdf documentation (advance Cypher Queries), it's possible to join regular table with Graph data like so 
   ```
   SELECT id,
   graph_query.name = t.name as names_match,
   graph_query.age = t.age as ages_match
   FROM schema_name.sql_person AS t
   JOIN cypher('graph_name', $$
   MATCH (n:Person)
   RETURN n.name, n.age, id(n)
   $$) as graph_query(name agtype, ag
   ```
   But what if i want to Import the data from the `sql_person` table into the a Graph DB as vertices ? 
   
   ```
   SELECT *
   FROM cypher('graph_name', $$
   CREATE (:Person {name: ‘Andres’, title: ‘Developer’)
   $$) as (n agtype);
   ```
   Do i have to use a Programming language to query the data from `sql_person` table than manipulate the data and create the above string to create the vertices ? Or can i just use SQL query directly to able to create all rows in the `sql_person` as a vertex in the Graph ?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org