Ubuntu18.04 部署Hive

1. Hive 安装

下载地址：http://hive.apache.org/downloads.html

1.1 安装Hive

解压 apache-hive-3.1.1-bin.tar.gz 到 /opt 目录

sudo tar -zxvf apache-hive-3.1.1-bin.tar.gz /opt
sudo mv /opt/apache-hive-3.1.1 /opt/hive
sudo chown -R hadoop:hadoop /opt/hive  

修改环境变量

sudo gedit /etc/profile

export HIVE_HOME=/opt/hive
export PATH=$HIVE_HOME/bin:$PATH

刷新环境变量

source /etc/profile

1.2 配置Hive

1.2.1 配置 hive-site.xml

cd /opt/hive/conf
touch hive-site.xml

添加如下内容

<configuration>
  <property>
      <name>javax.jdo.option.ConnectionURL</name>
      <value>jdbc:mysql://master:3306/hive?createDatabaseIfNotExist=true&amp;useSSL=true</value>
      <description>JDBC connect string for a JDBC metastore</description>    
  </property>
  <property> 
      <name>javax.jdo.option.ConnectionDriverName</name> 
      <value>com.mysql.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>

1.2.2 添加mysql 驱动包

将mysql-connector-java-5.1.46-bin.jar放到HIVE_HOME的lib目录下

1.2.3 格式化元数据（初始化）

cd /opt/hive/bin
./schematool -dbType mysql -initSchema

1.3 启动Hive

cd /opt/hive/bin
./hive