hive hadoop部署

先决条件：

 1. 已安装hadoop就去哪
 2. 已安装mysql数据库
 3. 在mysql数据库中创建hive数据库

1：在hive官网下载一个2.几版本 我这里是下载的2.1.1
2：将mysql的java驱动包放到hive的解压包下的lib目录（里面是hive的依赖包）
3：修改配置文件
在hive/conf目录中新建hive-site.xml，内容如下

<configuration>
          <property>
    <name>hive.metastore.schema.verification</name>
    <value>false</value>
    <description>
      Enforce metastore schema version consistency.
      True: Verify that version information stored in is compatible with one from Hive jars.  Also disable automatic
            schema migration attempt. Users are required to manually migrate schema after Hive upgrade which ensures
            proper metastore schema migration. (Default)
      False: Warn if the version information stored in metastore doesn't match with one from in Hive jars.
    </description>
  </property>
  //mysql服务器地址
        <property>
                <name>javax.jdo.option.ConnectionURL</name>
                <value>jdbc:mysql://localhost:3306/hive?createDatebaseIfNotExist=true</value>
                <description>jdbc</description>
        </property>
        <property>
                <name>javax.jdo.option.ConnectionDriverName</name>
                <value>com.mysql.jdbc.Driver</value>
                <description>driver class</description>
        </property>
        <property>
                <name>javax.jdo.option.ConnectionUserName</name>
                <value>admin</value>
                <description>jdbc</description>
        </property>
        <property>
                <name>javax.jdo.option.ConnectionPassword</name>
                <value>admin</value>
                <description>jdbc</description>
        </property>
</configuration>

4：在hadoop集群上初始化hive

//该bin目录实在hive下的
./bin/schematool -initSchema -dbType mysql

5：然后如下图