HowtoConfigureHiveOnMysql

1. Download the mysql java connection jar from MySQL official site
2. Cp the jar into the $HIVE_HOME/lib
   1. cp ../hive-0.5.0-dev/lib/mysql-connector-java-3.1.14-bin.jar /var/hadoop/hive-0.5.0-bin/lib/
3. Modify the configuration $HIVE_HOME/conf/hive-default.xml

1. Driver & Connection URL

   

<property>

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

<value>jdbc:mysql://10.224.192.130: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>



 

1. User/Password

   

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

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