CDH5.1.0 HIVE mysql 配置远程元数据库

最新推荐文章于 2022-10-12 01:35:38 发布

liwenqiang758

最新推荐文章于 2022-10-12 01:35:38 发布

阅读量4.6k

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/liwenqiang758/article/details/50944861

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.准备三台虚拟机分别为：
master/192.168.100.10
slave1/192.168.100.13
db/192.168.100.14

2.cdh5分别安装在master,slave1;

3. mysql安装到db;

4.创建HIVE数据库用户及授权

CREATE USER 'hive' IDENTIFIED BY '@Admin123';
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%' WITH GRANT OPTION;
flush privileges;
切换hive用户
create database hive;
alter database hive character set latin1;

5.修改master上的hive-site.xml

<property>
        <name>hive.metastore.local</name>
        <value>false</value>
 </property>
<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://192.168.100.14:3306/hive?useSSL=false</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>
    <property>
        <name>javax.jdo.option.ConnectionDriverName</name>
        <value>com.mysql.jdbc.Driver</value>
    </property>
    <property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>hive</value>
    </property>
    <property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>@Admin123</value>
    </property>
    <property>
        <name>hive.metastore.uris</name>
        <value>thrift://127.0.0.1:9083</value>
    </property>
[/code]

6.修改slave1上的hive-site.xml

<property>
        <name>hive.metastore.local</name>
        <value>false</value>
 </property>
<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://192.168.100.14:3306/hive?useSSL=false</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>
    <property>
        <name>javax.jdo.option.ConnectionDriverName</name>
        <value>com.mysql.jdbc.Driver</value>
    </property>
    <property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>hive</value>
    </property>
    <property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>@Admin123</value>
    </property>
    <property>
        <name>hive.metastore.uris</name>
        <value>thrift://master:9083</value>
    </property>