阿里云日志高级查询

说明

做个记录防止每次都到处找

文档参考:https://help.aliyun.com/document_detail/68096.html

需求一

需要抓取容量告警服务商id,从数据库查出数据给产品或者运营核实

 

查询语句

容量告警|SELECT regexp_extract(content,'\"providerId\":(?<providerId>[a-zA-Z\d]+)',1) as providerId,count(*) as count GROUP BY providerId ORDER BY count DESC

结果