wget mirror.bit.edu.cn/apache/hive/hive-2.3.4/apache-hive-2.3.4-bin.tar.gz
解压到/usr/local/apache-hive
增加环境变量export HIVE_HOME=/usr/local/apache-hive
将bin加入path
cd /usr/local/apache-hive/conf
cp hive-default.xml.template hive-default.xml
vim hive-site.xm
# cat hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://ali:3306/hive?createDatabaseIfNotExist=true&useSSL=false</value>
<description>JDBC connect string for a JDBC metastore</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>mysq用户</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>mysql密码</value>
<description>password to use against metastore database</description>
</property>
</configuration>
cp hive-env.sh.template hive-env.sh
修改
# Set HADOOP_HOME to point to a specific hadoop install directory
export HADOOP_HOME=/usr/local/hadoop/hadoop-2.7.7
# Hive Configuration Directory can be controlled by:
export HIVE_CONF_DIR=/usr/local/apache-hive/conf
# Folder containing extra libraries required for hive compilation/execution can be controlled by:
export HIVE_AUX_JARS_PATH=/usr/local/apache-hive/lib
hadoop fs -mkdir -p /user/hive/warehouse
hadoop fs -mkdir -p /user/hive/tmp
hadoop fs -mkdir -p /user/hive/log
hadoop fs -chmod -R 777 /user/hive/warehouse
hadoop fs -chmod -R 777 /user/hive/tmp
hadoop fs -chmod -R 777 /user/hive/log
https://download.csdn.net/download/lychenhanqing/10049080
下载mysql drive到/usr/local/apache-hive/lib
schematool -initSchema -dbType mysql
请先确保 hadoop 已正常启动!
# 启动hive(由于已配置相关环境变量,直接使用):
hive
# 启动成功,启动过程提示信息结束后,回显:
hive>
# 说明已成功启动。同样,注意 ";" 标识一条命令结束!
# 显示数据库:
hive> show databases;
OK
default
Time taken: 14.107 seconds, Fetched: 1 row(s)
# 创建一个表:
hive> create table test1(tid int, tname string);
OK
Time taken: 5.021 seconds
# 显示tables:
hive> show tables;
OK
test1
Time taken: 5.077 seconds, Fetched: 1 row(s)
# 删除刚刚创建的表test1:
hive> drop table test1;
OK
Time taken: 5.223 seconds
# 重新创建表 test1(用于mysql测试):
hive> create table test1(tid int, tname string);
OK
Time taken: 1.322 seconds
# 退出 hive shell
hive> exit;
启动metastore
hive --service metastore
使用metastore的客户端配置
hive-site.xml
<property>
<name>hive.metastore.local</name>
<value>false</value>
<description>controls whether to connect to remote metastore
server or open a new metastore server in Hive Client
JVM</description>
</property>
<property>
<name>hive.metastore.uris</name>
<value>thrift://127.0.0.1:9083</value>
<description></description>
</property>
启动hiveserver2
hive --service hiveserver2
访问10002