sanjiang521的博客

hive执行sql报错：FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask解决措施：hive> set hive.auto.convert.join=false;关闭自动mapjoin

cannot access /opt/spark/lib/spark-assembly-*.jar: No such file or directory问题叙述原因解决办法问题叙述安装好spark后，启动hive报错，内容如下：原因spark版本升级到2.x以后,原有lib目录下的大JAR包被分散成多个小JAR包，原来的spark-assembly-*.jar已经不存在，所以hive没有办法找到这个JAR包。解决办法打开hive下面的bin目录,找到hive文件,编辑hive文件,找到如下一行

Exception in thread "main" java.lang.RuntimeException: java.net.ConnectException: Call From hadoop30/192.168.29.30 to hadoop30:9000 failed on connection exception: java.net.ConnectException: Connection refused; For more details see: http://wiki.apache.org