CREATE EXTERNAL TABLE userPhoto(
uid string ,
tag string ,
tagweight double )
ROW FORMAT SERDE
'org.apache.hadoop.hive.hbase.HBaseSerDe'
STORED BY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
'hbase.columns.mapping'=':key,cf1:tag,cf1:tagweight',
'serialization.format'='1')
TBLPROPERTIES (
'hbase.table.name'='userPhoto');