MATCH (v1)-[e:xygx]->(v2)<-[e1:xygx]-(v3) WHERE id(v1)== “110101193005032206” and id(v3)== “11010119531015345X” RETURN DISTINCT properties(v1).name as srcName, id(v2) AS dstId ,properties(v2).name AS dstName , properties(v2).type AS dstType, type(e) AS edgeCode1 ,properties(v3).name as srcName2,type(e1) AS edgeCode2;
你现在的 nebulagraph 内核版本是多少。
目前的版本是3.1版本
你在studio用的是3.1吗? 贴一下2.5和3.1的执行计划吧, 我在本地用 basketballPlayer 数据集没有复现:
(root@nebula) [nba]> MATCH (v1)-[e:like]->(v2)<-[e1:like]-(v3) WHERE id(v1)== "Tim Duncan" RETURN DISTINCT properties(v1).name as srcName, id(v2) AS dstId ,properties(v2).name AS dstName
+--------------+-----------------+-----------------+
| srcName | dstId | dstName |
+--------------+-----------------+-----------------+
| "Tim Duncan" | "Manu Ginobili" | "Manu Ginobili" |
| "Tim Duncan" | "Tony Parker" | "Tony Parker" |
+--------------+-----------------+-----------------+
Got 2 rows (time spent 20.606ms/21.453939ms)
两个查询的输出结果都贴一下
有发现是什么问题吗?或者需要怎么改动?
这是3.1一个属性裁剪的bug导致的, 建议升级到3.4