Hive配置实验

朴灿烈づ我的快乐病毒、 2022-01-14 03:55 202阅读 0赞

# 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`处获取密码

![屏幕快照 2019-06-15 17.18.34.png][2019-06-15 17.18.34.png]

启动MySQL

/etc/init.d/mysqld restart
    mysql

![屏幕快照 2019-06-15 15.45.06.png][2019-06-15 15.45.06.png]

修改密码

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

![屏幕快照 2019-06-15 17.17.16.png][2019-06-15 17.17.16.png]

## 运行Hive实例 ##

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

create database db_hive_test;
    use db_hive_test;

![屏幕快照 2019-06-16 11.05.53.png][2019-06-16 11.05.53.png]

create table test(id int, name string);
    
    # 加载本地数据
    load data local inpath '/cloud/hadoop-3.2.0/input/test.txt' into table test;

![屏幕快照 2019-06-16 11.07.15.png][2019-06-16 11.07.15.png]

检查插入内容

select * from test;

![屏幕快照 2019-06-16 11.17.53.png][2019-06-16 11.17.53.png]

## Reference ##

[https://blog.csdn.net/scgaliguodong123\_/article/details/46868525][https_blog.csdn.net_scgaliguodong123_article_details_46868525]

[https://www.itread01.com/content/1550319667.html][https_www.itread01.com_content_1550319667.html]

[2019-06-15 17.18.34.png]: https://i.loli.net/2019/06/15/5d04b7f6cfce021628.png
[2019-06-15 15.45.06.png]: https://i.loli.net/2019/06/15/5d04a24d10ea460116.png
[2019-06-15 17.17.16.png]: https://i.loli.net/2019/06/15/5d04b7a7bd83488545.png
[2019-06-16 11.05.53.png]: https://i.loli.net/2019/06/16/5d05b22ad5d3c69530.png
[2019-06-16 11.07.15.png]: https://i.loli.net/2019/06/16/5d05b2890b27439202.png
[2019-06-16 11.17.53.png]: https://i.loli.net/2019/06/16/5d05b4edbcc7e71229.png
[https_blog.csdn.net_scgaliguodong123_article_details_46868525]: https://blog.csdn.net/scgaliguodong123_/article/details/46868525
[https_www.itread01.com_content_1550319667.html]: https://www.itread01.com/content/1550319667.html