1. 创建HBase的Hive外部表
CREATE EXTERNAL TABLE `namespace.table_name`(
`key` string,
`id` int,
`name` string)
ROW FORMAT SERDE
'org.apache.hadoop.hive.hbase.HBaseSerDe'
STOREDBY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES(
'hbase.columns.mapping'=':key,C1:ID,C1:NAME',
'serialization.format'='1')
TBLPROPERTIES('hbase.table.name'='hbase_namespace:hbase_table_name');
2. 清空HBase表数据
truncate 'namespace:tableName'