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