hive插入数据卡住,Kill Command, beyond the 'VIRTUAL' memory limit.

hive (default)> INSERT INTO stu(ID) VALUES (1);
Query ID = root_20220418223547_c883abd3-8b84-4eb4-afd1-c7f623c6f85d
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
set hive.exec.reducers.bytes.per.reducer=
In order to limit the maximum number of reducers:
set hive.exec.reducers.max=
In order to set a constant number of reducers:
set mapreduce.job.reduces=
Starting Job = job_1650292478227_0001, Tracking URL = http://master:8088/proxy/application_1650292478227_0001/
Kill Command = /opt/module/hadoop/bin/mapred job -kill job_1650292478227_0001
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1
2022-04-18 22:36:35,078 Stage-1 map = 0%, reduce = 0%
2022-04-18 22:37:05,474 Stage-1 map = 100%, reduce = 100%
Ended Job = job_1650292478227_0001 with errors
Error during job, obtaining debugging information...
Examining task ID: task_1650292478227_0001_m_000000 (and more) from job job_1650292478227_0001

Task with the most failures(4):

Task ID:
task_1650292478227_0001_m_000000

URL:
http://master:8088/taskdetails.jsp?jobid=job_1650292478227_0001&tipid=task_1650292478227_0001_m_000000


Diagnostic Messages for this Task:
[2022-04-18 22:37:04.793]Container [pid=5000,containerID=container_1650292478227_0001_01_000005] is running 307034624B beyond the 'VIRTUAL' memory limit. Current usage: 186.5 MB of 1 GB physical memory used; 2.4 GB of 2.1 GB virtual memory used. Killing container.
Dump of the process-tree for container_1650292478227_0001_01_000005 :
|- PID PPID PGRPID SESSID CMD_NAME USER_MODE_TIME(MILLIS) SYSTEM_TIME(MILLIS) VMEM_USAGE(BYTES) RSSMEM_USAGE(PAGES) FULL_CMD_LINE
|- 5000 4998 5000 5000 (bash) 0 0 9744384 289 /bin/bash -c /opt/module/jdk/bin/java -Djava.net.preferIPv4Stack=true -Dhadoop.metrics.log.level=WARN -Xmx820m -Djava.io.tmpdir=/opt/module/hadoop/data/nm-local-dir/usercache/root/appcache/application_1650292478227_0001/container_1650292478227_0001_01_000005/tmp -Dlog4j.configuration=container-log4j.properties -Dyarn.app.container.log.dir=/opt/module/hadoop/logs/userlogs/application_1650292478227_0001/container_1650292478227_0001_01_000005 -Dyarn.app.container.log.filesize=0 -Dhadoop.root.logger=INFO,CLA -Dhadoop.root.logfile=syslog org.apache.hadoop.mapred.YarnChild 192.168.34.5 39868 attempt_1650292478227_0001_m_000000_3 5 1>/opt/module/hadoop/logs/userlogs/application_1650292478227_0001/container_1650292478227_0001_01_000005/stdout 2>/opt/module/hadoop/logs/userlogs/application_1650292478227_0001/container_1650292478227_0001_01_000005/stderr
|- 5011 5000 5000 5000 (java) 758 132 2552147968 47459 /opt/module/jdk/bin/java -Djava.net.preferIPv4Stack=true -Dhadoop.metrics.log.level=WARN -Xmx820m -Djava.io.tmpdir=/opt/module/hadoop/data/nm-local-dir/usercache/root/appcache/application_1650292478227_0001/container_1650292478227_0001_01_000005/tmp -Dlog4j.configuration=container-log4j.properties -Dyarn.app.container.log.dir=/opt/module/hadoop/logs/userlogs/application_1650292478227_0001/container_1650292478227_0001_01_000005 -Dyarn.app.container.log.filesize=0 -Dhadoop.root.logger=INFO,CLA -Dhadoop.root.logfile=syslog org.apache.hadoop.mapred.YarnChild 192.168.34.5 39868 attempt_1650292478227_0001_m_000000_3 5

[2022-04-18 22:37:04.871]Container killed on request. Exit code is 143
[2022-04-18 22:37:04.900]Container exited with a non-zero exit code 143.

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
MapReduce Jobs Launched:
Stage-Stage-1: Map: 1 Reduce: 1 HDFS Read: 0 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec
hive (default)>

请求各位帮忙看看,十分感谢!

你这是虚拟内存不足,要不就降低计算量,要不就修改配置,然后重启集群:
修改mapred-site.xml文件:添加以下配置

<property>
  <name>mapreduce.map.memory.mb</name>
  <value>1536</value>
</property>
<property>
  <name>mapreduce.map.java.opts</name>
  <value>-Xmx1024M</value>
</property>
<property>
  <name>mapreduce.reduce.memory.mb</name>
  <value>3072</value>
</property>
<property>
  <name>mapreduce.reduce.java.opts</name>
  <value>-Xmx2560M</value>
</property>