默认分隔符\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,唱歌:喜欢-跳舞:非常喜欢-游泳:一般
内容来源于网络,如有侵权,请联系作者删除!