安装BigTop编译的Hive

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');