hive使用远程mysql服务器_使用远程mysql作为元数据库安装Hive

补充：如果使用 hive.metastore.uris 可以将hive服务端与客户端分离

服务端：

javax.jdo.option.ConnectionURL

jdbc:mysql://192.168.0.103:3306/hivedb

javax.jdo.option.ConnectionDriverName

com.mysql.jdbc.Driver

javax.jdo.option.ConnectionUserName

hive

javax.jdo.option.ConnectionPassword

123456

hive.metastore.warehouse.dir

/user/hive/warehouse

location of default database for the warehouse

客户端：

hive.metastore.local

false

hive.metastore.uris

thrift://192.168.0.104:9083

Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.

hive.metastore.warehouse.dir

/user/hive/warehouse

location of default database for the warehouse