雨流计数法 clickhouse
clickhouse优势1,速度快2,函数多功能强大3,支持sql使用方便下面通过雨流计数思想用sql统计信号值波动次数计算加速踏板使用次数with acc_ped as sig,neighbor(sig,-1) as psig,sig-psig as dsig,neighbor(dsig,1) as dnsig,if(dsig>0 and dnsig<0 ,sig,null) as msigselect count(msig) from veh_data t.
原创
2021-09-06 11:08:40 ·
397 阅读 ·
0 评论