Hive数组结构查询
发布时间
阅读量:
阅读量
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_
全部评论 (0)
还没有任何评论哟~
