失眠网,内容丰富有趣,生活中的好帮手!
失眠网 > hive中insert插入一条记录报错 跪求高人指点!!!

hive中insert插入一条记录报错 跪求高人指点!!!

时间:2018-08-31 00:18:51

相关推荐

hive中insert插入一条记录报错 跪求高人指点!!!

问题描述:

在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插入一条记录报错 跪求高人指点!!!》对你有帮助,请点赞、收藏,并留下你的观点哦!

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。