报错语句:
go 1 to 2 STEPS from “UR2712823947216322560” over e_call BIDIRECT where $$.user.user_no!=‘UR2712823947216322560’ yield distinct $$.user.user_no as userNo,$$.user.date_appl_submit as dateApplSubmit | limit 500 | yield count(case when $-.dateApplSubmit is not null and $-.dateApplSubmit > (int64)(0) then true end) as ApplUserCnt
不报错语句:
go 1 to 2 STEPS from “UR2712823947216322560” over e_call BIDIRECT where $$.user.user_no!=‘UR2712823947216322560’ and $$.user.date_appl_submit is not null and $$.user.date_appl_submit > (int64)(0) yield distinct $$.user.user_no as userNo,$$.user.date_appl_submit as dateApplSubmit | limit 500 | yield count(*) as ApplUserCnt
为啥要选择第一种形式,因为还有很多计算项(avg、count、sum等等),过滤的条件不是一致的。