包安装

  1. hive包的安装 http://archive.apache.org/dist/hive/hive-3.1.0/apache-hive-3.1.0-bin.tar.gz
  2. 解压

配置hive

添加hive环境变量

vim /etc/profile

export HIVE_HOME=/Users/huajiejun/ewell/hadoop/apache-hive
export PATH=$PATH:$HIVE_HOME/bin

source /etc/profile

hive-env.sh

复制 hive-env.sh.template 为 hive-env.sh 增加以下内容

export JAVA_HOME=/Library/Java/JavaVirtualMachines/jdk1.8.0_211.jdk/Contents/Home

export HIVE_CONF_DIR=$HIVE_HOME/conf
export HIVE_AUX_JARS_PATH=$HIVE_HOME/lib/*

hive-site.xml

复制 hive-default.xml.template 为 hive-site.xml 删除configuration标签内所有配置信息,增加如下内容

<property>
    <name>system:java.io.tmpdir</name>
    <value>/User/huajiejun/ewell/hadoop/hive/data/tmp</value>
  </property>
  <property>
      <name>system:user.name</name>
      <value>root</value>
  </property>
  <property>
      <name>javax.jdo.option.ConnectionUserName</name>
      <value>root</value>
  </property>
  <property>
      <name>javax.jdo.option.ConnectionPassword</name>
      <value>123456</value>
  </property>
  <property>
      <name>javax.jdo.option.ConnectionURL</name>
      <value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&amp;characterEncoding=UTF-8&amp;useSSL=false</value>
  </property>
  <property>
      <name>javax.jdo.option.ConnectionDriverName</name>
      <value>com.mysql.jdbc.Driver</value>
  </property>
  <property>
      <name>hive.metastore.local</name>
      <value>false</value>
  </property>
  <property>  
      <name>hive.metastore.uris</name>  
      <value>thrift://localhost:9083</value>  
  </property>
  <property>
      <name>hive.metastore.schema.verification</name>
      <value>false</value>
  </property>