Hive之向一个array中装载多个struct

最新推荐文章于 2022-08-19 15:05:25 发布

晓晓121

最新推荐文章于 2022-08-19 15:05:25 发布

阅读量302

点赞数

分类专栏： Hive 文章标签： hive mongodb

本文链接：https://blog.csdn.net/langzi_0371/article/details/120130914

版权

Hive 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

CREATE external TABLE `mongodb_dingtalk.mongodb_test`(
`companyName` string,
`sources` array<struct<contact:string,contactJob:string,site:string,source:string,sourceHref:string>>
)
STORED BY 'com.mongodb.hadoop.hive.MongoStorageHandler'
WITH SERDEPROPERTIES('mongo.columns.mapping'='{"companyName":"companyName","contactName":"contactName","content":"content","type":"type","numStatus":"numStatus","sources":"sources"}')
TBLPROPERTIES('mongo.uri'='mongodb://ip:21000/companyName.test');


insert overwrite table mongodb_dingtalk.mongodb_test
select companyname,
collect_set(named_struct('contact',companyname,'contactjob',contactjob,'site',site,'source',source,'sourceHref',sourceHref)) as sources
from mongodb_dingtalk.hive_companycontact_20210904 where companyname = 'xxxxxx' group by companyname;