hive 2.3 mysql_hive2.3.7安装

1.安装包下载

2.上传安装包以及mysql驱动包

scp Downloads/apache-hive-2.3.7-bin.tar.gz [email protected]:/root/

scp Downloads/mysql-connector-java-5.1.47.jar [email protected]:/root/

3.解压安装包

[[email protected] ~]# tar -zxvf apache-hive-2.3.7-bin.tar.gz -C /usr/local/cluster/

[[email protected] ~]# chown hadoop:hadoop -R /usr/local/cluster/apache-hive-2.3.7-bin/

[[email protected] lib]# mv ~/mysql-connector-java-5.1.47.jar /usr/local/cluster/apache-hive-2.3.7-bin/lib/

[[email protected] lib]# chown hadoop:hadoop mysql-connector-java-5.1.47.jar

4.增加hive-site.xml

# vim hive-site.xml

? ? ? ?

? ? ? ? javax.jdo.option.ConnectionURL

? ? ? ? jdbc:mysql://hadoop002:3306/hive_metastore?createDatabaseIfNotExist=true

? ? ? ? JDBC connect string for a JDBC metastore

? ? ? ?

? ? ? ?

? ? ? ? javax.jdo.option.ConnectionDriverName

? ? ? ? com.mysql.jdbc.Driver

? ? ? ? Driver class name for a JDBC metastore

? ? ? ?

? ? ? ?

? ? ? ? javax.jdo.option.ConnectionUserName

? ? ? ? root

? ? ? ? username to use against metastore database

? ? ? ?

? ? ? ?

? ? ? ? javax.jdo.option.ConnectionPassword

? ? ? ? KoiioK12#

? ? ? ? password to use against metastore database

? ? ? ?

5.配置hive_home

vim /etc/profile

export HIVE_HOME=/usr/local/cluster/apache-hive-2.3.7-bin

export PATH=$PATH:$HIVE_HOME/bin

6.初始化元数据库

[[email protected] ~]$ schematool -dbType mysql -initSchema

7.启动hive客户端

hive

#创建测试库

hive> create database test;

8.界面查看hdfs文件

原文：https://www.cnblogs.com/koiiok/p/12984788.html