搭建Hadoop2.5.2+Hive2.1+Mysql

环境：系统-Ubuntu，Hadoop-已搭建

1、MySQL

  安装mysql

  下载MySQL的java连接驱动，并copy到hivelib目录下

2、Hadoop

  启动Hadoop：start-all.sh

3、Hive

通过cp命令复制conf下的配置文件

创建hive-site.xml

<configuration>     <property>         <name>javax.jdo.option.ConnectionURL</name>         <value>jdbc:mysql://master: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.ConnectionUserName</name>         <value>root</value>     </property>     <property>           <name>javax.jdo.option.ConnectionPassword</name>         <value>root</value>     </property>     <property>         <name>datanucleus.readOnlyDatastore</name>         <value>false</value>     </property>     <property>         <name>datanucleus.fixedDatastore</name>         <value>false</value>     </property>     <property>         <name>datanucleus.autoCreateSchema</name>         <value>true</value>     </property>     <property>         <name>datanucleus.autoCreateTables</name>         <value>true</value>     </property>     <property>         <name>datanucleus.autoCreateColumns</name>         <value>true</value>     </property>           </configuration>

4. 启动

  bin/hive --service metastore & #启动metastore

  bin/hive #连接hive