- 语句 1
- 场景:如何实现类似的 JOIN 功能
- 具体语句:试试 match 和多个 optional match
// 1 MATCH(v)-[e:person_knows_person*1..3]-(v2) WHERE v.person.firstName == "firstName" // 2 OPTIONAL MATCH (v2)-[e2: person_isLocatedIn_place]-(v3) // 3 OPTIONAL MATCH (v2)-[e3: person_studyAt_organisation]-(v4) // 4 OPTIONAL MATCH (v2)-[e3: person_workAt_organisation]-(v5) // 查找国家 ... WITH v2 as personName, v3 as workingPlace, v4 as college, v5 as company RETURN personName, workingPlace, college, company, country
- 适合版本:v3.3.0
- 语句出处:https://discuss.nebula-graph.com.cn/t/topic/11754
- 语句 2
- 场景:如何筛选出某个 rank 值对应的路径
- 具体语句:
MATCH p=(v)-[e:follow]-(v2) WHERE id(v) == "player10" and rank(e) == 1 RETURN pLIMIT 100
- 适合版本:v2.5.0
- 语句出处:https://discuss.nebula-graph.com.cn/t/topic/11726
1 个赞