说明
做个记录防止每次都到处找
文档参考: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
结果