Hive简单映射

x33g5p2x  于2021-03-14 发布在 其他  
字(0.7k)|赞(0)|评价(0)|浏览(307)

默认分隔符\001

在vi编辑器中先按(Ctrl + v)再按(Ctrl + a)可以打出来分隔符\001

create table t3(id int, name string);
1^Azhangpn
2^Azhangpn666
3^Azhangpn888

指定分隔符 ①、delimited(大多数) ②、serde

create table t3(id int, name string) row format delimited fields terminated by ',';

复杂类型

create table t4(name string, address array<string>) row format delimited fields terminated by '\t' collection items terminated by ',';
Apollo	ShangHai,NanJing,BeiJing,TianJin
Paul	LeShan,ChengDu,SuZhou,WuXi,ChongQin
Flynn	BeiJing,ShangHai,XuZhou,KunShan
create table t5(id int, name string, hobby map<string,string>) row format delimited fields terminated by ',' collection items terminated by '-' map keys terminated by ':';
1,Apollo,唱歌:非常喜欢-跳舞:不喜欢-游泳:一般
2,Paul,唱歌:喜欢-跳舞:喜欢-游泳:不喜欢
3,Flynn,唱歌:喜欢-跳舞:非常喜欢-游泳:一般

相关文章

微信公众号

最新文章

更多