链接：https://pan.baidu.com/s/1GbDUUvOpFfpgV18szmx1LA 

提取码：uvxy 

 

1、把 apache-hive-1.2.1-bin.tar.gz 上传到 linux 的/opt/SoftWare/Hive ⽬录下 1 cd /opt/SoftWare/Hive 2 rz 2、解压 apache-hive-1.2.1-bin.tar.gz 1 cd /opt/SoftWare/Hive 2 tar -zxvf apache-hive-1.2.1-bin.tar.gz 3、修改 apache-hive-1.2.1-bin名称为hive-1.2.1 1 mv apache-hive-1.2.1-bin hive-1.2.1 4、修改/opt/SoftWare/Hive/hive-1.2.1/conf ⽬录下的 hive-env.sh.template 名称为 hive-env.sh 1 cd /opt/SoftWare/Hive/hive-1.2.1/conf 2 mv hive-env.sh.template hive-env.sh 5、配置 hive-env.sh ⽂件 1 cd /opt/SoftWare/Hive/hive-1.2.1/conf 2 vim hive-env.sh 3 配置 HADOOP_HOME 路径 4 export HADOOP_HOME=/opt/SoftWare/Hadoop/hadoop-2.7.7 5 配置 HIVE_CONF_DIR 路径 6 export HIVE_CONF_DIR=/opt/SoftWare/Hive/hive-1.2.1/conf 6、配置Hive的全局变量 1 vim /etc/profile 2 添加 3 export HIVE_HOME=/opt/SoftWare/Hive/hive-1.2.1 4 export PATH=$PATH:$HIVE_HOME/bin 1

5 source /ect/profile 7、启动hive 1 start-yarn.sh 2 start-dfs.sh 3 hive 8、退出hive，关闭hadopp 集群 1 exit; 2 stope-yarn.sh 3 stop-dfs.sh 9、离线安装MySQL mysql下载地址 ①、下载这个版本 ②、下载这个 ③、点击箭头指示位置即可下载 2

④、创建⽬录，上传安装包 1 mkdir /opt/SoftWare/MyQL/ 2 cd /opt/SoftWare/MyQL/ 3 将mysql上传到指定⽬录 4 rz ⑤、解压,安装 1 tar -xvf mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar 2 批量安装 3 yum localinstall *.rpm ⑥、启动 1 systemctl start mysqld ⑦、查看默认密码 3

1 grep 'temporary password' /var/log/mysqld.log ⑧、使⽤默认密码登录MySQL之后，可对密码进⾏修改。 ⼗、将mysql驱动拷⻉到hive的lib包下 1 cp mysql-connector-java.jar /opt/SoftWare/Hive/hive-1.2.1/lib ⼗⼀、在/opt/SoftWare/Hive/hive-1.2.1/conf下新建⼀个⽂件hive-site.xml 1 touch hive-site.xml ⼗⼆、配置Metastore 到 MySql，为hive-site.xml⽂件写⼊配置信息 1 vim hive-site.xml 1 <configuration> 2 <property> 3 <name>javax.jdo.option.ConnectionURL</name> 4 <value>jdbc:mysql://node01:3306/metastore?createDatabaseIfNotExi st=true</value> 5 <description>JDBC connect string for a JDBC metastore</descripti on> 6 </property> 78 <property> 9 <name>javax.jdo.option.ConnectionDriverName</name> 10 <value>com.mysql.jdbc.Driver</value> 11 <description>Driver class name for a JDBC metastore</description > 12 </property> 1314 <property> 15 <name>javax.jdo.option.ConnectionUserName</name> 16 <value>root</value> 17 <description>username to use against metastore database</descrip tion>