hadoop2.2.0的基础上配置hive0.12.0（支持mysql）

本文链接：https://blog.csdn.net/glgl2424/article/details/25679915

前提：已经安装好了hadoop2.2.0，当然也可以是其他版本的hadoop，作者使用的是这个版本，并在vmware上配了一个master和3个slaver。配置方式参考：

http://blog.csdn.net/glgl2424/article/details/24868273

一、下载hive-0.12.0，并解压到/usr/hive中

二、将hive-default.xml.template拷贝一份并重命名为hive-site.xml，同样，将hive-env.sh.template拷贝一份并重命名为hive-env.sh

三、修改2个配置文件，env,sh主要是修改环境变量，而-site.xml主要是修改hive的元数据库配置（本文以配置mysql作为元数据）

关键配置如下：(-site.xml)

<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</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>hive</value>
<description>password to use against metastore database</description>
</property>

<property>
<name>hive.stats.dbclass</name>
<value>jdbc:mysql</value>
<description>The default database that stores temporary hive statistics.</description>
</property>

<property>
<name>hive.stats.jdbcdriver</name>
<value>com.mysql.jdbc.Driver</value>
<description>The JDBC driver for the database that stores temporary hive statistics.</description>
</property>

<property>
<name>hive.stats.dbconnectionstring</name>
<value>jdbc:mysql://localhost:3306/hive_stats?useUnicode=true&characterEncoding=latin1&user=mysql_username&password=mysql_password&createDatabaseIfNotExist=true</value>
<description>The default connection string for the database that stores temporary hive statistics.</description>
</property>

<property>
<name>hive.server2.thrift.sasl.qop</name>
<value>auth</value>
<description>Sasl QOP value; Set it to one of following values to enable higher levels of
protection for hive server2 communication with clients.
"auth" - authentication only (default)
"auth-int" - authentication plus integrity protection
"auth-conf" - authentication plus integrity and confidentiality protection
This is applicable only hive server2 is configured to use kerberos authentication.
</description>
</property>

<property>
<name>hive.metastore.schema.verification</name>
<value>false</value>
<description>
Enforce metastore schema version consistency.
True: Verify that version information stored in metastore matches with one from Hive jars. Also disable automatic
schema migration attempt. Users are required to manully migrate schema after Hive upgrade which ensures
proper metastore schema migration. (Default)
False: Warn if the version information stored in metastore doesn't match with one from in Hive jars.
</description>
</property>

ps:hive在hadoop中的路径可以默认不修改，env中java-home类似的配置可以省略，因为hadoop时已经配置了

HADOOP_HOME=/usr/hadoop
export HIVE_CONF_DIR=/usr/hive/conf

四：安装mysql并添加hive账号（账号密码都是hive）

1、执行yum install mysql-connector-java命令，自动安装mysql

2、将/usr/share/java/mysql-connector-java-5.1.17.jar拷贝到hive的lib目录既可

3、添加用户：

•create database hive

•创建hive用户,并授权

•grant all on hive.* to hive@'%' identified by 'hive';

•flush privileges;

五、启动hive，第一次启动会报错，后续就正确了

六、验证：