hive：与hbase映射表

CREATE EXTERNAL TABLE `ood.ods_aim_ki_cords_real_time`(
  `id` bigint, 
  `employeeno` string, 
  `employeename` string, 
  `branchno` string, 
  `postno` string, 
  `teamno` string, 
  `clientid` int, 
  `origin` string, 
  `clientname` string, 
  `contracttype` string, 
  `contractid` int, 
  `status` string, 
  `fillindate` string, 
  `isapprove` boolean, 
  `advice` string, 
  `approveno` string, 
  `approvename` string, 
  `addtime` string, 
  `updatetime` string, 
  `role` string, 
  `branchname` string, 
  `teamname` string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'   
WITH SERDEPROPERTIES ("hbase.columns.mapping" =":key,information:EmployeeNo,
information:EmployeeName,
information:BranchNo,
information:PostNo,
information:TeamNo,
information:ClientId,
information:Origin,
information:ClientName,
information:ContractType,
information:ContractId,
information:Status,
information:FillinDate,
information:IsApprove,
information:Advice,
information:ApproveNo,
information:ApproveName,
information:AddTime,
information:UpdateTime,
information:Role,
information:BranchName,
information:TeamName") TBLPROPERTIES("hbase.table.name" = "ai_ki_cords","hbase.mapred.output.outputtable"="ai_ki_cords");

注意：hbase中应当已经存在ai_ki_cords这张表了！