hive on hbase

 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");
原文地址:https://www.cnblogs.com/chenzechao/p/9289273.html