动态分区插入时遇到内存报警错误
错误如下:
ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.StatsTask
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.StatsTask (state=08S01,code=1)
网搜解决方案为:
set hive.stats.column.autogather=false;
set hive.optimize.sort.dynamic.partition=true;
设置后可通过sql,暂如此处理。