hive安装问题01

最新推荐文章于 2021-06-26 17:13:34 发布
最新推荐文章于 2021-06-26 17:13:34 发布
阅读量629 收藏
点赞数
分类专栏： 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安装依赖以及启动脚本
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 启动异常
天角蚁
09-17 1276
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
hive/lib/hive-common-2.2.0.jar!/hive-log4j2.properties Async: true
小苟的专栏
04-09 4007
今天安装hive的时候报这个错，用的是hive2.2.0的版本，花了两个小时才解决。Logging initialized using configuration in jar:file:/opt/software/hive/lib/hive-common-2.2.0.jar!/hive-log4j2.properties Async: trueException in thread "main"...
HIVE 报错 转自https://blog.csdn.net/xiesai588/article/details/51317478
u012099568的专栏
09-03 320
搭建hive时出现下面的错误： Logging initialized using configuration in jar:file:/root/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties [ERROR] Terminal initialization failed; falling back ...
hive启动时报错
博博的博客
03-05 1018
[root@bigdata2 conf]# hive Logging initialized using configuration in jar:file:/root/training/hive/lib/hive-common-1.2.2.jar!/hive-log4j.properties Exception in thread "main" java.lang.RuntimeEx
HIve安装踩坑手册
b379685397的博客
06-26 680
hive是基于Hadoop的一个数据仓库工具，所以我们要安装hive首先要安装Hadoop。本文hadoop和hive的安装方式和我踩的一些坑记录起来分享给大家 目录 一、安装环境 二、安装Hadoop 1、下载hadoop 2、修改环境变量 三、安装hive 1、下载hive 2、修改环境变量 3、修改hivesite 配置 4、验证是否安装成功 四、错误记录 1、配置文件中存在异常字符 二、guava版本不一致 一、安装环境 JDK 1.8 二、安装Hadoop 1、下
Hive2.3.4安装文档
06-05
Hive2.3.4安装文档 Hive是一款基于Hadoop的数据仓库工具，主要用于数据的存储、查询和...Hive安装完成后，我们可以使用Hive来存储和查询数据了。Hive提供了强大的数据仓库功能，可以帮助我们更好地管理和分析数据。
hive安装及相关知识整理
12-26
以下是对Hive安装及相关知识的详细讲解： **一、Hive简介** Hive最初由Facebook开发，用于解决海量日志数据分析的问题。它将结构化的数据文件映射为一张数据库表，并提供SQL查询功能，使得非专业的编程人员也能对...
Hive安装配置记录
07-29
以下是对 Hive 安装配置、常用命令及其功能的详细说明： 1. **Hive 的安装配置** - **下载与解压**：从 Apache 官方镜像站点下载稳定版本的 Hive，例如 `hive-0.7.1.tar.gz`，并将其解压到已安装 Hadoop 的主机...
hadoop hive hbase安装过程
03-21
### Hadoop、Hive、HBase 的安装配置详解 #### 一、Hadoop 安装配置 ##### 1. 创建用户与安装 JDK 在安装 Hadoop 前，首先需要创建一个专用的用户账户用于运行 Hadoop 相关服务，并确保 Java 环境已经正确安装。 ...
hive配置报错，及解决措施
weixin_43872683的博客
03-18 1498
Logging initialized using configuration in jar:file:/usr/local/src/apache-hive-1.2.2-bin/lib/hive-common-1.2.2.jar!/hive-log4j.properties [ERROR] Terminal initialization failed; falling back to unsupp...
java sessionstate_解决：Permission denied at org.apache.hadoop.hive.ql.session.SessionState.start(Sess...
weixin_35176891的博客
02-13 740
Permission denied at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:522)Logging initialized using configuration in jar:file:/opt/hive/1.2.1/lib/hive-common-1.2.1.jar!/hive-log...
Hive学习（三）安装配置
新新许愿树
12-22 741
目录 安装部署 Hive基本操作 将本地文件导入hive 查看在hive中输入的所有历史命令 Hive常见属性配置 数据仓库位置配置 查询后信息显示配置 运行日志信息配置 配置参数方式 官网地址：https://hive.apache.org/ 下载地址：https://www-eu.apache.org/dist/hive/ 官方wiki文档：https://cwiki....
Hadoop搭建Hive异常处理
qq_23871147的博客
07-22 326
Logging initialized using configuration in jar:file:/root/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties [ERROR] Terminal initialization failed; falling back to unsupported j
hadoop-hive安装配置
狐狸叫
11-04 1386
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
Hive 配置
热门推荐
小杨的技术博客
04-30 2万+
我使用的hive版本是1.2.1，以下是默认的配置文件。 hive-env.sh 重命名hive-env.sh.template为hive-env.sh，修改如下信息： # Set HADOOP_HOME to point to a specific hadoop install directory # 设置Hadoop安装目录 export HADOOP_HOME=/opt/module/ha...
Hive启动报错Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
zhangkaixuan456的博客
11-07 4052
Logging initialized using configuration in jar:file:/opt/app/hive-2.1.1/lib/hive-common-2.1.1.jar!/hive-log4j2.properties Async: true Exception in thread "main" java.lang.RuntimeException: org.apache...
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
Logging initialized using configuration in jar:file:/home/lan/software/hive/lib/hive-common-1.2.1.ja
jiuliangtan的博客
08-12 1万+
使用bin/hive命令,出现Logging initialized using configuration in jar:file:/home/lan/software/hive/lib/hive-common-1.2.1.jar!/hive-log4j.properties 之后一直卡着不动,查看log日志发现是连接不上mysql,想了好久,结果第二天一看是windows端的防火墙不知何时被...
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、付费专栏及课程。

余额充值