2.6 查询结果很多BAD_TYPE

  • nebula 版本:2.6 client nebula-console-darwin-arm64-v2.6.0
  • 部署方式:分布式
  • 安装方式 Docker /
  • 是否为线上版本:Y
    查询示例
(root@nebula) [dataengine]> GO FROM "e873eff893a8e1f5" over e_paper_doctor REVERSELY yield id($$) as id, $$.t_paper.paper_id as paper_id,(CASE e_paper_doctor.author_order when 1 then 0.9 else 0.1 end) as weight;

查询结果很多BAD_TYPE,这种一般是情况,怎么避免

1、你可以确定一下 e_paper_doctor 这个边 是否有目的点不存在的 情况 (悬挂边)
确定一下

GO FROM "e873eff893a8e1f5" over e_paper_doctor REVERSELY yield e_paper_doctor._dst | yield count(*) 和
GO FROM "e873eff893a8e1f5" over e_paper_doctor REVERSELY yield id($$)| yield count(*)

这两个结果是不是相同的

1 个赞
(root@nebula) [dataengine]> GO FROM "e873eff893a8e1f5" over e_paper_doctor REVERSELY yield e_paper_doctor._dst | yield count(*);
+----------+
| count(*) |
+----------+
| 541      |
+----------+
Got 1 rows (time spent 2545/300558 us)

Thu, 24 Feb 2022 15:18:45 CST

(root@nebula) [dataengine]> GO FROM "e873eff893a8e1f5" over e_paper_doctor REVERSELY yield id($$) | yield count(*);
+----------+
| count(*) |
+----------+
| 541      |
+----------+
Got 1 rows (time spent 37777/50160 us)

一样的

在对比一下

GO FROM "e873eff893a8e1f5" over e_paper_doctor REVERSELY yield e_paper_doctor._dst 和
GO FROM "e873eff893a8e1f5" over e_paper_doctor REVERSELY yield id($$)

这两个结果 是一样的吗

(root@nebula) [dataengine]> GO FROM “e873eff893a8e1f5” over e_paper_doctor REVERSELY yield id($$)

好多bad_type
https://cos.ap-beijing.myqcloud.com/dropshare-1252438752/pb-oXIpACh7ZQ.txt


GO FROM “e873eff893a8e1f5” over e_paper_doctor REVERSELY yield e_paper_doctor._dst
https://cos.ap-beijing.myqcloud.com/dropshare-1252438752/pb-6pdxMIHWJV.txt

可能是因为一些点插入失败

嗯,插入点失败,造成了悬挂边,因此无法取出点的属性,造成了BAD_TYPE

3 个赞