Install Hive using Mysql as metadata store On Ubuntu.

Love The Way You Lie 2022-04-24 07:44 157阅读 0赞

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>
            <name>javax.jdo.option.ConnectionURL</name>
            <value>jdbc:mysql://localhost:3306/hive?characterEncoding=UTF-8</value>
        </property>
        <property>
            <name>javax.jdo.option.ConnectionDriverName</name>
            <value>com.mysql.jdbc.Driver</value>
        </property>
        <property>
            <name>javax.jdo.option.ConnectionUserName</name>
            <value>root</value>
        </property>
        <property>
            <name>javax.jdo.option.ConnectionPassword</name>
            <value>mysql</value>
        </property>
    </configuration>

**step 4:** copy the mysql jdbc package to the directory hive-0.9.0/lib.

$ sudo cp *.jar /home/hadoop/hive-0.9.0/lib

**step 5:** create hive database in mysql shell.

**step 6:** start hive and create table in hive shell

$ bin/hive
    
    $ create table test (id int, name string)

**step 7**: see the metadata of hive in mysql shell

$ mysql -uroot -pmysql
    
    $ use hive;
    
    $ show tables;
    
    $ select * from TBLS;