JSON: map_resolve

支持该函数：阿里云odps sql

示例：

use jz_daojia;
select *
from jz_daojia.f_jz_traffic_all
where dt >= '20200210'
and map_resolve(urlfields,'page_name') = 'workers_%20peace'
and page_type='activity'
;

urlfields 字段内容如下：

map
  key: page_name
  value: workers_%20peace
map
  key: bi_sdk_name
  value: trace
map
  key: businessline
  value: jtdashujubu

注意：使用 map_resolve 需在SQL语句前加上 use jz_daojia;