hive over hbase方式将数据导出

最新推荐文章于 2023-06-09 08:23:57 发布

天然呆的技术博客

最新推荐文章于 2023-06-09 08:23:57 发布

阅读量571

点赞数

分类专栏： Nosql

本文链接：https://blog.csdn.net/u013494310/article/details/45399111

版权

Nosql 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

CREATE EXTERNAL TABLE userData(rowkey string,UserId String, ProfileId int,ClientTimeHourPart int,ClientTimeDayOfWeekPart String,ServerTime String,Country String,StateOrProvince String,City String,Longitude String,Latitude String,ISP String,OSBrief String,OSDetail String,BrowserBrief String,ScreenResolution String,IsMobile int,DeviceBrand String,DeviceType String,DeviceName String,Keywords String,SearchEngine String,ReferrerHostName String,SocialMedia String,PageHostName String,PageTitle String,WeiboUserId String)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,CF:UserId,CF:ProfileId,CF:ClientTimeHourPart,CF:ClientTimeDayOfWeekPart,CF:ServerTime,CF:Country,CF:StateOrProvince,CF:City,CF:Longitude,CF:Latitude,CF:ISP,CF:OSBrief,CF:OSDetail,CF:BrowserBrief,CF:ScreenResolution,CF:IsMobile,CF:DeviceBrand,CF:DeviceType,CF:DeviceName,CF:Keywords,CF:SearchEngine,CF:ReferrerHostName,CF:SocialMedia,CF:PageHostName,CF:PageTitle,CF:WeiboUserId")
TBLPROPERTIES("hbase.table.name" = "UserData");

rm -rf /home/bigdata/maoxiao/aud/accessUserData/userData
INSERT OVERWRITE LOCAL DIRECTORY '/home/bigdata/maoxiao/aud/accessUserData/userData' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' select * from userData;