一、下载安装包

wget http://archive.cloudera.com/cdh5/cdh/5/hive-1.1.0-cdh5.7.0.tar.gz或者rz 上传本地包到linux系统

2019-07-17_090753.png

二、解压安装包

[hadoop@Hadoop001 software]$ tar -zxvf hive-1.1.0-cdh5.7.0.tar.gz 
[hadoop@Hadoop001 software]$ ln -s /home/hadoop/software/hive-1.1.0-cdh5.7.0 /home/hadoop/app/hive
[hadoop@Hadoop001 app]$ ll
lrwxrwxrwx 1 hadoop hadoop 41 Jul 17 00:00 hive -> /home/hadoop/software/hive-1.1.0-cdh5.7.0

三、配置hive环境变量

[hadoop@Hadoop001 ~]$ vi .bash_profile
export HIVE_HOME=/home/hadoop/app/hive
export PATH=$HIVE_HOME/bin:$PATH

四、拷贝mysql驱动包到lib目录下

驱动包下载地址:
https://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.38/mysql-connector-java-5.1.38.jar

[hadoop@Hadoop001 lib]$ ll
-rw-rw-r--  1 hadoop hadoop   983911 Dec  2  2015 mysql-connector-java-5.1.38.jar

五、安装mysql

参考:https://www.jianshu.com/p/ab46f06cfc37

六、修改hive的配置文件

[hadoop@Hadoop001 conf]$ cp hive-env.sh.template hive-env.sh
[hadoop@Hadoop001 conf]$ vi hive-env.sh
HADOOP_HOME=/home/hadoop/app/hadoop
export HIVE_CONF_DIR=/home/hadoop/app/hive/conf
[hadoop@Hadoop001 conf]$ vi hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
        <property>
                <name>javax.jdo.option.ConnectionURL</name>
                <value>jdbc:mysql://192.168.174.130:3306/hive?createDatabaseIfNotExist=true</value>
        </property>
        <property>
                <name>javax.jdo.option.ConnectionDriverName</name>
                <value>com.mysql.jdbc.Driver</value>
                </property>
        <property>
                <name>javax.jdo.option.ConnectionUserName</name>
                <value>root</value>
        </property>
        <property>
                <name>javax.jdo.option.ConnectionPassword</name>
                <value>123456</value>
        </property>
        <property>
                <name>hive.cli.print.current.db</name>
                <value>true</value>
        </property>
        <property>
                <name>hive.cli.print.header</name>
                <value>true</value>
        </property>
</configuration>
[hadoop@Hadoop001 conf]$ cp hive-log4j.properties.template hive-log4j.properties
[hadoop@Hadoop001 hive]$ mkdir logs
[hadoop@Hadoop001 conf]$ vi hive-log4j.properties
hive.log.dir=/home/hadoop/app/hive/logs

七、启动hive

注意先开启hdfs，yarn

[hadoop@Hadoop001 bin]$ hive