Advertisement

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)

还没有任何评论哟~