MySQL的方式,需要将MySQL的jar包拷贝到$HIVE_HOME/bin目录下。
一、MySQL的安装
rpm -qa|grep mysql 查看是否安装了mysql.
rpm -e mysql-server-5.1.73-5.el6_6.x86_64 卸载mysql
rpm -e mysql-5.1.73-5.el6_6.x86_64
rpm -e mysql-libs-5.1.73-5.el6_6.x86_64
安装MySQL:
yum install mysql-server
service mysqld restart
mysql -uroot -p
use mysql
select user,host from user;
delete from user where user=''
update user set password=PASSWORD(‘123456’) where user='root';改密码
flush privileges;全域刷新
二、本地MySQL模式
这种模式需要在本地运行一个MySQL服务器,并做如下配置(用户是root,密码是123456):
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive_remote/warehouse</value>
</property>
<property>
<name>hive.metastore.local</name>
<value>true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.57.4: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>
</configuration>