java - 在 OrientDB 中查找最短路径长度

Question

如何在 OrientDB 中找到最短路径长度？如何找到最短路径的例子有很多，但是一定有办法只得到这条路径的长度吗？

所以不是顶点列表 like with this query

SELECT expand(path) FROM (

  SELECT shortestPath($from, $to) AS path 

  LET 

    $from = (SELECT FROM Profiles WHERE Name='Santo' and Surname='OrientDB'), 

    $to = (SELECT FROM Countries WHERE Name='United States') 

  UNWIND path

)

我只想要一个数字作为结果。

我使用Java来查询数据库，所以Java API函数也可以。

Answer 1

试试这个:

SELECT sum(path.size()) FROM (

  SELECT shortestPath($from, $to) AS path 

  LET 

    $from = (SELECT FROM Profiles WHERE Name='Santo' and Surname='OrientDB'), 

    $to = (SELECT FROM Countries WHERE Name='United States') 

  UNWIND path

)

希望有帮助。

问候