Hive installs MySQL as metadata

Download the hive installation package to unzip on any machine on a Hadoop cluster

MySQL JDBC driver copied to Hive's lib directory

hive-env.sh

hadoop_home=/opt/modules/hadoop-2.2.0

Modify Hive-site.xml

  <property>    <name>javax.jdo.option.ConnectionURL</name>     <value>jdbc:mysql://localhost:3306/hive?createdatabaseifnotexist=true</value >  </property>      <property>     <name>javax.jdo.option.ConnectionDriverName</name>    <value> com.mysql.jdbc.driver</value>  </property>      < property>    <name>javax.jdo.option.connectionpassword</name>     <value>root</value>   </property>         <property>    <name>javax.jdo.option.connectionusername</ name>    <value>root</value>   </property>       //Configuring the Graphical interface jar package    <property>    <name>hive.hwi.war.file</name>     <value>lib/hive-hwi-0.14.0.war</value>    < Description>this sets the path to the hwi war file, relative  to ${HIVE_HOME}. </description>   </property>

Other reference articles:

http://blog.itpub.net/28929558/viewspace-1192693/

This article is from the "thick, thin hair, ax" blog, please be sure to keep this source http://tianxingzhe.blog.51cto.com/3390077/1711884

Hive installs MySQL as metadata