hive的安装与配置

1.安装mysql

2.上传hive包到/opt下，并解压

链接：百度网盘
提取码：ioqq

tar -zxvf hive-1.2.1.tar.gz

3.配置hive-env.sh

cd /opt/hive/conf
cp hive-env.sh.template hive-env.sh
vim hive-env.sh

4.配置hive-site.xml

<configuration>
        <property> 
                <name>javax.jdo.option.ConnectionURL</name> 
                <value>jdbc:mysql://hadoop01:3306/hive_db?createDatabaseIfNotExist=true&amp;characterEncoding=UTF-8</value> 
        </property> 
        <property> 
                <name>javax.jdo.option.ConnectionDriverName</name> 
                <value>com.mysql.jdbc.Driver</value> 
                <description>驱动名</description> 
        </property> 
        <property> 
                <name>javax.jdo.option.ConnectionUserName</name> 
                <value>root</value> 
                <description>用户名</description> 
        </property> 
        <property> 
                <name>javax.jdo.option.ConnectionPassword</name> 
                <value>root</value> 
                <description>密码</description> 
        </property> 
        <property> 
                <name>hive.metastore.warehouse.dir</name> 
                <value>/user/hive/warehouse</value> 
                <description>数据路径（相对hdfs）</description> 
        </property>
        <property>
                <name>hive.metastore.uris</name>
                <value>thrift://192.168.223.129:9083</value> 
                <description>运行hive的主机地址及端口</description>
        </property> 
</configuration>

5.将mysql-connector-java.jar放到hive/lib下

cd /opt/hive/lib

链接：百度网盘
提取码：yge3

6.将/hive/lib/jline-2.12.jar 替换掉/hadoop/share/hadoop/yarn/lib/jline-0.9.jar

cp -r /hive/lib/jline-2.12.jar /hadoop/share/hadoop/yarn/lib

7.启动hadoop集群

8.启动hive

cd /opt/hive
bin/hive

创建database