Install Hive using Mysql as metadata store On Ubuntu.

This post is about the installation of Hive and use mysql as the metadata store on ubuntu. The environment of my system is ubuntu 12.04, hadoop 1.0.3, hive 0.9.0 and mysql 5.5.

The detail information of installation describes as follows:

step 1: install mysql

$ sudo apt-get install mysql-server

step 2: restart mysql service

$ sudo /etc/init.d/mysql restart or sudo service mysql restart

step 3: modify the configure file of hive hive-site.xml as follows:

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

<configuration>
    <property>
        <name>hive.metastore.local</name>
        <value>true</value>
    </property>
    <property&