select
pkg_name,
flow.slot_name as slot,
if(upper(country) rlike '^[a-z]{2}$',upper(country),'unknown') as country,
flow.load_type as load_type,
flow.succ as succ
from
bigo_ad.bigo_ad_callback_parquet_v1
lateral view explode(from_json(event_info['flows'],'array<map<string,string>>'))t1 as flow
where day = '2023-03-15' and hour = '03'
limit 10;