Hive安装与配置

配置hive元数据到mysql
1)驱动拷贝
拷贝mysql­connector­java­5.1.27­bin.jar到/root/hd/hive/lib/下
2)配置Metastore到MySql
-》在/root/hd/hive/conf目录下创建一个hive-site.xml
-》根据官方文档配置参数，拷贝数据到hive-site.xml文件中(hive/conf/下创建文件)

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