hive数据库无法插入数据,元数据已经启动
Task with the most failures(4):
-----
Task ID:
task_1721704515377_0002_m_000000
URL:
http://node1:8088/taskdetails.jsp?jobid=job_1721704515377_0002&tipid=task_1721704515377_0002_m_000000
-----
Diagnostic Messages for this Task:
[2024-07-23 14:06:14.688]Exception from container-launch.
Container id: container_1721704515377_0002_01_000005
Exit code: 1
[2024-07-23 14:06:14.691]Container exited with a non-zero exit code 1. Error file: prelaunch.err.
Last 4096 bytes of prelaunch.err :
Last 4096 bytes of stderr :
Error: Could not find or load main class org.apache.hadoop.mapred.YarnChild
[2024-07-23 14:06:14.692]Container exited with a non-zero exit code 1. Error file: prelaunch.err.
Last 4096 bytes of prelaunch.err :
Last 4096 bytes of stderr :
Error: Could not find or load main class org.apache.hadoop.mapred.YarnChild
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
show databases 建表查看表都可以运行
最近的日志
hive-site。xml设置
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://node1:3306/hive?createDatabaseIfNotExist=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value> #此处为MySQL用户
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value> #此处为MySQL自己设置的密码
</property>
<property>
<name>hive.server2.thrift.bind.host</name>
<value>node1</value>
</property>
<property>
<name>hive.metastore.uris</name>
<value>thrift://node1:9083</value>
</property>
<property>
<name>hive.metastore.event.db.notification.api.auth</name>
<value>false</value>
</property>
</configuration>
hive-env。xml
export HADOOP_HOME=/export/servers/hadoop
export HIVE_CONF_DIR=/export/servers/hive/conf
export HIVE_AUX_JARS_PATH=/export/servers/hive/lib