Hadoop大数据开发__Hive的安装部署

1、准备Mysql数据库

#自行准备，这里不做说明

2、下载解压Hive

cd /home/hadoop/app
tar -zxvf apache-hive-3.1.3-bin.tar.gz
rm apache-hive-3.1.3-bin.tar.gz
ln -s apache-hive-3.1.3-bin hive

3、修改Hive配置文件

cd /home/hadoop/app/hive/conf

修改hive-site.xml

<property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://11.11.11.12:3306/hive?createDatabaseIfNotExit=true</value>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>root</value>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>123456</value>
  </property>
  <property>
    <name>hive.querylog.location</name>
    <value>/home/hadoop/app/hive/iotmp</value>
  </property>
  <property>
    <name>hive.exec.local.scratchdir</name>
    <value>/home/hadoop/app/hive/iotmp</value>
  </property>
  <property>
    <name>hive.downloaded.resources.dir</name>
    <value>/home/hadoop/app/hive/iotmp</value>
  </property>
  <property>
    <name>datanucleus.schema.autoCreateAll</name>
    <value>true</value>
  </property>

配置hive的环境变量

JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
ZOOKEEPER_HOME=/home/hadoop/app/zookeeper
HADOOP_HOME=/home/hadoop/app/hadoop
HBASE_HOME=/home/hadoop/app/hbase
HIVE_HOME=/home/hadoop/app/hive
CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
PATH=$JAVA_HOME/bin:$HADOOP_HOME/bin:$ZOOKEEPER_HOME/bin:$HBASE_HOME/bin:$HIVE_HOME/bin:$PATH
export JAVA_HOME CLASSPATH HADOOP_HOME ZOOKEEPER_HOME HBASE_HOME HIVE_HOME

4、复制mysql-connector-java-5.1.35.jar到lib下

cd /home/hadoop/app/hive/lib #自己下载，自己复制

5、hive元数据库初始化

cd /home/hadoop/app/hive/bin
schematool -dbType mysql -initSchem

6、启动hive

cd /home/hadoop/app/hive/bin
hive
hive>show databases;