安装的mysql是8.0以上的版本
没有的话直接shell安装
sudo apt update
sudo apt install mysql-server -y
将下载的hive压缩包(apache-hive-2.3.7-bin.tar.gz)复制到下载中
hive下载地址
sudo tar -zxvf ./apache-hive-2.3.7-bin.tar.gz -C /usr/local # 解压到/usr/local中
cd /usr/local/
sudo mv apache-hive-2.3.7-bin hive # 将文件夹名改为hive
sudo chown -R hadoop:hadoop hive # 修改文件权限
修改bashrc文件
vim ~/.bashrc
在里面添加以下内容
export HIVE_HOME=/usr/local/hive
export PATH=$PATH:$HIVE_HOME/bin
然后source
进入hive的conf里修改文件
source ~/.bashrc
cd /usr/local/hive/conf
sudo mv hive-default.xml.template hive-default.xml
cd /usr/local/hive/conf
vim hive-site.xml
在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://localhost:3306/hive?createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.cj.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hive</value>
<description>password to use against metastore database</description>
</property>
</configuration>
根据自己的Ubuntu版本下载对应的mysql-connector-java-8.0.22.deb
mysql-connector-java-8.0.22.deb下载地址
然后用文档打开,找到里面的mysql-connector-java-8.0.22-bin.jar
这个是与mysql进行连接 (要mysql是8.0…版本的)
#下面将mysql-connector-java-8.0.22-bin.jar拷贝到/usr/local/hive/lib目录下
cp mysql-connector-java-8.0.22-bin.jar /usr/local/hive/lib
启动mysql
service mysql start #启动MySQL服务
sudo cat /etc/mysql/debian.cnf #查看账户密码
mysql -u账号 -p密码
登录后在里面输入
create database hive;
CREATE USER 'hive'@'%' IDENTIFIED BY 'hive';
grant all privileges on *.* to 'hive'@'%';
flush privileges;
启动hdfs
进入hive
cd /usr/local/hadoop
./sbin/start-dfs.sh
cd /usr/local/hive
./bin/hive
hive
进入hive之后
show databases;
如果报错的话
初始化元数据
schematool -dbType mysql -initSchema
再进入hive