Hadoop环境搭建----（Hive安装与配置）

下载地址
http://mirror.bit.edu.cn/apache/hive/hive-2.3.4/apache-hive-2.3.4-bin.tar.gz

解压到
/data/hadoop/apache-hive/
修改配置文件

cd /data/hadoop/apache-hive/conf/
cp hive-env.sh.template
vim hive-env.sh

#添加hadoop变量
export HADOOP_HOME=/data/hadoop/hadoop-2.7.7

vim  hive-site.xml

#配置链接mysql数据库
<configuration>
        <property>
                  <name>javax.jdo.option.ConnectionURL</name>
                  <value>jdbc:mysql://127.0.0.1:3306/hive?createDatabaseIfNotExist=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>user</value>
              <description>username TOUSE against metastore database</description>
        </property>


        <property>
                    <name>javax.jdo.option.ConnectionPassword</name>
                    #数据库密码
                    <value>passwd</value>
                   <description>password TOUSE against metastore database</description>
        </property>

        <property>
                <name>hive.exec.parallel</name>
                <value>true</value>
        </property>
       <property>
		<name>hive.metastore.schema.verification</name>
		<value>false</value>
      </property>
</configuration>

加入mysql插件
链接：https://pan.baidu.com/s/1LX8c2hKxKPY6moBTzLHedQ
提取码：q5oh
上传到
/data/hadoop/apache-hive/lib

hive元数据库初始化

cd /data/hadoop/apache-hive/bin
./schematool -dbType mysql -initSchema

启动进入hive库

./hive

测试

hive> show databases;
hive> create database dalu;
hive> show databases;

后台运行hive服务

nohup hiveserver2 &