阿里云物联网

原创于 2021-07-13 17:47:12 发布 · 185 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

7 篇文章

订阅专栏

该查询涉及到物联网设备的数据上报，包括设备ID、产品ID、地理位置、温度、湿度、降雨量、PM2.5指数、噪音水平、液位、垃圾箱满载状态、阀门位置、扩展参数、电压和功率模式等关键信息。这些数据可用于实时监控和智能分析，以提升设备管理和运营效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

规则查询语句：

SELECT topic(1) as productKey, attribute('deviceidkey') as deviceidkey, attribute('productid') as product_id, deviceName() as deviceName, attribute('tag') as tag, attribute('coordinate') as gprs_gd, items.temper.value as temperature, items.humidity.value as humidity, items.rain.value as rain, items.PM25.value as PM25, items.noise.value as noise, items.liquidLevel.value as liquidLevel,items.wasteLevel.value as wasteLevel, items.valvePosition.value as valvePosition, items.extendParam.value as extendParam, items.voltage.value as voltage, items.voltage1.value as voltage1, items.pwrMode.value as pwrMode, items.virtualDev.value as virtualDev, items.ctrlMode.value as ctrlMode, to_base64(*) as baseContentAli, timestamp('yyyy-MM-dd HH:mm:ss') as time FROM "/a1ttYz/+/thing/event/property/post"