若发现文章有误,敬请指正,感谢
参考资料
一、运行环境
- Vmware
- CentOS 7 操作系统
- JDK 8
- MySQL8
- Hadoop3.3.0(单节点)
- HIve 3.1.2 on YARN
节点分配:
其中MySQL和Hive都安装在hadoop101节点
二、准备测试数据
客户的消费情况(客户昵称、消费日期、消费金额)cost.txt
jack,2017-01-01,10
tony,2017-01-02,15
jack,2017-02-03,23
tony,2017-01-04,29
jack,2017-01-05,46
jack,2017-04-06,42
tony,2017-01-07,50
jack,2017-01-08,55
mart,2017-04-08,62
mart,2017-04-09,68
neil,2017-05-10,12
mart,2017-04-11,75
neil,2017-06-12,80
mart,2017-04-13,94
将该文本数据保存到本地,等会加载到Hive数据表
进入Hive Shell,创建测试的表
hive (default)> create table testover(
> name string,
> orderdate string,
> cost int)
> ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
加载本地数据
hive (default)> load data local inpath "/opt/module/hive/data/cost.txt" into table testover;
hive (default