安装BigTop编译的Hive

分手后的思念是犯贱 2021-09-28 16:20 459阅读 0赞

# 1、安装Hive #

在hdp1

yum install hive
    #会安装以下包
    Downloading packages:
    (1/3): hadoop-client-3.1.1-1.el7.x86_64.rpm                                                                               
    (2/3): hive-jdbc-3.1.0-1.el7.noarch.rpm                                                                         
    (3/3): hive-3.1.0-1.el7.noarch.rpm
    
    yum install hive-metastore -y              
    yum install hive-server2 -y

# 2、修改配置文件 #

#修改配置文件
    /etc/hive/conf/hive-site.xml
    
      <property>
        <name>hive.metastore.warehouse.dir</name>
        <value>hdfs://mycluster:8020/hive/warehouse</value>
      </property>
      <property>
        <name>hive.exec.scratchdir</name>
        <value>/hive/scratch</value>
      </property>
      <property>
        <name>hive.querylog.location</name>
        <value>/hive/log/hadoop</value>
      </property>
      <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:postgresql://192.168.6.14:5432/hive?ssl=false</value>
      </property>
      <property>
        <name>javax.jdo.option.ConnectionDriverName</name>
        <value>org.postgresql.Driver</value>
      </property>
      <property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>postgres</value>
      </property>
      <property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>postgres</value>
      </property>
      <property>
        <name>hive.server2.logging.operation.log.location</name>
        <value>/hive/tmp/hadoop/operation_logs</value>
      </property>
      <property>
        <name>hive.metastore.schema.verification</name>
        <value>false</value>
      </property>
      <property>
        <name>alluxio.zookeeper.enabled</name>
        <value>true</value>
      </property>
      <property>
        <name>alluxio.zookeeper.address</name>
        <value>hdp1:2181,hdp2:2181,hdp3:2181</value>
      </property>
      <property>
        <name>fs.alluxio.impl</name>
        <value>alluxio.hadoop.FileSystem</value>
      </property>

# 3、初始化数据库 #

/usr/lib/hive/bin/schematool -initSchema -dbType postgres

# 4、测试 #

hive
    show tables;
    create table test(id int,name string);
    insert into test values(1,'zs');