ods层的数据是string,但是数据内容是json格式,需要将其转为json或者map
with t1 as (
select str_to_map(replace(replace(replace(replace(labels, "{", ""), "}", ""), "\"", ""), ',', '&'), '&', ':') labels
from ods_alert_record_full
)
select
labels['alertname']
from t1;