Hive安装

* 下载二进制安装文件
* 安装到指定目录
* 配置环境变量
* 配置元数据存储位置
* 初始化hive
* 命令验证
 

(一) 下载二进制安装文件

到Hive官网找到指定版本的文件进行下载(https://mirrors.tuna.tsinghua.edu.cn/apache/hive/)

此处下载最新发布的安装包
#>
wget https://mirrors.tuna.tsinghua.edu.cn/apache/hive/hive-3.1.1/apache-hive-3.1.1-bin.tar.gz
 

(二)安装到指定目录
#> tar -zxvf apache-hive-3.1.1-bin.tar.gz  -C /soft #> ln -s
apache-hive-3.1.1-bin hive
 

(三)配置环境变量
#> vim /etc/environment HIVE_HOME=/soft/hive PATH=追加"/soft/hive/bin"
 

(四)配置元数据存储位置

原始数据默认存储在derby,改为mysql

在hive安装目录的conf中创建hive-site.xml添加如下配置
#> vim hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?> <?xml-stylesheet
type="text/xsl" href="configuration.xsl"?> <configuration> <property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://ipaddress:port/database?createDatabaseIfNotExist=true</value>
</property> <property> <name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.cj.jdbc.Driver</value> </property> <property>
<name>javax.jdo.option.ConnectionUserName</name> <value>root</value>
</property> <property> <name>javax.jdo.option.ConnectionPassword</name>
<value>password</value> </property> </configuration>
 

(五)初始化hive
#> schematool -dbType mysql -initSchema
 

(六)命令验证
#> hive -e "show tables;"
 

成功显示如下:

which: no hbase in
(/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/soft/jdk/bin:/soft/hadoop/bin:/soft/hadoop/sbin:/soft/hive/bin)
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/soft/apache-hive-3.1.1-bin/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/soft/hadoop-3.2.0/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Hive Session ID = 5535c2a2-05d2-44f9-9b09-80ce7e95c25a
 

Logging initialized using configuration in
jar:file:/soft/apache-hive-3.1.1-bin/lib/hive-common-3.1.1.jar!/hive-log4j2.properties
Async: true
Hive Session ID = 593ffa38-c0bb-4d1e-9fca-1b2bca8d8276
OK
Time taken: 1.251 seconds

 

• « 上一篇：如何去除抖音视频的水印？
• » 下一篇：MySQL函数一览_MySQL函数全部汇总