ekuiper中乘除运算SQL语法

eKuiper
1

SELECT Sou_Dian_Gong.data.WD_01+GDSJCJ.data.A as val from Sou_Dian_Gong inner join GDSJCJ GROUP BY TumblingWindow(ms, 1000);

两个参数的±运算可以正常运行，把±号改为*/号就无法运行，如下

SELECT Sou_Dian_Gong.data.WD_01*GDSJCJ.data.A as val from Sou_Dian_Gong inner join GDSJCJ GROUP BY TumblingWindow(ms, 1000);

是我sql写的有问题吗？

2

有什么错误信息？

3

run Select error: alias: val expr: binaryExpr:{ binaryExpr:{ binaryExpr:{ Sou_Dian_Gong.data → jsonFieldName:WD_01 } * GDSJCJ.data } → jsonFieldName:A } meet error, err:invalid operation float64(15) * map[string]interface {}(map[A:15 DS:true N:15 P:15 R:15 S:true SZ:true SZZ:true V:15 zR:15])

4

SELECT Sou_Dian_Gong.data.WD_01*(GDSJCJ.data.A) as val from Sou_Dian_Gong inner join GDSJCJ GROUP BY TumblingWindow(ms, 1000);

1 个赞