Hive-0.12.0 配置Mysql的Metasotre

#注意：如果安装mysql完整的server-client，yum执行yum -y install mysql-server 如果，仅仅安装客户端yum -y install mysql即可
#这里我们安装完整的mysql-server
$sudo yum -y install mysql-server
#设置开机自启动
$sudo /sbin/chkconfig --add mysqld
$sudo /sbin/chkconfig mysqld on  
$sudo /sbin/service mysqld start
#设置初始root密码
$sudo mysqladmin -u root password ‘a123456‘

$mysql -uroot -pa123456

#创建DB for Hive MetaStore
mysql> create database hive_metastore;
#给予mysql root用户以master.hadoop上的所有权限,本机hostname为master.hadoop
mysql> grant all privileges on *.* to ‘root‘@‘master.hadoop‘ identified by ‘a123456‘;
mysql> flush privileges;

[hadoop@master ~]$ tar -xzvf hive-0.12.0.tar.gz
[hadoop@master ~]$ cd hive-0.12.0/
[hadoop@master hive-0.12.0]$ pwd
/home/hadoop/hive-0.12.0  

#修改/etc/profile 添加HIVE_HOME环境变量，并将Hive的bin添加到PATH中
[hadoop@master hive-0.12.0]$ sudo vim /etc/profile
#在最后追加：
#hive-0.12.0
export HIVE_HOME=/home/hadoop/hive-0.12.0
export PATH=${PATH}:${HIVE_HOME}/bin

#编辑完之后到shell下执行：
[hadoop@master hive-0.12.0]$ source /etc/profile

[hadoop@master hive-0.12.0]$ cd conf/
[hadoop@master conf]$ cp hive-default.xml.template hive-site.xml 

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://master.hadoop/hive_metastore?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>root</value>
  <description>username to use against metastore database</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>a123456</value>
  <description>password to use against metastore database</description>
</property>

[hadoop@master]$ cp mysql-connector-java-5.1.9.jar $HIVE_HOME/lib/

<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>