hive query hbase create statemen

CREATE EXTERNAL TABLE `kafka.qian_open_app_events`(
  `key` string COMMENT 'from deserializer', 
  `user_id` int COMMENT 'from deserializer', 
  `device_id` string COMMENT 'from deserializer', 
  `local_time` int COMMENT 'from deserializer', 
  `server_time` int COMMENT 'from deserializer', 
  `app_name` string COMMENT 'from deserializer', 
  `app_version` string COMMENT 'from deserializer', 
  `real_ip` string COMMENT 'from deserializer', 
  `longitude` int COMMENT 'from deserializer', 
  `latitude` int COMMENT 'from deserializer', 
  `activity` string COMMENT 'from deserializer')
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.hbase.HBaseSerDe' 
STORED BY 
  'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 
WITH SERDEPROPERTIES (   'hbase.columns.mapping'=':key,data:user_id,data:device_id,data:local_time,data:server_time,data:app_name,data:app_version,data:real_ip,data:longitude,data:latitude,data:activity', 
  'serialization.format'='1')
TBLPROPERTIES (
  'COLUMN_STATS_ACCURATE'='false', 
  'hbase.table.name'='qian-open-app-events', 
  'numFiles'='0', 
  'numRows'='-1', 
  'rawDataSize'='-1', 
  'totalSize'='0', 
  'transient_lastDdlTime'='1523415411')