假设有如下数据:
1,zhang,18:male:深圳
则建表语句应该如下:
create table t_user(id int,name string,info struct<age:int,sex:string:addr:string>)
row format delimited fields terminated by ','
collection items terminated by ':';
查询地址:
select info.addr from t_user;
假设有如下数据:
1,zhang,18:male:深圳
则建表语句应该如下:
create table t_user(id int,name string,info struct<age:int,sex:string:addr:string>)
row format delimited fields terminated by ','
collection items terminated by ':';
查询地址:
select info.addr from t_user;