What does it mean that multiple map=0%,reduce=0% appear in succession in hadoop?

normal hadoop execution

clipboard.png
hadoop

clipboard.png

what does it mean that multiple map=0%,reduce=0% appear in succession?
Last error report:
Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

guess: is it caused by the deep nesting of sql?

Update: just add this sentence set hive.auto.convert.join=false

Mar.10,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b38975-2c132.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b38975-2c132.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?