hive的配置

1.下载apache-hive-2.1.1-bin.tar.gz
2.tar开

    $>tar -xzvf apache-hive-2.1.1-bin.tar.gz -C /zdq
    $>cd /zdq/apache-hive-2.1.1-bin
    $>ln -s apache-hive-2.1.1-bin hive

3.配置环境变量

    [/etc/profile]
    HIVE_HOME=/zdq/hive
    PATH=....:$HIVE_HOME/bin
    //刷新环境变量
    source /etc/profile

4.配置hive，使用mysql存放hive的元数据
4.1复制mysql驱动程序到hive的lib目录下。
…..
4.2复制hive/conf下的hive-default.xml.template为hive-site.xml
4.2修改hive/conf/hive-site.xml
关于mysql的

        <property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>zoudaiqiang</value>
        <description>password to use against metastore database</description>
    </property>
    <property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>root</value>
        <description>Username to use against metastore database</description>
    </property>
    <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:mysql://192.168.3.203:3306/hive</value>
        <description>
            JDBC connect string for a JDBC metastore.
            To use SSL to encrypt/authenticate the connection, provide database-specific SSL flag in the connection URL.
            For example, jdbc:postgresql://myhost/db?ssl=true for postgres database.
        </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>

修改${system….等字样的路径。修改路径
4.3在mysql创建存放hive信息的数据库

mysql>create database hive;

4.4初始化hive的元数据（表结构）到mysql中。

$>schematool -dbType mysql -initSchema

4.5查看mysql是否存在表结构