Ubuntu安装配置hive

安装的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