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");