甜辣酱

select content_tag,count(itemLink) as videos,sum(playednumber) as vv,sum(commentnum) as comments,sum(likenum) as likesfrom 表名lateral view explode(split(trim(tag),'\\$\\$')) z1 as content_tagwhere dt="2020-07-20"and content_tag!=""group by content.