hive创建映射hbase外表

遥遥晚风点点

已于 2023-02-23 21:09:29 修改

阅读量632

点赞数

文章标签： hbase hive 大数据

于 2023-02-23 19:38:05 首次发布

本文链接：https://blog.csdn.net/Mr_ye931/article/details/129188575

版权

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')