下载hive安装包
https://hive.apache.org/downloads.html
安装
1.上传安装包到服务器
path:/home/hadoop/applications/hive
2.解压
>tar -xzvf apache-hive-1.2.2.bin.tar.gz
3.创建软连接
>su root
>ln -s /home/hadoop/applications/hive/apache-hive-1.2.2-bin /usr/local/hive
>chown -R hadoop:hadoop /usr/local/hive
4.配置环境变量
export HIVE_HOME=/usr/local/hive
export PATH=$HIVE_HOME/bin:$PATH
>source /etc/profile
>su hadoop
5.配置mysql数据源
>cd /usr/local/hive/conf
>echo >> hive-site.xml
>vim hive-site.xml
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<!--<value>jdbc:mysql://192.168.58.5:3306/hadoop03_hive?createDatabaseIfNotExist=true&serverTimezone=Asia/Shanghai&characterEncoding=utf8&useSSL=false</value>-->
<value>jdbc:mysql://192.168.58.5:3306/hadoop03_hive?createDatabaseIfNotExist=true&useSSL=false</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>root</value>
</property>
</configuration>
6.创建hdfs目录
>hadoop fs -mkdir -p /user/hive/warehouse
7.启动hive客户端
>hive