linux 安装 Hive 3.1.2

在安装完Hadoop（https://www.cnblogs.com/cz-xjw/p/16287905.html）之后，安装Hive

cd /opt/software
#下载
wget https://dlcdn.apache.org/hive/hive-3.1.2/apache-hive-3.1.2-bin.tar.gz
#解压
tar -xzvf apache-hive-3.1.2-bin.tar.gz -C /opt/module

cd ../module

mv apache-hive-3.1.2-bin apache-hive-3.1.2

cd apache-hive-3.1.2

vim /etc/profile
#新增如下两行
export HIVE_HOME=/opt/module/apache-hive-3.1.2
PATH=$HIVE_HOME:$PATH

#刷新配置
source /etc/profile

#创建hive-site.xml配置

cd config
touch 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.ConnectionURLname>
    <value>jdbc:mysql://10.15.208.150:3306/hive?createDatabaseIfNotExist=truevalue>
    <description>JDBC connect string for a JDBC metastoredescription>
  property>
  <property>
    <name>javax.jdo.option.ConnectionDriverNamename>
    <value>com.mysql.cj.jdbc.Drivervalue>
    <description>Driver class name for a JDBC metastoredescription>
  property>
  <property>
    <name>javax.jdo.option.ConnectionUserNamename>
    <value>rootvalue>
    <description>username to use against metastore databasedescription>
  property>
  <property>
    <name>javax.jdo.option.ConnectionPasswordname>
    <value>12345678value>
    <description>password to use against metastore databasedescription>
  property>
configuration>

 创建临时目录

$HADOOP_HOME/bin/hadoop fs -mkdir       /tmp
$HADOOP_HOME/bin/hadoop fs -mkdir       /user/hive/warehouse
$HADOOP_HOME/bin/hadoop fs -chmod g+w   /tmp
$HADOOP_HOME/bin/hadoop fs -chmod g+w   /user/hive/warehouse

 下载mysql连接驱动包

cd /opt/module/apache-hive-3.1.2/lib
wget https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.19/mysql-connector-java-8.0.19.jar

 复制hadoop的guava包到hive的lib目录

cp /opt/module/hadoop/share/hadoop/common/lib/guava-27.0-jre.jar /opt/module/apache-hive-3.1.2/lib/

 初始化hive的Metastore架构

cd /opt/module/apache-hive-3.1.2/bin

schematool -dbType mysql -initSchema