linux hive安装部署

安装MYSQL
创建用户
赋予新用户权限

grant all privileges on *.*  'hive'@'%' identified by 'hive';
flush privileges;

在hdfs上创建目录
/user/hive/warehouse
/user/hive/tmp

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

解压
tar -zxvf apache-hive-3.1.1-bin.tar.gz

配置：
cp hive-default.xml.template hive-site.xml
vi hive-site.xml

<configuration>
    <property>
      <name>javax.jdo.option.ConnectionURL</name>
      <value>jdbc:mysql://node1.paa.name:3306/metastoreforhive?createDatabaseIfNotExist=true</value>
      <description>the URL of the MySQL database</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>
 </property>
 <property>
      <name>javax.jdo.option.ConnectionPassword</name>
   <value>hive</value>
 </property>
 <property>
   <name>hive.metastore.warehouse.dir</name>
   <value>/user/hive/warehouse</value>
 </property>
 <property>
   <name>hive.exec.scratchdir</name>
   <value>/user/hive/tmp</value>
 </property>
 </configuration>

vi hive-env.sh
HADOOP_HOME=/data1/soft/hadoop/hadoop
export HIVE_CONF_DIR=/data1/soft/apache-hive-3.1.1-bin/conf

从MySQL官网下载jar包
解压：
mysql-connector-java-8.0.15.tar.gz
mysql-connector-java-8.0.15
mysql-connector-java-8.0.15.jar
将jar包放入/data1/soft/apache-hive-3.1.1-bin/lib目录下

hive/bin目录下执行：
./schematool -dbType mysql -initSchema

启动hive