1、原来数据
label_value 字段类型为 array[bigint]![hive array[bigint]转string](https://imgs.yssmx.com/Uploads/2023/06/508875-1.png)
2、目标数据
label_value 字段类型为 string![hive array[bigint]转string](https://imgs.yssmx.com/Uploads/2023/06/508875-2.png)
文章来源：https://www.toymoban.com/news/detail-508875.html
3、代码
select
concat('[',label_value,']') as label_value
,user_id,device_id,dt,label_name
from (
select
concat_ws(',',collect_list(label_values)) as label_value,
user_id,device_id,dt,label_name
from (
select
label_name,
cast(label_values as string) as label_values,
user_id,
device_id,
dt
from new_ads.ads_user_label_array
LATERAL VIEW explode(label_value) adTable AS label_values
) o2
group by label_name,user_id,device_id,dt
) o3
用现有函数array_join ，array转string文章来源地址https://www.toymoban.com/news/detail-508875.html
SELECT label_name
,array_join(label_value,',') as label_value
,user_id
,device_id
,dt
FROM new_ads.ads_user_label_array
;
到了这里，关于hive array[bigint]转string的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！
