jrgemignani commented on issue #1639: URL: https://github.com/apache/age/issues/1639#issuecomment-1979491054
@mingfang I'm not following what you want to, or are expecting to do. That being said, from what it _looks like to me_, I get the impression that you are trying to work with the graph data (graphs/nodes/edges) as relational database data (tables/rows/columns) instead of as graph data. You need to think of the graph data as graph data and use graph structures and commands to represent and retrieve what you want. This may mean rethinking your graph's structure so that it represents what you want. A few notes on graph structures that might be helpful, if you aren't aware of them already - - A graph is a collection of nodes and edges (should be obvious, but worth saying to be complete). - A node (or vertex) is usually an object or thing. It can contain 0 to any number of properties to describe it. - An edge (or sometimes called a relationship) is usually a relationship or path between 2 nodes. It can contain 0 to any number of properties to describe it. - A node can have 0 to an infinite number of edges. These edges could be of many differing relationships. - An edge always has a direction and always connects just 2 nodes. - Apache AGE is a directed property graph meaning that all edges have a direction and all components have properties. Components being nodes and edges. With AGE it is possible to combine SQL and Cypher and mix relational and graph. But, you should avoid modifying the underlaying graph data as it can potentially cause data corruption. If you want to add another column to a node/edge you can add that data inside the properties for that node/edge. Or, you could create an edge, back to itself with that data. That is just an example, and likely a bad one as it is a loop. Loops can have consequences for open ended graph transversals. -- 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. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org