hadoop集群中安装hive+mysql

一、安装MySQL
详情请看http://blog.csdn.net/intelligebce/article/details/78481214
二、hive安装及其配置
hive-site.xml的配置：

 <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>root</value>
<description>password to use against metastore database</description>
</property>

<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://slave2:3306/hive?createDatabaseIfNotExist=true&amp;useSSL=false</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/hive/warehouse</value>   ##需要在hdfs上建立想要的目录
<description>location of default database for the warehouse，Hive在HDFS上的根目录</description>
      </property>

<property>
<name>hive.exec.local.scratchdir</name>
<value>/hive/exec</value>
<description>Local scratch space for Hive jobs</description>
</property>

<property>
<name>hive.downloaded.resources.dir</name>
<value>/hive/downloadedsource</value>
<description>Temporary local directory for added resources in the remote file system.</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>

hive-env.sh的配置：
在尾部添加：
export HIVE_HOME=/usr/local/hive-1.2.2
export HIVE_CONF_DIR=/usr/local/hive-1.2.2/conf

bin目录下的hive-config.sh
export HADOOP_HOME=/usr/local/hadoop-2.7.4
export SPARK_HOME=/usr/local/spark-2.2.1/
export JAVA_HOME=/usr/local/jdk1.8.0_141