[Solved] HiveSQL Error: “Error while processing statement: FAILED: Execution Error, return code 2“

Project scenario:

tip: briefly describe the project background here:
when writing hivesql today, some codes are executed, and the same errors are reported after execution

 


Problem Description:

tip: problems encountered in the project are described here: </ font>

Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive

Solution:

tip: fill in the specific solution to the problem here:
later, it was found that this is an MR execution error. The reason is that the program here needs to go through Mr, and I manually turned on the local mode. Just turn it off now. Slow down and slow down

set hive.exec.mode.local.auto=false;

Read More: