hive安装问题01

最新推荐文章于 2022-10-14 15:21:46 发布
最新推荐文章于 2022-10-14 15:21:46 发布
阅读量608 收藏
点赞数
分类专栏： hive 文章标签： hadoop hive
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u014151160/article/details/78034198
版权

    1、首先，请打开HADOOP再启动Hive，我一开始就是这么天真的以为Hive可以单独使用，所以疯狂的报错，出现以下的错误。其实认真看看报错信息就知道是与Hadoop相关（前提是你的hadoop本身真的是可用的）。

[hadoop@mini01 bin]$ ./hive

Logging initialized using configuration in jar:file:/home/hadoop/apps/hive-1.2.1/lib/hive-common-1.2.1.jar!/hive-log4j.properties
Exception in thread "main" java.lang.RuntimeException: java.net.ConnectException: Call From mini01/192.168.176.61 to mini01:9000 failed on connection exception: java.net.ConnectException: 拒绝连接; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused
    at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:522)
    at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Caused by: java.net.ConnectException: Call From mini01/192.168.176.61 to mini01:9000 failed on connection exception: java.net.ConnectException: 拒绝连接; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at org.apache.hadoop.net.NetUtils.wrapWithMessage(NetUtils.java:791)
    at org.apache.hadoop.net.NetUtils.wrapException(NetUtils.java:731)
    at org.apache.hadoop.ipc.Client.call(Client.java:1473)
    at org.apache.hadoop.ipc.Client.call(Client.java:1400)
    at org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker.invoke(ProtobufRpcEngine.java:232)
    at com.sun.proxy.$Proxy17.getFileInfo(Unknown Source)
    at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolTranslatorPB.getFileInfo(ClientNamenodeProtocolTranslatorPB.java:752)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.apache.hadoop.io.retry.RetryInvocationHandler.invokeMethod(RetryInvocationHandler.java:187)
    at org.apache.hadoop.io.retry.RetryInvocationHandler.invoke(RetryInvocationHandler.java:102)
    at com.sun.proxy.$Proxy18.getFileInfo(Unknown Source)
    at org.apache.hadoop.hdfs.DFSClient.getFileInfo(DFSClient.java:1977)
    at org.apache.hadoop.hdfs.DistributedFileSystem$18.doCall(DistributedFileSystem.java:1118)
    at org.apache.hadoop.hdfs.DistributedFileSystem$18.doCall(DistributedFileSystem.java:1114)
    at org.apache.hadoop.fs.FileSystemLinkResolver.resolve(FileSystemLinkResolver.java:81)
    at org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSystem.java:1114)
    at org.apache.hadoop.fs.FileSystem.exists(FileSystem.java:1400)
    at org.apache.hadoop.hive.ql.session.SessionState.createRootHDFSDir(SessionState.java:596)
    at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:554)
    at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:508)
    ... 8 more
Caused by: java.net.ConnectException: 拒绝连接
    at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
    at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:735)
    at org.apache.hadoop.net.SocketIOWithTimeout.connect(SocketIOWithTimeout.java:206)
    at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:530)
    at org.apache.hadoop.net.NetUtils.connect(NetUtils.java:494)
    at org.apache.hadoop.ipc.Client$Connection.setupConnection(Client.java:608)
    at org.apache.hadoop.ipc.Client$Connection.setupIOstreams(Client.java:706)
    at org.apache.hadoop.ipc.Client$Connection.access$2800(Client.java:369)
    at org.apache.hadoop.ipc.Client.getConnection(Client.java:1522)
    at org.apache.hadoop.ipc.Client.call(Client.java:1439)
    ... 28 more

2、你的mysql没有打开远程登录的权限，报错内容主要选段如下（太长太长了，可能也漏点了一些很重要的）：

[hadoop@mini01 bin]$ ./hive

Logging initialized using configuration in jar:file:/home/hadoop/apps/hive-1.2.1/lib/hive-common-1.2.1.jar!/hive-log4j.properties
Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
    at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:522)
    at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

----------------------------------------------------------
Caused by: javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true, username = root. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
java.sql.SQLException: null,  message from server: "Host 'mini01' is not allowed to connect to this MySQL server"
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)

---------------------------------------------------------
NestedThrowables:
java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true, username = root. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
java.sql.SQLException: null,  message from server: "Host 'mini01' is not allowed to connect to this MySQL server"
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)

----------------------------------------------------------  
Caused by: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true, username = root. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original 
Exception: ------
java.sql.SQLException: null,  message from server: "Host 'mini01' is not allowed to connect to this MySQL server"
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
---------------------------------------------------------
Caused by: java.sql.SQLException: null,  message from server: "Host 'mini01' is not allowed to connect to this MySQL server"
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)

    开启Mysql中的权限

[hadoop@mini01 ~]$ mysql -uroot -p

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

    3、hive中一个为jline的包与hadoop里yarn的包重复了，yarn中的那个包一搬版本都是有点低的，可删除了然后将hive中的jline包添加进hadoop去。报错信息如下：


 [hadoop@mini01 bin]$ ./hive

Logging initialized using configuration in jar:file:/home/hadoop/apps/hive-1.2.1/lib/hive-common-1.2.1.jar!/hive-log4j.properties
[ERROR] Terminal initialization failed; falling back to unsupported
java.lang.IncompatibleClassChangeError: Found class jline.Terminal, but interface was expected
    at jline.TerminalFactory.create(TerminalFactory.java:101)
    at jline.TerminalFactory.get(TerminalFactory.java:158)
    at jline.console.ConsoleReader.<init>(ConsoleReader.java:229)
    at jline.console.ConsoleReader.<init>(ConsoleReader.java:221)
    at jline.console.ConsoleReader.<init>(ConsoleReader.java:209)
    at org.apache.hadoop.hive.cli.CliDriver.setupConsoleReader(CliDriver.java:787)
    at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:721)
    at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

Exception in thread "main" java.lang.IncompatibleClassChangeError: Found class jline.Terminal, but interface was expected
    at jline.console.ConsoleReader.<init>(ConsoleReader.java:230)
    at jline.console.ConsoleReader.<init>(ConsoleReader.java:221)
    at jline.console.ConsoleReader.<init>(ConsoleReader.java:209)
    at org.apache.hadoop.hive.cli.CliDriver.setupConsoleReader(CliDriver.java:787)
    at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:721)
    at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

    修改步骤如下：

当前目录是hive的lib目录

[hadoop@mini01 lib]$ rm ~/apps/hadoop-2.6.4/share/hadoop/yarn/lib/jline-0.9.94.jar
[hadoop@mini01 lib]$ cp ./jline-2.12.jar  ~/apps/hadoop-2.6.4/share/hadoop/yarn/lib/

祈祷：仙女一定不会有BUG

盐井很闲又有钱
关注
专栏目录
安装Hive遇到的问题
YacFighting的博客
11-09 2575
实验中遇到的问题 实验过程中hive打不开 java.lang.NoSuchMethodError:com.google.common.base.Preconditions.checkArgument 原因是hive安装目录下lib内guava.jar和hadoop安装目录下share/hadoop/common/lib内guava.jar版本不一样。解决方法是删除低版本的，并拷贝高版本的。 2.启动hive时报错：Tue Oct 19 16:41:49 CST 2021 WARN: Establis
Hive安装与配置常见问题解决
最新发布
qq_53879605的博客
10-14 1317
在之前的文章中介绍了Hadoop集群,本文安装的Hive是基于Hadoop的一个数据仓库工具，并底层依赖与HDFS储存数据，本文将介绍如何安装及其配置。
Hive安装及问题解决
数据库天地
12-05 144
刚刚安装好hadoop迫不及待要玩下hive，所以自己找了些资料，安装了下hive，这里记录详细的安装过程和碰到的问题： 1.在安装hadoop之前首先确定hadoop已经安装成功，具体安装方法请参考hadoop安装。 2.下载hive版本 我下载的是 下载地址为http://hive.apache.org/releases.htm 解压文件： tar -zxvf hive-0.7.0...
Hive安装以及问题汇总
生活不止眼前的枸杞， 还有蜂蜜和咖啡！
04-26 261
Hive只在一个节点上安装即可1.  上传tar包    下载地址：点击打开链接     Hive版本与Hadoop版本：Hadoop、Hbase、Hive版本兼容性2.  解压tar -zxvf apache-hive-2.2.0-bin.tar.gz -C ~/software/mv apache-hive-2.2.0-bin hive-2.2.0  接着配置HIVE_HOME环境变量修改...
hive 安装问题
紫色的Dandelion的博客
03-05 171
1.目的： 复习安装 hive 以便和kettle 结合使用，安装 hive 出现的错误。 2.执行 sql 语句有警告，例如：show tables;报以下警告。 Tue Mar 05 14:37:52 CST 2019 WARN: Establishing SSL connection without server's identity verification is no...
hive安装及安装过程中的问题
墨殇
07-15 715
前言： hive是基于hadoop的，数据存储在hdfs上并且对客户端提供hql支持，将hql语句转换为mapreduce任务的数仓工具，hive就相当于hadoop的一个另一种形式的客户端 hql，hive的底层是用java实现的！ 一、安装准备： 安装hive之前保证hadoop、zookeeper、jdk 二、安装版本： 主流是1.2和2.3 版本 镜像地址： https://mirrors...
hive安装依赖以及启动脚本
06-11
hive安装依赖以及启动脚本 文件包含如下： 01_mysql-community-common-5.7.29-1.el7.x86_64.rpm 02_mysql-community-libs-5.7.29-1.el7.x86_64.rpm 03_mysql-community-libs-compat-5.7.29-1.el7.x86_64.rpm 04_...
Hive安装与配置及常见问题解决
weixin_60315352的博客
10-14 1013
Hive的安装与配置
Hive以及Hive安装部署
望山。
11-15 1980
文章目录1.Hive简介1.1什么是Hive1.2为什么使用Hive1.3Hive的特点1.4Hive架构图1.5Hive与Hadoop的关系1.6Hive与传统数据库对比2.HIVE的安装部署1.derby版hive直接使用1、解压hive2.修改目录名称3.初始化元数据库4.启动5.创建数据库6.创建表7.插入数据8.可能遇到的问题9.Hive启动报错Safe mode2.基于mysql管理元数据版hive1、解压hive2.修改目录名称3.检测服务器mysql数据库4.配置mysql允许外网访问5.退
HIVE2的安装过程以及问题解决
u013623958的专栏
03-25 1048
在安装HIVE的时候遇到了很多问题，在网上也查了很多资料但是有些问题没有明确的解决方法，所以决定自己写一篇关于HIVE安装过程以及我在遇到安装失败时是如何解决的文章。HIVE安装步骤： 在安装HIVE之前，java环境、hadoop以及mysql都应该已经部署完成，在这里不做过多介绍，接下来直入主题。 下载apache-hive-2.1.1-bin.tar.gz(下载地址)并执行命令 tar -
那些年踩过的坑 hive 启动异常
天角蚁
09-17 1255
Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient 异常 异常) Logging initialized using configuration in jar:file:/opt/software/hive/lib/hiv
hadoop-hive安装配置
狐狸叫
11-04 1363
hadoop-hive安装配置 下载hive-0.8.1.tar.gz   ---------在ahdoop1.0.0这个版本上要使用这个版本以上     把这个文件解压在/hadoop/app目录下 1.添加bin/hive-config.sh，添加jdk支持 exportJAVA_HOME=/usr/java/jdk1.7.0_02 exportHIVE_HOME
Linux打开hive出现Logging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common
热门推荐
weixin_43706372的博客
06-27 2万+
Linux打开hive出现Logging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-2.1.0.jar!/hive-log4j2.properties Async: true Exception in thread “main” java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lan
hive报错：Logging initialized using configuration in jar:file:/home/software/apache-hive-1.2.0-bin/lib/
qq_45453185的博客
12-04 3745
在hive的bin目录下输入sh hive报错: [root@hadoop01 apache-hive-1.2.0-bin]# cd bin [root@hadoop01 bin]# sh hive Logging initialized using configuration in jar:file:/home/software/apache-hive-1.2.0-bin/lib/hive-co...
启动hive的时候的报错：【bug调试】
wyqwilliam的博客
08-22 742
报错： Logging initialized using configuration in jar:file:/root/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.proper ties[ERROR] Terminal initialization failed; falling back to unsupporte...
Hive启动错误
weixin_44104007的博客
08-23 941
不知道怎么回事，启动hive出现这种错误。 SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/software/hive/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] ...
[Hive安装问题]
weixin_30344995的博客
03-18 100
启动Hive时出现： Exception in thread "main" java.lang.RuntimeException: java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsyst...
Hive安装教程：从tar包到配置MySQL连接
接下来，配置Hive环境变量`HIVE_HOME`，通常设置为Hive安装目录。然后，将Hive的配置文件`cphive-default.xml.template`和`hive-site.xml`中的元数据连接信息进行修改。在`hive-site.xml`中，关键的JDBC连接属性包括...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值