安装hive

export HIVE_HOME=/opt/hive-2.1.0
export HCAT_HOME=$HIVE_HOME/hcatalog
export HIVE_CONF=$HIVE_HOME/conf
export PATH=$PATH:$HIVE_HOME/bin

cp conf/hive-default.xml.template conf/hive-site.xml

<!-- 以下property需要修改，其余的不用 -->
<property>
  <!-- 数据库连接字串 -->
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://localhost:3306/hive?characterEncoding=UTF-8&amp;createDatabaseIfNotExist=true</value>
  <description>
    JDBC connect string for a JDBC metastore.
    To use SSL to encrypt/authenticate the connection, provide database-specific SSL flag in the connection URL.
    For example, jdbc:postgresql://myhost/db?ssl=true for postgres database.
  </description>
</property>
<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>root</value>
  <description>Username to use against metastore database</description>
</property>
<property>
  <!-- 数据库密码 -->
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>111111</value>
  <description>password to use against metastore database</description>
</property>
<!-- 允许任何人访问 -->
<property>
  <name>hive.server2.authentication</name>
  <value>NOSASL</value>
</property>
<!-- 禁用代理功能 -->
<property>
  <name>hive.server2.enable.doAs</name>
  <value>false</value>
</property>
<!-- hive远程传输方式改为http，这样的话就能在客户端用http访问数据库了 -->
<property>
    <name>hive.server2.transport.mode</name>
    <value>http</value>
    <description>
      Expects one of [binary, http].
      Transport mode of HiveServer2.
    </description>
</property>

bin/schematool -dbType mysql -initSchema

start-dfs.sh && start-yarn.sh

hive

-- 创建 hive 库
create database hive;
-- 显示数据库
show databases;

hiveserver2