1.mysql 的安装
安装mysql只需要执行以下几步:
apt-get install mysql-server,mysql-client(ubuntu平台)
安装之后配置/etc/mysql/my.cnf
bind-address 0.0.0.0
使用root 用户登陆mysql,
create user 'hive' identified by 'hive';
grant all privileges on *.* to 'hive' with grant option;
flush privileges;
使用hive账号登陆mysql
mysql -u hive -p
create database hive;
2. 安装hive-1.x
首先下载hive ,并解压
进入 conf中,新建一个文件 hive-site.xml,配置如下
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hive</value>
<description>password to use against metastore database</description>
</property>
</configuration>
在profile.d下新建文件hive.sh
配置如下:
#hive-1.2.2
export HIVE_HOME=/home/hadoop/apache-hive-1.2.2-bin
export PATH=$PATH:$HIVE_HOME/bin
将lib下的jline-*.jar拷贝到/hadoop-2.x/share/hadoop/yarn/lib,同时删除旧版本的jar包。
下载mysql的连接jar包,放入hive的lib中。
拷贝到slave节点上
scp -R apache-hive-1.x hadoop@slave:/home/hadoop/
配置hive-site.xml
<configuration>
<property>
<name>hive.metastore.uris</name>
<value>thrift://master:9083</value>
</property>
</configuration>
启动hive :
hive --serive metastore &