cho2hhun opened a new issue, #1226:
URL: https://github.com/apache/age/issues/1226
First of all, I'd used **Agens Graph** also, So this issue is disadvantage
compare to **Agens Graph**
I think the one of the advantages of AGE and Agens Graph which is supported
Hybrid DBMS and Query between RDB and GDB is that it can make '**Table form**'
from Graph in GDB
In the case of **Agens Graph**, It is possible to convert to **Table**,
**Temporary Table**, **View** from Graph in AGE GDB
** But in AGE, only possible to convert to '**View**' not Table, Temporary
Table **
creating Table & Temporary Table from Graph Cypher query in AGE GDB
```
ERROR: unhandled cypher(cstring) function call
```
but can covert to **View** from Graph like below code
```
create view aaa as (
select * from cypher ('bitcoin', $$
match (a : vt_rater)-[r1 :
eg_rate]->(b : vt_rater)
with a.rater as a_rater,
count(r1) as cnt order by count(*) desc limit 100
with collect(a_rater) as
a_rater_list
match (c : vt_rater)-[r2 :
eg_rate]->(d : vt_rater)
where c.rater in a_rater_list
return c, r2, d $$) as (c
agtype, r2 agtype, d agtype)
);
```
+ To add, I think Saving as a Table form is really sensitive and efficient
by handling Graph Data
above Query is finding **TOP 100 evaluting Rater's Network** user from
'Bitcoin Evalution Graph'
Indeed, for repeated use for that **Network**, the readablity is really
really bad.
So I think it is necessary to declare it to something, but Table form
declaring and saving was really surprised for me
I Think This would be really Hybrid query between RDB and GDB if there were
revision that could declare and save Graph to Table and Temporary Table also
So if u guys have any Idea, let's Share it!
**Version INFO : 13**
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
