SHOW QUERY,这里有社区用户常用的 nGQL 查询语句

  • 语句 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
    
  • 语句 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 个赞