version: v2
1、不正常的问题:
多参数,只要一个是变量,SQL就报错
go 2 STEPS FROM “department2432” OVER parent_department yield parent_department._dst as did,parent_department.id as id | fetch prop on member, department $-.id, "user11898"
提示:[ERROR (-7)]: SyntaxError: syntax error near `, "user1’
2、下面两种情况是正常的
只有一个参数(变量):
go 2 STEPS FROM “department2432” OVER parent_department yield parent_department._dst as did,parent_department.id as id | fetch prop on member, department $-.id
两个参数都不是变量
go 2 STEPS FROM “department2432” OVER parent_department yield parent_department._dst as did,parent_department.id as id | fetch prop on member, department “user11898”, "department1864"
fetch 中的 vertex id 只能是一列,当 pipeline 的时候,可以先 union一下。
需要注意的是,union 的列名必须一样的
(go 2 STEPS FROM “department2432” OVER parent_department yield parent_department.id as id union yield “user11898” as id) | fetch prop on member, department $-.id
(
GO 2 STEPS
FROM “department2432”
OVER parent_department
YIELD
parent_department._dst AS did,
parent_department.id AS id
|
FETCH PROP ON member, department $-.id
)
UNION
FETCH PROP ON member, department "user11898"
go from 362050 over edge_type1 yield edge_type1._dst as id | go from $-.id over edge_type1 YIELD edge_type1._src,edge_type1._dst as dst | GROUP BY $-.dst yield $-.dst as id,count(1) as count | FETCH PROP ON tag1 $-.id YIELD tag1.name,$-.count as count | order by $-.count desc;
尤其是 下面这段语法
FETCH PROP ON tag1 $-.id YIELD tag1.name,$-.count as count