create TABLEperson(
key string,
name string,
sex string
)STOREDBY'org.apache.hadoop.hive.hbase.HBaseStorageHandler'WITHSERDEPROPERTIES("hbase.columns.mapping"=":key,cf1:name,cf1:sex")TBLPROPERTIES("hbase.table.name"="hbase_person");
create EXTERNALTABLEperson(
key string,
name string,
sex string
)STOREDBY'org.apache.hadoop.hive.hbase.HBaseStorageHandler'WITHSERDEPROPERTIES("hbase.columns.mapping"=":key,cf1:name,cf1:sex")TBLPROPERTIES("hbase.table.name"="hbase_person");