Hive部署

1、下载安装包到software

curl -O http://archive.cloudera.com/cdh5/cdh/5/hive-1.1.0-cdh5.15.1.tar.gz

2、解压到~/application

tar -zxvf hive-1.1.0-cdh5.15.1.tar.gz -C ~/application

3、添加系统环境变量

sudo vim ~/.bash_profile
# Setting Path for Hive
export HIVE_HOME=~/application/hive-1.1.0-cdh5.15.1
export PATH=$PATH:$HIVE_HOME/bin
source ~/.bash_profile

4、配置Hive

cd ~/application/hive-1.1.0-cdh5.15.1/conf

1）修改hive-env.sh
vim hive-env.sh
    export JAVA_HOME=$JAVA_HOME

2）修改hive-site.xml
vim hive-site.xml
    <property>
        <name>fs.defaultFS</name>
        <value>hdfs://127.0.0.1:8020</value>
    </property>

3）修改hdfs-site.xml
vim hdfs-site.xml
    <?xml version="1.0"?>
    <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
    
    <configuration>
        <property>
            <name>javax.jdo.option.ConnectionURL</name>
            <value>jdbc:mysql://127.0.0.1:3306/hadoop_hive?createDatabaseIfNotExist=true</value>
        </property>
        
        <property>
            <name>javax.jdo.option.ConnectionDriverName</name>
            <value>com.mysql.cj.jdbc.Driver</value>
        </property>
        
        <property>
            <name>javax.jdo.option.ConnectionUserName</name>
            <value>root</value>
        </property>
        
        <property>
            <name>javax.jdo.option.ConnectionPassword</name>
            <value>root</value>
        </property>
    </configuration>

5、下载MySQL驱动包

curl -O https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.17.tar.gz

6、拷贝MySQL驱动包到$HIVE_HOME/lib

tar -zxvf mysql-connector-java-8.0.17.tar.gz
cp mysql-connector-java-8.0.17/mysql-connector-java-8.0.17.jar $HIVE_HOME/lib

7、Hive 初始化MySQL数据库

schematool -dbType mysql -initSchema

8、启动Hive

hive
hive>