摘要: -- 1.设备主状态 status CREATE STABLE IF NOT EXISTS stihl_status_stb (ts TIMESTAMP, val TINYINT) TAGS (sn BINARY(64),group_id INT); -- 2.建图子状态 status_mappin 阅读全文
posted @ 2026-08-03 14:16 kevinWwm 阅读(2) 评论(0) 推荐(0)
摘要: 先对齐你的架构模式总结 整体架构: 16 张【单指标超级表 STable】:一指标一张 STable,ts + val + sn标签 每个设备 SN,预先手动创建独立子表(例如 stb_d1001、bat_d1001) meters_v:虚拟模板超级表(VIRTUAL 1),作为宽表 Schema 阅读全文
posted @ 2026-07-30 16:31 kevinWwm 阅读(5) 评论(0) 推荐(0)
摘要: -- 1.设备主状态 status CREATE STABLE IF NOT EXISTS stihl_status_stb ( ts TIMESTAMP, val TINYINT ) TAGS ( sn BINARY(64) ); -- 2.建图子状态 status_mapping CREATE 阅读全文
posted @ 2026-07-30 16:07 kevinWwm 阅读(3) 评论(0) 推荐(0)
摘要: 完整架构:Spring AI RAG 智能知识库 AWS 无服务器方案 整体链路分两大模块: 文档入库链路:S3 上传文件 → Lambda 触发 → 文档解析 / 切片 → 调用 Embedding → 向量入库 客服问答链路:前端请求 → API Gateway → Lambda(内置 Spri 阅读全文
posted @ 2026-07-11 12:21 kevinWwm 阅读(5) 评论(0) 推荐(0)
摘要: /stihldevice/${clientId}/nrtk/# /stihldevice/${clientId}/update/# /stihldevice/${clientId}/gps/# /stihldevice/${clientId}/get/# /stihlapp/${clientId}/ 阅读全文
posted @ 2026-07-08 13:53 kevinWwm 阅读(5) 评论(0) 推荐(0)
摘要: cat > /opt/scripts/sync_to_volc.sh << 'EOF' !/bin/bash LOG="/var/log/sync_to_volc.log" echo " 开始同步 $(date) =" >> $LOG rclone copy aws-s3:data-collecti 阅读全文
posted @ 2026-06-08 16:30 kevinWwm 阅读(4) 评论(0) 推荐(0)
摘要: 图片桶 ai-transform nohup watch -n 300 "rclone move aws-s3:ai-transform tos-aws:amazon-volce --transfers=16 --checkers=32 --ignore-existing --remove-empt 阅读全文
posted @ 2026-05-20 16:07 kevinWwm 阅读(5) 评论(0) 推荐(0)
摘要: CREATE TABLE IF NOT EXISTS datacollection.volce_json_table ( left_image String, left_image_resolution String, right_image String, right_image_resoluti 阅读全文
posted @ 2026-05-20 12:22 kevinWwm 阅读(10) 评论(0) 推荐(0)
摘要: sudo apt --fix-broken install -y sudo rm -rf /etc/nginx sudo apt remove --purge nginx* -y sudo apt autoremove -y sudo apt clean sudo apt update sudo a 阅读全文
posted @ 2026-05-01 14:38 kevinWwm 阅读(23) 评论(0) 推荐(0)
摘要: sudo vim /etc/systemd/system/clickhouse-server.service sudo groupadd clickhouse && sudo useradd -r -g clickhouse clickhouse sudo systemctl restart cli 阅读全文
posted @ 2026-04-30 17:13 kevinWwm 阅读(7) 评论(0) 推荐(0)