hive安装，启动失败错误及解决办法汇总

您所在的位置：网站首页 › ubuntu出错 › hive安装，启动失败错误及解决办法汇总

hive安装，启动失败错误及解决办法汇总

2023-07-31 00:19| 来源: 网络整理| 查看: 265

1.安装hive

下载hive：https://downloads.apache.org/hive/ 安装及配置hive：hive:https://blog.csdn.net/qq_28854219/article/details/81185610?

2.hive启动失败，hive报错及解决办法

错误一 [root@node01 conf]# hive 19/03/31 09:57:31 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist

Logging initialized using configuration in jar:file:/opt/sxt/apache-hive-1.2.2-bin/lib/hive-common-1.2.2.jar!/hive-log4j.properties Exception in thread “main” java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient…

可能原因：没有mysql和hive没有连接上解决办法：将mysql-connector-java-5.1.32-bin.jar拷贝一份到hive的lib目录下。 (下载jar包：https://dev.mysql.com/downloads/connector/j/ )

错误二 Terminal initialization failed; falling back to unsupported

可能原因：这是由于hadoop的目录中存在老版本的jline-0.9.94.jar 解决办法：将hive下的新版本jline的JAR包拷贝到hadoop下 cp /hive/apache-hive-1.1.0-bin/lib/jline-2.12.jar /hadoop-2.5.2/share/hadoop/yarn/lib/ 并删除老版本：jline-0.9.94.jar

错误三 hive.site.xml配置文件出错 Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

hive.server2.thrift.bind.host hadoop1 Bind host on which to run the HiveServer2 Thrift service. datanucleus.fixedDatastore false hive.metastore.execute.setugi true javax.jdo.option.ConnectionURL jdbc:mysql://192.168.223.10:3306/hive?createDatabaseIfNotExist=true;useSSL=false javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver javax.jdo.option.ConnectionUserName root javax.jdo.option.ConnectionPassword admin hive.metastore.warehouse.dir /usr/hive/apache-hive-1.2.2-bin/warehouse hive.exec.scratchdir /usr/hive/apache-hive-1.2.2-bin/tmp hive.querylog.location /usr/hive/apache-hive-1.2.2-bin/log hive.metastore.schema.verification false hbase.zookeeper.quorum hadoop1:2181,hadoop2:2181,hadoop3:2181

主要修改其中的 jdbc:mysql://master:3306/hive?createDatabaseIfNotExist=true&useSSL=false 将master改为对应的主机ip如： jdbc:mysql://192.168.223.10:3306/hive?createDatabaseIfNotExist=true&useSSL=false

【本文地址】

hive安装，启动失败错误及解决办法汇总

hive安装，启动失败错误及解决办法汇总

今日新闻

推荐新闻