TuGraph Cypher 查询语句

蓝染k9z

已于 2022-12-15 16:34:04 修改

阅读量492

点赞数 1

分类专栏：知识图谱文章标签：人工智能图数据库 TuGraph

于 2022-12-15 10:17:15 首次发布

本文链接：https://blog.csdn.net/qq_43806430/article/details/128101961

版权

知识图谱专栏收录该内容

6 篇文章 0 订阅

订阅专栏

简单条件遍历

MATCH （n:fromid）with n limit 1000
MATCH p=(n)-(m) WHERE p.gender = "女" RETURN p

MATCH p=(n)-[*..2]-(m) RETURN p LIMIT 1000

MATCH p=(n:fromid)-[*..2]-(m) RETURN p LIMIT 100

MATCH (n:fromid)-[]-(m)-[]-(t) WHERE n.name ENDS WITH '3' RETURN m

复杂条件遍历

3.1a

MATCH p=(n)-[r]-(m) WHERE r.attention>50 RETURN p LIMIT 1000

3.1b

MATCH p=(n)-[*..1]-(m) WHERE p.nation<>"中国" AND p.gender="女" RETURN p LIMIT 1000

3.2a

MATCH p=(match(n) limit 1000:fromid)-[*..2]-(m:toid) WHERE p.fromid+p.toid > 50 RETURN p

3.2b

MATCH p=(n)-[*..2]-(m) WHERE p.nation<>"中国" AND p.gender="女" RETURN p LIMIT 1000

3.2c

MATCH p=(n)-[*..2]-(m) WHERE p.nation<>"美国" AND p.gender="男" AND p.age>30 AND p.fromid+p.toid>50 RETURN p LIMIT 1000

3.3

MATCH p=(n)-[*..3]-(m) WHERE p.nation<>"美国" AND p.gender="男" AND p.age>30 AND p.fromid+p.toid>50 RETURN p LIMIT 1000

MATCH (n:from {id:$param})-[r](m) WHERE m.name ENDS WITH "3" RETURN COUNT(r)

final查询

2.1

MATCH (n) WITH n LIMIT 1000 MATCH (n)-[r]-(m) return r;

match (n) with n limit 1000 match (n)-[r]-(m) with count(r) as cnt return cnt/1000;

2.2

MATCH (n) WITH n LIMIT 1000 MATCH (n)-[r1]-(m)-[r2]-(p) return r1,r2;

match (n) with n limit 1000 match (n)-[r1]->(m)-[r2]->(p) with count(r1) as num_r1, count(r2) as num_r2 return (num_r1 + num_r2) /1000;

2.3

MATCH (n) WITH n LIMIT 1000 MATCH (n)-[r1]-(m)-[r2]-(p)-[r3]-(q) return r1,r2,r3;

MATCH (n) WITH n LIMIT 1000 MATCH (n)-[r1]-(m)-[r2]-(p)-[r3]-(q) with count(r1) as num_r1, count(r2) as num_r2, count(r3) as num_r3 return (num_r1 + num_r2 + num_r3) /1000;

3.1a

match (n) with n limit 1000 match (n)-[r]->(m) where r.attention>50 return r;

match (n) with n limit 1000 match (n)-[r]->(m) with count(r) as num_r where r.attention>50 return num_r/1000;

3.1b

match (n) with n limit 1000 where n.nation<>"中国" and n.gender="女" match (n)-[r]->(m) return r;

match (n) with n limit 1000 where n.nation<>"中国" and n.gender="女" match (n)-[r]->(m) with count(r) as num_r return num_r/1000;

3.2a

match (n) with n limit 1000 match (n)-[r1]->(m)-[r2]->(p) where r1.attention>50 and r2.attention>50 return m,p

match (n) with n limit 1000 match (n)-[r1]->(m)-[r2]->(p) where r1.attention>50 and r2.attention>50 with count(m) as num_m, count(p) as num_p return (num_m+num_p)/1000;

3.2b

match (n) with n limit 1000 match (n)-[r1]->(m)-[r2]->(p) where n.nation<>"中国" and n.gender="女" and m.nation<>"中国" and m.gender="女" and p.nation<>"中国" and p.gender="女" return m,p;

match (n) with n limit 1000 match (n)-[r1]->(m)-[r2]->(p) where n.nation<>"中国" and n.gender="女" and m.nation<>"中国" and m.gender="女" and p.nation<>"中国" and p.gender="女"   with count(m) as num_m, count(p) as num_p return (num_m+num_p)/1000;

3.2c

match (n) with n limit 1000 match (n)-[r1]->(m)-[r2]->(p) where n.nation<>"美国" and n.gender="男" and n.age>30 and m.nation<>"美国" and m.gender="男" and m.age>30 and p.nation<>"美国" and p.gender="男" and p.age>30 and r1.attention>50 and r2.attention>50 with count(m) as num_m, count(p) as num_p return (num_m+num_p)/1000;

3.3

match (n) with n limit 1000 match (n)-[r1]->(n1)-[r2]->(n2)-[r3]->(n3) where n.nation<>"美国" and n.gender="男" and n.age>30 and n1.nation<>"美国" and n1.gender="男" and n1.age>30 and n2.nation<>"美国" and n2.gender="男" and n2.age>30 and n3.nation<>"美国" and n3.gender="男" and n3.age>30 and r1.attention>50 and r2.attention>50 and r3.attention>50 with count(r1) as num_r1, count(r2) as num_r2, count(r3) as num_r3 return (num_r1 + num_r2 + num_r3)/1000;