CREATE EXTERNAL TABLE default.hive_hbase_test (
rowkey STRING,
telno STRING,
label STRING
)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
'hbase.columns.mapping'=':key,
cf:telno,
cf:label'
)TBLPROPERTIES("hbase.table.name" = "test");
