规则
SELECT
payload.cmdId as cmdId, hexstr2bin(payload.payload.c1) as c1_bin
FROM
“/HYXCloud”
where cmdId = ‘3111’
消息
{ “cmdId”: 3111, “sn”: “AAA0001”, “ts”: “1646139818952”, “lat”: 0, “lng”: 0, “payload”: { “time”: 1646220897, “c1”: “02”, “c2”: “0000”} }
