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

最新推荐文章于 2024-10-10 10:58:41 发布

ducode

最新推荐文章于 2024-10-10 10:58:41 发布

阅读量246

点赞数

文章标签：数据库大数据

原文链接：https://my.oschina.net/sansom/blog/190684

版权

2019独角兽企业重金招聘Python工程师标准>>>

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

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

<configuration>


<!-- Hive Execution Parameters -->


<property>
  <name>hive.metastore.local</name>
  <value>false</value>
 <description>connect to remove metastore server or open a new metastore server in Hive Client JVM</description>
</property>
<property>
  <name>javax.jdo.option.ConnectionURL</name>
<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>hive</value>
  <description>username to use against metastore database</description>
</property>
<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>123456</value>
  <description>password to use against metastore database</description>
</property>
<property>
  <name>hive.metastore.warehouse.dir</name>
  <value>/user/hive/warehouse</value>
  <description>location of default database for the warehouse</description>
</property>

<property>
  <name>hbase.zookeeper.quorum</name>
  <value>hadoop20-178,hadoop-134</value>
  <description></description>
</property>

<property>
 <name>hive.aux.jars.path</name>
 <value>file:///usr/lib/hbase/lib/hive-hbase-handler-0.9.0-cdh4.1.2.jar,file:///usr/lib/hbase/hbase.jar,file:///usr/lib/hb
ase/lib/zookeeper-3.4.3-cdh4.1.2.jar</value>
</property>

</configuration>

然后启动服务：
hive --service metastore >/dev/null 2>/dev/null &

在其他节点，不管你有多少节点都可以把配置文件内容改为：

<property>
        <name>hive.metastore.local</name>
        <value>false</value>
        <description>controls whether to connect to remove metastore server or open a new metastore server in Hive Client
JVM</description>
    </property>
    <property>
        <name>hive.metastore.uris</name>
        <value>thrift://10.0.20.178:9083</value>
    </property>

一切搞定。关于常见的错误，我会在其他博客中列举。

转载于:https://my.oschina.net/sansom/blog/190684