HIve元数据配置到mysql

1. 将驱动类拷贝到/home/hduser/software 下 (直接拉就行)

2. 解压：tar -xzvf mysql-connector-java-5.1.27.tar.gz

3. 进到解压之后的文件目录，将mysql-connector-java-5.1.27-bin.jar复制到hive的lib目录下 命令：cp mysql-connector-java-5.1.27-bin.jar /home/hduser/software/hive_1.2.1/lib
   

4. 在hive的conf文件夹下创建hive-site.xml :touch hive-site.xml

5. 编辑hive-site.xml文件

   <?xml version="1.0"?> 
   <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> 
   <configuration> 
    <property> 
      <name>javax.jdo.option.ConnectionURL</name> 
      
   <value>jdbc:mysql://主机名称:3306/metastore?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> 
    
    <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>密码</value> 
      <description>password to use against metastore database</description> 
    </property> 
   </configuration> 
   

6. 启动hive