创建TAG
create tag user(product_no string, user_id string)
创建EDGE
create edge pay(product_no string, user_id string, pay_amt double, pay_cnt int)
导入数据
- user
"hash(""a001_1"")","a001",1
"hash(""a001_2"")","a001",2
"hash(""a001_3"")","a001",3
"hash(""a001_4"")","a001",4
"hash(""a001_5"")","a001",5
"hash(""a001_6"")","a001",6
"hash(""a001_7"")","a001",7
"hash(""a001_8"")","a001",8
"hash(""a001_9"")","a001",9
- pay
"hash(""a001_1"")","hash(""a001_2"")",a001,2,1000.0,2
"hash(""a001_1"")","hash(""a001_3"")",a001,3,1000.0,2
"hash(""a001_1"")","hash(""a001_4"")",a001,4,1000.0,2
"hash(""a001_1"")","hash(""a001_5"")",a001,5,1000.0,2
"hash(""a001_1"")","hash(""a001_6"")",a001,6,1000.0,2
"hash(""a001_6"")","hash(""a001_7"")",a001,7,500.0,3
"hash(""a001_6"")","hash(""a001_8"")",a001,8,500.0,3
"hash(""a001_6"")","hash(""a001_9"")",a001,9,500.0,3
"hash(""a001_2"")","hash(""a001_7"")",a001,20,300.0,1
"hash(""a001_2"")","hash(""a001_8"")",a001,21,300.0,1
"hash(""a001_2"")","hash(""a001_9"")",a001,22,300.0,1
"hash(""a001_7"")","hash(""a001_10"")",a001,10,200.0,1
"hash(""a001_7"")","hash(""a001_11"")",a001,11,200.0,1
"hash(""a001_7"")","hash(""a001_12"")",a001,12,200.0,1
查询SQL
LOOKUP ON user WHERE user.product_no == 'a001' yield user.user_id as user_id |go 2 steps from $-.VertexID over pay yield $-.user_id as user_id,pay.pay_amt as amt,pay.pay_cnt as cnt|group by $-.user_id yield $-.user_id as id,sum($-.amt) as amt_1,sum($-.cnt) as cnt_1 | order by amt_1 DESC | limit 10
查询结果
- 第一种结果
- 第二种结果
为什么存在两种结果???