SQl 经验总结

erinapple

已于 2023-10-07 17:11:42 修改

阅读量340

点赞数

文章标签： sql

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

本文链接：https://blog.csdn.net/erinapple/article/details/133642079

版权

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