1 create 'ccc20180710',{NAME => 'f1',VERSIONS => 1},{NAME => 'f2',VERSIONS => 1},{NAME => 'f3',VERSIONS => 1} 2 3 4 put 'ccc20180710','ooccpp.com','f1:c1','name1' 5 put 'ccc20180710','ooccpp.com','f1:c2','name2' 6 put 'ccc20180710','ooccpp.com','f2:c1','age1' 7 put 'ccc20180710','ooccpp.com','f2:c2','age2' 8 put 'ccc20180710','ooccpp.com','f3:c1','job1' 9 put 'ccc20180710','ooccpp.com','f3:c2','job2' 10 put 'ccc20180710','ooccpp.com','f3:c3','job3' 11 12 13 scan 'ccc20180710' 14 15 CREATE EXTERNAL TABLE ccc20180710 ( 16 rowkey string, 17 f1 map<STRING,STRING>, 18 f2 map<STRING,STRING>, 19 f3 map<STRING,STRING> 20 ) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 21 WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,f1:,f2:,f3:") 22 TBLPROPERTIES ("hbase.table.name" = "ccc20180710");