Hive 错误 ---＞Map operator initialization failed

代码为:

 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;