hive大小表关联,自动转为map join,结果申请资源太大,sql异常退出
解决:set hive.auto.convert.join=false;
2024-03-21 19:59:22 Starting to launch local task to process map join; maximum memory = 3817865216
Execution failed with exit status: 2
Obtaining error information
Task failed!
Task ID:
Stage-10
Logs:
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask