hive配置远程mysql_以MYSQL作为HIVE的元数据库，配置HIVE的远程连接

准备工作就是需要将mysql-connector-java-5.1.24.JAR包拷贝到 hive/lib目录下

这里我将10.0.20.178作为主节点，同时也把MYSQL装在了这个节点上，其配置文件内容为：

hive.metastore.local

false

connect to remove metastore server or open a new metastore server in Hive Client JVM

javax.jdo.option.ConnectionURL

javax.jdo.option.ConnectionDriverName

com.mysql.jdbc.Driver

Driver class name for a JDBC metastore

javax.jdo.option.ConnectionUserName

hive

username to use against metastore database

javax.jdo.option.ConnectionPassword

123456

password to use against metastore database

hive.metastore.warehouse.dir

/user/hive/warehouse

location of default database for the warehouse

hbase.zookeeper.quorum

hadoop20-178,hadoop-134

hive.aux.jars.path

file:///usr/lib/hbase/lib/hive-hbase-handler-0.9.0-cdh4.1.2.jar,file:///us