select *
from table_name
where dt between '2020-03-29' and '2020-03-30'
and coalesce(extend_info['content_id'],get_json_object(extend_info['query'],'$.content_id')) is null
select *
from table_name
where dt between '2020-03-29' and '2020-03-30'
and coalesce(extend_info['content_id'],get_json_object(extend_info['query'],'$.content_id')) is null