create table role_bigtable(table_name string, record_date string, server_id string, map_col map<string, string>)

partitioned by ( dt string, game_id string)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY '\t'

COLLECTION ITEMS TERMINATED BY ','

MAP KEYS TERMINATED BY ':'; 

role_info    --        accoount_id:, role_id:

role_info    --        accoount_id:, role_id:

load data local inpath '/home/hadoop/test/test7.txt'

into table role_bigtable

partition (dt = '2017-01-01', game_id='gcd')

 select perf["accoount_id"] from role_bigtable where dt='2017-01-01' and game_id = 'gcd';