Hive--array＜＜ struct ＞＞字段结构查询

Hive库array<< struct >>字段结构查询

建表相关语句：  
`sector_set` array<struct<gnb_id:int,cell_id:int,mr_count:bigint,rsrp_avg:double,sn:int,dist:int,cell_name:string>> COMMENT 'TOP5', 

`sector_set`字段数据表现形式：
[{"gnb_id":7799206,"cell_id":2,"mr_count":18,"rsrp_avg":-88.88888888888889,"sn":0,"dist":528,"cell_name":"东城汇业写字楼-NR_2"},{"gnb_id":7799772,"cell_id":4,"mr_count":4,"rsrp_avg":-99.75,"sn":1,"dist":1027,"cell_name":"南城汇成大厦-NR_4"},{"gnb_id":7799770,"cell_id":5,"mr_count":2,"rsrp_avg":-106.0,"sn":2,"dist":1778,"cell_name":"南城钻石世家-NR_5"},{"gnb_id":7799200,"cell_id":1,"mr_count":2,"rsrp_avg":-98.0,"sn":3,"dist":414,"cell_name":"东城信息大厦-NR_1"},{"gnb_id":7799783,"cell_id":3,"mr_count":1,"rsrp_avg":-107.0,"sn":4,"dist":1370,"cell_name":"N-南城景湖春晓西-NR_3"}]

`sector_set`中字段查询：

select sector_set[0].gnb_id from table limit 1；
--7799206

select sector_set[1].gnb_id from table limit 1；
--7799772

select sector_set[0].cell_id from table limit 1；
--2

select sector_set[0].gnb_id from table limit 1; 
--[7800568,7799678,7800568,7800590,7799703]