1 MySQL 메타스토어 설정

2 참고

1. mysql 설치 및 시작

sudo apt-get install mysql-server mysql-client
/etc/init.d/mysqld start

2. mysql 설치 후 mysql 계정 및 데이터베이스 생성

mysql -u root -p
grant all privileges on *.* to huser@localhost identified by '9999' with grant option;
create database hive; 

3. mysql connector 다운로드(http://www.mysql.com/downloads/connector/j/) mysql-connector-java-5.1.26.tar.gz
4. 압축 풀기

tar xzf mysql-connector-java-5.1.26.tar.gz

5. mysql-connector-java-5.1.26-bin.jar를 HIVE_HOME/lib/ 에 복사

6. hive-site.xml 생성

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

<configuration>
    <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>huser</value>
      <description>username to use against metastore database</description>
    </property>


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

hwi관련 추가

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

<configuration>
    <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>huser</value>
      <description>username to use against metastore database</description>
    </property>

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

    <property>
        <name>hive.hwi.listen.host</name>
        <value>0.0.0.0</value>
    </property>

    <property>
        <name>hive.hwi.listen.port</name>
        <value>9999</value>
    </property>

    <property>
        <name>hive.hwi.war.file</name>
        <value>/lib/hive-hwi-0.11.0.war</value>
    </property>
</configuration>   

• http://bigmark.tistory.com/35