hive配置mysql数据源作为元数据库

1.install mysql

       yum install mysql

yum install mysql-server

yum install mysql-devel

chgrp -R mysql /var/lib/mysql

chmod -R 770 /var/lib/mysql

service mysqld start 

mysql

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('secret_password');

2.安装hive

          1，下载wget http://labs.renren.com/apache-mirror//hive/stable/hive-0.8.1.tar.gz

            

            2，解压tar -zxvf hive-0.7.0.tar.gz（注意文件用户权限，和hadoop不一致要修改）

 

            3,配置conf/hive-env.sh.template

               export HADOOP_HOME=/usr/local/hadoop-0.20.203.0

               export HIVE_HOME =/usr/local/hadoop-0.20.203.0/hive-0.8.1

               export JAVA_HOME=/usr/local/jdk1.6.0_25

            4,在hive目录下执行bin/hive测试成功是否

               Hive history file=/tmp/tmg/hive_job_log_tmg_201105241042_506926685.txt
               hive>

               执行show tables;

               OK
               Time taken: 1.482 seconds

        安装完成，是不是很easy!

3.配置hive元数据库

  修改配置文件hive-site.xml

        <property>

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

 <!-- <value>jdbc:derby:;databaseName=metastore_db;create=true</value>-->

  <value>jdbc:mysql://172.16.80.19:3306/hive?createDatabaseIfNotExist=true</value>

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

</property>

 

<property>

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

  <!--<value>org.apache.derby.jdbc.EmbeddedDriver</value>-->

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

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

</property>

  下载mysql driver到hive-home/lib目录下

 

   启动hive --service hwi

执行

   http://ip:9999/hwi

   能正常看到如下：

     

User Authorize Browse Schema Create Session Diagnostics List Sessions

Database List default

 

后台会提示mysql数据库创建成功。