go 1 TO 2 STEPS返回内容显示问题

nebula version: v2

在管道下,go 1 TO 2 steps 显示了行数,但是行里边的内容没有; 使用 go 2 steps 可以输出内容。

go from "user11011" over member_department yield member_department._dst as id | go 1 TO 2 STEPS FROM $-.id OVER parent_department yield parent_department._dst
+------------------------+
| parent_department._dst |
+------------------------+
|                        |
+------------------------+
|                        |
+------------------------+
Got 2 rows (time spent 21586/57300 us)

Thu, 15 Apr 2021 17:44:22 CST

(root@nebula) [dian]> go from "user11011" over member_department yield member_department._dst as id | go 2 STEPS FROM $-.id OVER parent_department yield parent_department._dst
+------------------------+
| parent_department._dst |
+------------------------+
| "department1864"       |
+------------------------+
Got 1 rows (time spent 18550/75517 us)

请问下,这是使用姿势问题还是BUG? 如果是使用姿势问题,请教下正确的方式。 这个SQL是获取这个人所在组织的所有父级组织。

谢谢反馈,看起来应该是个 bug,我问一下同事。

谢谢

空单元格表示值为空

但是这个结果好像也有问题

值不是空的, 因为 go 2 step 返回是有值的; 并且edge表里确实是有值的

实际上是有值的,2跳也有数据,但是 1 to 2 steps 返回2条,一条 1 step 一条 2step,但是没有带值。

你把pipe去掉,直接用go看看结果

直接用 go 1 TO 5 STEP 是有值返回的

go 1 TO 10 STEPS FROM “department1864” OVER parent_department where parent_department._dst != ‘NULL’
±-----------------------+
| parent_department._dst |
±-----------------------+
| “department707” |
±-----------------------+
| “department1” |
±-----------------------+
Got 2 rows (time spent 20297/71186 us)

1 to 2 steps

起点是上一个语句的结果

还有分别看一下go 1 step , go 2 step的结果

go 1 STEPS FROM “department1864” OVER parent_department where parent_department._dst != ‘NULL’
±-----------------------+
| parent_department._dst |
±-----------------------+
| “department707” |
±-----------------------+
Got 1 rows (time spent 7142/494378 us)

Fri, 16 Apr 2021 10:23:38 CST

go 2 STEPS FROM “department1864” OVER parent_department where parent_department._dst != ‘NULL’
±-----------------------+
| parent_department._dst |
±-----------------------+
| “department1” |
±-----------------------+

上面的语句没有where

这个是一样的, where只是过滤一条脏数据

go from “user11011” over member_department yield member_department._dst as id | go 1 TO 5 STEPS FROM $-.id OVER parent_department where parent_department._dst != ‘NULL’ yield parent_department._dst
±-----------------------+
| parent_department._dst |
±-----------------------+
| |
±-----------------------+
| |
±-----------------------+
| |
±-----------------------+
| |
±-----------------------+
| |
±-----------------------+

看上去确实是有问题的,可以提供一下相关数据的 insert 语句吗

随便一个数据就能复现的,比如 console 的 nba 数据。

(root@nebula) [nba]> go from 'Tim Duncan' over like yield like._dst as id | go  2 steps from $-.id over like yield like._dst
+-----------------+
| like._dst       |
+-----------------+
| "Manu Ginobili" |
+-----------------+
| "Manu Ginobili" |
+-----------------+
| "Tony Parker"   |
+-----------------+
| "Tony Parker"   |
+-----------------+
| "Tim Duncan"    |
+-----------------+
| "Tony Parker"   |
+-----------------+
| "Tim Duncan"    |
+-----------------+
Got 7 rows (time spent 5589/30786 us)

Sat, 17 Apr 2021 15:56:55 CST

(root@nebula) [nba]> go from 'Tim Duncan' over like yield like._dst as id | go 1 to 2 steps from $-.id over like yield like._dst
+-----------+
| like._dst |
+-----------+
|           |
+-----------+
|           |
+-----------+
|           |
+-----------+
|           |
+-----------+
|           |
+-----------+
|           |
+-----------+
|           |
+-----------+
|           |
+-----------+
|           |
+-----------+
Got 9 rows (time spent 4231/47968 us)

请问下,这个问题预计修复时间有吗?我需要调整下我这边的进度,谢谢啦。