create external table test5 (key int,value1 string,value2 string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" ="From:from,To:to") TBLPROPERTIES ("hbase.table.name" = "test5");