一、规则为
SELECT
tokens(payload, ',') as str1,
int(nth(6, str1)) as ele,
int(nth(7, str1)) as signal,
int(substr(nth(9, str1), 10))/10 as temper,
int(substr(nth(10, str1), 10, 4))/10 as xvel,
int(substr(nth(10, str1), 14,4))/100 as xacc,
int(substr(nth(10, str1), 18,4)) as xdis,
int(substr(nth(11, str1), 10,4))/10 as yvel,
int(substr(nth(11, str1), 14,4))/100 as yacc,
int(substr(nth(11, str1), 18,4)) as ydis,
int(substr(nth(12, str1), 10,4))/10 as zvel,
int(substr(nth(12, str1), 14,4))/100 as zacc,
int(substr(nth(12, str1), 18,4))as zdis
FROM
"/dev/coo/smart"
二、消息重新发布为
[{"sensor_device_id":20,"port_id":1,"sdata":${ele}}
,{"sensor_device_id":20,"port_id":2,"sdata":${signal}}
,{"sensor_device_id":20,"port_id":3,"sdata":${temper}}
,{"sensor_device_id":20,"port_id":4,"sdata":${xvel}}
,{"sensor_device_id":20,"port_id":5,"sdata":${xacc}}
,{"sensor_device_id":20,"port_id":6,"sdata":${xdis}}
,{"sensor_device_id":20,"port_id":7,"sdata":${xfre}}
,{"sensor_device_id":20,"port_id":8,"sdata":${yvel}}
,{"sensor_device_id":20,"port_id":9,"sdata":${yacc}}
,{"sensor_device_id":20,"port_id":10,"sdata":${ydis}}
,{"sensor_device_id":20,"port_id":11,"sdata":${yfre}}
,{"sensor_device_id":20,"port_id":12,"sdata":${zvel}}
,{"sensor_device_id":20,"port_id":13,"sdata":${zacc}}
,{"sensor_device_id":20,"port_id":14,"sdata":${zdis}}
,{"sensor_device_id":20,"port_id":15,"sdata":${zfre}}]
三、点击报错界面
四、报错提示
点击上图更新后提示相关报错如上图。
五、总结
系统运行正常，数据采集也正常，之前没有发现这个问题，近期才出现的，感觉为系统bug，请官方给回复一下吧。