$var1 = go from hash('6C5UTc6T44E=') over human_enterprise_holder where human_enterprise_holder.history == 0 yield human_enterprise_holder._dst as e_holder_id; $var2 = go from hash('6C5UTc6T44E=') over human_enterprise_legal_represent where human_enterprise_legal_represent.history == 0 yield human_enterprise_legal_represent._dst as e_legal_id; $var3 = go from hash('6C5UTc6T44E=') over human_enterprise_member where human_enterprise_member.history == 0 and human_enterprise_member.isExecutive == 1 yield human_enterprise_member._dst as e_member_id; $var4 = yield $var1.* union yield $var2.* union yield $var3.*; yield $var4.*
查询结果-查看$var4
通过$var4进行最终查询
$var1 = go from hash('6C5UTc6T44E=') over human_enterprise_holder where human_enterprise_holder.history == 0 yield human_enterprise_holder._dst as e_holder_id; $var2 = go from hash('6C5UTc6T44E=') over human_enterprise_legal_represent where human_enterprise_legal_represent.history == 0 yield human_enterprise_legal_represent._dst as e_legal_id; $var3 = go from hash('6C5UTc6T44E=') over human_enterprise_member where human_enterprise_member.history == 0 and human_enterprise_member.isExecutive == 1 yield human_enterprise_member._dst as e_member_id; $var4 = yield $var1.* union yield $var2.* union yield $var3.*; go from $var4.$var1.e_holder_id over human_enterprise_holder,human_enterprise_legal_represent,human_enterprise_member reversely
$var1=go from hash("V1") over E1 yield E1._dst as dst;
$var2=go from hash("V2") over E2 yield E2._dst as dst;
$var3=yield $var1.dst as dst union yield $var2.dst;
go from $var3.dst over E3 reversely
你的 vid 是不是 int 报错是说你的 vid 需要是个 string。我大概明白了,上面大兄弟是 v1.x 版本的,那时候 vid 只能是 int,所以需要做 hash 生成 vid。
如果你要用一样的话,直接
$var1=go from "V1" over E1 yield E1._dst as dst;
$var2=go from "V2" over E2 yield E2._dst as dst;
$var3=yield $var1.dst as dst union yield $var2.dst;
go from $var3.dst over E3 reversely
$var1=go from “V1” over E1 yield E1._dst as dst;
$var2=go from $var1.dst over E2 yield E2._dst as dst;
$var3=yield $var1.dst as dst union yield $var2.dst;
go from $var3.dst over E3 reversely
$var2 的 from id是引用$var1的结果,执行就报这个错:-1005:NULL', the srcs should be type of STRING, but wasNULL’
(root@nebula) [nba]> $v1 = go from “Tony Parker” over like yield like._dst as dst; $v2 = go from $v1.dst over like yield like._dst as dst; yield $v1.dst union yield $v2.dst
[ERROR (-1009)]: SemanticError: different column names to UNION/INTERSECT/MINUS are not supported
Wed, 18 Jan 2023 16:09:41 CST
(root@nebula) [nba]> $v1 = go from “Tony Parker” over like yield like._dst as dst; $v2 = go from $v1.dst over like yield like._dst as dst; yield $v1.dst as dst union yield $v2.dst as dst
±--------------------+
| dst |
±--------------------+
| “LaMarcus Aldridge” |
| “Manu Ginobili” |
| “Tim Duncan” |
| “Tony Parker” |
±--------------------+
Got 4 rows (time spent 6.657ms/7.07614ms)