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 ':';
创建 test7.txt
role_info 2017-01-01 101 accoount_id:20, role_id:30 role_info 2017-01-01 102 accoount_id:201, role_id:301
导入数据
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';