SQl 经验总结

get_json_object

select distinct upper(UrlDecoder(new_cuid)) as new_cuid, conv_time, conv_type
from convert_data.guanxingpan_databank_for_ocpx
lateral view explode(split(cuid, ',')) temptable1 as new_cuid
where event_day in (20220420)
and data_id in (208694840)
and from_unixtime(conv_time, 'YYYYMMdd')>='20220325' and from_unixtime(conv_time, 'YYYYMMdd')<='20220331'
and conv_type='28'
and length(new_cuid)>10