SQl 经验总结

原创已于 2023-10-07 17:11:42 修改 · 401 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#sql

收录于

于 2023-10-07 15:39:37 首次发布

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