1、下载tar包 解压

2、安装mysql

3、修改hive配置文件

vim hive-env.sh

  1. HADOOP_HOME=/usr/local/hadoop-2.9.2
  3. export HIVE_CONF_DIR=/usr/local/apache-hive-2.3.9-bin/conf

vim hive-site.xml

  1. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  2. <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
  5. <configuration>
  7.   <property>
  8.     <name>javax.jdo.option.ConnectionUserName</name>
  9.     <value>root</value>
  10.   </property>
  12.   <property>
  13.     <name>javax.jdo.option.ConnectionPassword</name>
  14.     <value>123456</value>
  15.   </property>
  17.   <property>
  18.     <name>javax.jdo.option.ConnectionURL</name>
  19.     <value>jdbc:mysql://192.100.3.21:3306/hive?createDatabaseIfNotExist=true</value>
  20.   </property>
  22.   <property>
  23.     <name>javax.jdo.option.ConnectionDriverName</name>
  24.     <value>com.mysql.cj.jdbc.Driver</value>
  25.   </property>
  27.   <property>
  28.     <name>hive.metastore.schema.verification</name>
  29.     <value>false</value>
  30.   </property>
  32.   <property>
  33.     <name>hive.server2.thrift.bind.host</name>
  34.     <value>node-1</value>
  35.   </property>
  37.    <property>
  38.     <name>datanucleus.schema.autoCreateAll</name>
  39.     <value>true</value>
  40.   </property>
  41. </configuration>

4、添加mysql驱动

将mysql 驱动mysql-connector-java-8.0.18.jar放置到lib目录下

5、配置hive环境变量

  2. export HIVE_HOME=/usr/local/apache-hive-2.3.9-bin
  3. export PATH=$HIVE_HOME/bin:$PATH

6、初始化元数据库

  2. schematool -dbType mysql -initSchema
  4. # 2.x版本Hive需要手动初始化

7、使用

  2. $ hive
  3. hive> show database;
  4. hive> create database mytest;
  5. hive> use mytest;
  6. hive> create table book(id int, name string);