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:
[email protected]
