hive array[bigint]转string

1、原来数据

label_value 字段类型为 array[bigint]

2、目标数据

label_value 字段类型为 string

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
       groupby label_name,user_id,device_id,dt
) o3