Hive配置实验

Hive配置实验

内嵌模式配置

下载Hive

wget https://www-eu.apache.org/dist/hive/hive-2.3.5/apache-hive-2.3.5-bin.tar.gz

解压包

tar -xvf apache-hive-2.3.5-bin.tar.gz 

将解压后的Hive文件夹放到Hadoop文件夹下

cd /cloud/hadoop-3.2.0/
mv ~/apache-hive-2.3.5-bin .

设置环境变量

vim ~/.bash_profile 

添加以下内容

export HIVE_HOME=/cloud/hadoop-3.2.0/apache-hive-2.3.5-bin
export PATH=$HIVE_HOME/bin:$PATH

添加完成后重启配置使其生效

. ~/.bash_profile 

本地模式配置

解压MySQL

tar -xvf  mysql-5.7.22-1.el6.x86_64.rpm-bundle.tar

安装组件

sudo rpm -ivh mysql-community-server-5.7.22-1.el6.x86_64.rpm  --force --nodeps
sudo rpm -ivh mysql-community-libs-5.7.22-1.el6.x86_64.rpm --force --nodeps
sudo rpm -ivh mysql-community-client-5.7.22-1.el6.x86_64.rpm --force --nodeps
sudo rpm -ivh mysql-community-common-5.7.22-1.el6.x86_64.rpm  --force --nodeps

在/var/log/mysqld.log处获取密码

启动MySQL

/etc/init.d/mysqld restart
mysql

修改密码

set password for root@localhost = password('123');  

运行Hive实例

hive --service metastore
$HIVE_HOME/bin/schematool -initSchema -dbType mysql
hive

create database db_hive_test;
use db_hive_test;

create table test(id int, name string);

# 加载本地数据
load data local inpath '/cloud/hadoop-3.2.0/input/test.txt' into table test;

检查插入内容

select * from test;

Reference

https://blog.youkuaiyun.com/scgaliguodong123_/article/details/46868525

https://www.itread01.com/content/1550319667.html