安装hive
sudo hostnamectl set-hostname hadoop31::修改主机名为hadoop31
配置静态ip
到 vim /etc/sysconfig/network-scripts /ifcfg-enp0s8目录下
没有的话复制ifcfg-enp0s3改名为ifcfg-enp0s8 ::cp ifcfg-enp0s3 ifcfg-enp0s8
:wq退出
service network restart::重启网卡。可能会冲突,最好重启系统
正式开始
在/app解压tar -zxf ~/apache-hive-1.2.2-bin.tar.gz -C .
mv apache-hive-1.2.2-bin/ hive-1.2.2::改名
配置环境变量
sudo vim /etc/profile.d/hadoop.sh
export HIVE_HOME=/app/hive-1.2.2
export PATH=$PATH:$HIVE_HOME/bin
之后
让给环境变量生效 source /etc/profile
到/app/hive-1.2.2/conf目录下复制上面改为下面
hive-site.xml里面的内容
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<!--mysql密码-->
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.56.1:3306/hive31?characterEncoding=UTF-8&useUnicode=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>
</configuration>
把mysql 的jar包放到lib下
启动hadoop :: /app/hadoop-2.7.6/sbin/start-dfs.sh
msql设置远程连接
root密码登陆后
use mysql;
update user set host='%' where user='root' and host='localhost';
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;
之后在linux界面输入hive显示如下界面(注意脑症hadoop开启)