HBase建表:
create 'ods_member',{NAME => 'cf', VERSIONS => 1}
Hive建表:
CREATE EXTERNAL TABLE `ods_member_hbase`(
`id` string,
`accountid` string,
`activatedat` timestamp,
`activationsource` string,
`annualaccumulatedscore` bigint,
`annualcostscore` bigint,
`birth` string,
`blockedstatus` bigint,
`blockedstatusupdatedat` timestamp,
`cardid` string,
`cardnumber` string,
`cardprovidetime` timestamp,
`createdat` timestamp,
`growth` bigint,
`pid` string,
`isactivated` boolean,
`isdeleted` boolean,
`isdisabled` boolean,
`level` bigint,
`levelstartedat` timestamp,
`membervalueengagement` bigint,
`membervaluegrades` bigint,
`membervalueinformationgrades` bigint,
`membervaluestage` string,
`nickname` string,
`properties` string,
`propertyaddress` string,
`propertyaddresscity` string,
`propertyaddresscountry` string,
`propertyaddressdistrict` string,
`propertyaddressprovince` string,
`propertyage` bigint,
`propertybirthday` timestamp,
`propertyeducation` string,
`propertyemail` string,
`propertygender` string,
`propertyincome` string,
`propertyindustry` string,
`propertyname` string,
`propertynation` string,
`propertyphone` string,
`propertyphonemd5` string,
`propertyposition` string,
`propertyrawphone` string,
`propertysign` string,
`qrcodeviewed` string,
`remarks` string,
`score` bigint,
`source` string,
`tags` string,
`totalcostscore` bigint,
`totalscore` bigint,
`updatedat` timestamp,
`wxcardactivatedat` bigint,
`wxcardchannel` string,
`wxcardcode` string,
`wxcardid` string,
`wxcardsceneid` string)
ROW FORMAT SERDE
'org.apache.hadoop.hive.hbase.HBaseSerDe'
STORED BY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
'hbase.columns.mapping'=':key,cf:accountid, cf:activatedat, cf:activationsource, cf:annualaccumulatedscore, cf:annualcostscore, cf:birth, cf:blockedstatus, cf:blockedstatusupdatedat, cf:cardid, cf:cardnumber, cf:cardprovidetime, cf:createdat, cf:growth, cf:id, cf:isactivated, cf:isdeleted, cf:isdisabled, cf:level, cf:levelstartedat, cf:membervalueengagement, cf:membervaluegrades, cf:membervalueinformationgrades, cf:membervaluestage, cf:nickname, cf:properties, cf:propertyaddress, cf:propertyaddresscity, cf:propertyaddresscountry, cf:propertyaddressdistrict, cf:propertyaddressprovince, cf:propertyage, cf:propertybirthday, cf:propertyeducation, cf:propertyemail, cf:propertygender, cf:propertyincome, cf:propertyindustry, cf:propertyname, cf:propertynation, cf:propertyphone, cf:propertyphonemd5, cf:propertyposition, cf:propertyrawphone, cf:propertysign, cf:qrcodeviewed, cf:remarks, cf:score, cf:source, cf:tags, cf:totalcostscore, cf:totalscore, cf:updatedat, cf:wxcardactivatedat, cf:wxcardchannel, cf:wxcardcode, cf:wxcardid, cf:wxcardsceneid',
'serialization.format'='1')
TBLPROPERTIES ('hbase.table.name'='ods_member_hbase')