代码为:
select videoId,category
from gulivideo_orc
where videoId in (
select *
from (
select relatedId_name
from (
select relatedId, `views`
from gulivideo_orc
order by `views` desc
limit 50
) t1--找到top50
lateral view explode(relatedId) tmp as relatedId_name
) t2 --找出top50对应的相关视频Id
)
原因:大表join大表时内存不足导致初始化失败,自动默认的大表join小表,查看设置:
解决方法:
将大表join小表设置为false即可
最后记得运行完,将改值改为true;