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