HiveSQL_添加数据load
2022/1/15 2:03:47
本文主要是介绍HiveSQL_添加数据load,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
创建表
create table person( id int comment "唯一标识", name string comment "名称", likes array<string> comment "爱好", address map<string,string> comment "地址" ) row format delimited fields terminated by "," collection items terminated by "-" map keys terminated by ":" lines terminated by "\n";
准备person01.txt文件
[root@node4 data]# cat person01.txt 1,小明 1,lol-book-movie,beijing:xisanqi-shanghai:pudong 2,小明 2,lol-book-movie,beijing:xisanqi-shanghai:pudong 3,小明 3,lol-book-movie,beijing:xisanqi-shanghai:pudong 4,小明 4,lol-book-movie,beijing:xisanqi-shanghai:pudong 5,小明 5,lol-movie,beijing:xisanqi-shanghai:pudong 6,小明 6,lol-book-movie,beijing:xisanqi-shanghai:pudong 7,小明 7,lol-book,beijing:xisanqi-shanghai:pudong 8,小明 8,lol-book,beijing:xisanqi-shanghai:pudong 9,小明 9,lol-book-movie,beijing:xisanqi-shanghai:pudong
load person01.txt文件加载数据
load data local inpath '/root/data/person01.txt' into table person;
查看person表数据
hive> select *from person; OK 1 小明 1 ["lol","book","movie"] {"beijing":"xisanqi","shanghai":"pudong "} 2 小明 2 ["lol","book","movie"] {"beijing":"xisanqi","shanghai":"pudong "} 3 小明 3 ["lol","book","movie"] {"beijing":"xisanqi","shanghai":"pudong "} 4 小明 4 ["lol","book","movie"] {"beijing":"xisanqi","shanghai":"pudong "} 5 小明 5 ["lol","movie"] {"beijing":"xisanqi","shanghai":"pudong "} 6 小明 6 ["lol","book","movie"] {"beijing":"xisanqi","shanghai":"pudong "} 7 小明 7 ["lol","book"] {"beijing":"xisanqi","shanghai":"pudong "} 8 小明 8 ["lol","book"] {"beijing":"xisanqi","shanghai":"pudong "} 9 小明 9 ["lol","book","movie"] {"beijing":"xisanqi","shanghai":"pudong"} NULL NULL NULL NULL Time taken: 0.195 seconds, Fetched: 10 row(s)
这篇关于HiveSQL_添加数据load的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-05-19永别了,微服务架构!
- 2024-05-15鸿蒙生态设备数量超8亿台
- 2024-05-13TiDB + ES:转转业财系统亿级数据存储优化实践
- 2024-05-09“2024鸿蒙零基础快速实战-仿抖音App开发(ArkTS版)”实战课程已上线
- 2024-05-09聊聊如何通过arthas-tunnel-server来远程管理所有需要arthas监控的应用
- 2024-05-09log4j2这么配就对了
- 2024-05-09nginx修改Content-Type
- 2024-05-09Redis多数据源,看这篇就够了
- 2024-05-09Google Chrome驱动程序 124.0.6367.62(正式版本)去哪下载?
- 2024-05-09有没有大佬知道这种数据应该怎么抓取呀?