Hive+Mysql搭建

HOST	Hive	Mysql	OS
hadoop2	1		Ubuntu 14.0
hadoop7		1	Centos 7

Mysql 安装配置：

yum -y install mariadb-server mariadb-devel

systemctl enable mariadb.service

systemctl start mariadb.service

mysql -e "create database hive default charset=utf8"

mysql -e "grant all on hive.* to 'hive'@'%' identified by '12345'"

Hive配置：

vim $HIVE_HOME/conf/hive-site.xml

<configuration>

<property>

    <name>javax.jdo.option.ConnectionURL</name>

    <value>jdbc:mysql://hadoop7:3306/hive</value>

    <description>JDBC connect string for a JDBC metastore</description>

  </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>12345</value>

    <description>password to use against metastore database</description>

  </property>

</configuration>