进阶 ｜Hive 复杂数据类型.docxVIP

进阶 ｜Hive 简单数据类型 (1) 先创建一张表 create table t_map(id int,name string,hobby mapstring,string)row format delimitedfields terminated by ,collection items terminated by -map keys terminated by :stored as textfile;#加载数据load data inpath /tmp/t_map.txt into table t_map; (2) 预备数据文件 t_map.txt 1,zhangsan,唱歌:格外宠爱-跳舞:宠爱-游泳:一般般2,lisi,打玩耍:格外宠爱-篮球:不宠爱 (3) 查询数据 select * from _map;+-----------+-------------+-------------------------------------+| t_map.id | t_map.name | t_map.hobby |+-----------+-------------+-------------------------------------+| 1 | zhangsan |