Spark项目之环境搭建（单机）二 hive-2.3.3安装

1
tar -zxf apache-hive-2.3.3-bin.tar.gz hive

1
mv apache-hive-2.3.3-bin hive

1
cd /home/hive/conf/

1
2
3
4
5
cp hive-env.sh.template hive-env.sh
cp hive-default.xml.template hive-site.xml
cp hive-log4j2.properties.template hive-log4j2.properties
cp hive-exec-log4j2.properties.template hive-exec-log4j2.properties

1
2
3
4
5
6
7
#jdk
export JAVA_HOME=/home/jdk
#hadoop
export HADOOP_HOME=/home/hadoop
#hive
export HIVE_HOME=/home/hive

1
2
3
4
5
6
7
hdfs dfs -mkdir -p /user/hive/warehouse
hdfs dfs -mkdir -p /user/hive/tmp
hdfs dfs -mkdir -p /user/hive/log
hdfs dfs -chmod -R 777 /user/hive/warehouse
hdfs dfs -chmod -R 777 /user/hive/tmp
hdfs dfs -chmod -R 777 /user/hive/log

1
vi hive-site.xml

1
2
3
4
5
6
7
8
9
10
11
12
13
<property>
    <name>hive.exec.scratchdir</name>
    <value>/user/hive/tmp</value>
</property>
<property>
    <name>hive.metastore.warehouse.dir</name>
    <value>/user/hive/warehouse</value>
</property>
<property>
    <name>hive.querylog.location</name>
    <value>/user/hive/log</value>
</property>

1
mkdir /home/hive/tmp

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&amp;characterEncoding=UTF-8&amp;useSSL=false</value>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>root</value>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>root</value>
  </property>

1
2
 vi /etc/profile

1
2
3
4
#hive
export HIVE_HOME=/home/hive
export PATH=$HIVE_HOME/bin:$HIVE_HOME/conf:$PATH

1
source /etc/profile

1
schematool -dbType mysql -initSchema

1
hive