问题描述:
在hive中创建数据库和数据表之后,进行insert操作报错。
hive (myhive)> insert into stu values (1,"zhangsan");
WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.Query ID = root_0223193226_05be353a-e09c-4c2f-b08b-ffead8d47bc3Total jobs = 3Launching Job 1 out of 3Number of reduce tasks is set to 0 since there's no reduce operatorjava.io.IOException: Cannot initialize Cluster. Please check your configuration for mapreduce.framework.name and the correspond server addresses.at org.apache.hadoop.mapreduce.Cluster.initialize(Cluster.java:120)at org.apache.hadoop.mapreduce.Cluster.<init>(Cluster.java:82)at org.apache.hadoop.mapreduce.Cluster.<init>(Cluster.java:75)at org.apache.hadoop.mapred.JobClient.init(JobClient.java:475)at org.apache.hadoop.mapred.JobClient.<init>(JobClient.java:454)at org.apache.hadoop.hive.ql.exec.mr.ExecDriver.execute(ExecDriver.java:398)at org.apache.hadoop.hive.ql.exec.mr.MapRedTask.execute(MapRedTask.java:138)at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:197)at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:100)at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2073)at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1744)at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1453)at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1171)at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1161)at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:232)at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:183)at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:399)at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:776)at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:714)at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:641)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.apache.hadoop.util.RunJar.run(RunJar.java:221)at org.apache.hadoop.util.RunJar.main(RunJar.java:136)Job Submission failed with exception 'java.io.IOException(Cannot initialize Cluster. Please check your configuration for mapreduce.framework.name and the correspond server addresses.)'FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask. Cannot initialize Cluster. Please check your configuration for mapreduce.framework.name and the correspond server addresses.
解决方案:
1. 查看了hadoop中mapred-site.xml
<property><name>mapreduce.framework.name</name><value>yarn</value></property>
还有yarn-site.xml中主机名也没问题。
2. 查查了资料,调整hadoop配置文件yarn-site.xml中值
<property><name>yarn.scheduler.minimum-allocation-mb</name><value>2048</value><description>default value is 1024</description></property>
之后又修改了root用户的权限
最后还是不行。
跪请路过的高人指点一下!!!!
如果觉得《hive中insert插入一条记录报错 跪求高人指点!!!》对你有帮助,请点赞、收藏,并留下你的观点哦!