Java教程

hive sql 将array<float>转成arrray<string>

本文主要是介绍hive sql 将array<float>转成arrray<string>,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

在网上找了很久,终于解决了,代码如下:

with mydata as (
  select
    ID,
    my_array
  from
    (
      --some array<struct> example
      select
        1 ID,
        array(1.1, 2.2, 3.3) as my_array
      union all
      select
        2 ID,
        array(4.4, 5.5, 6.6) as my_array
    ) s
)
select
  ID,
  concat_ws(',', collect_list(element)) as my_string --collect array of strings and concatenate it using ',' delimiter
from
  (
    select
      s.ID,
      cast(mystruct as string) as element --concatenate struct using : as a delimiter Or concatenate in some other way
    from
      mydata s lateral view explode(s.my_array) a as mystruct
  ) s
group by
  ID;

结果示意图:

id	my_string
2	4.4,5.5,6.6
1	1.1,2.2,3.3
这篇关于hive sql 将array<float>转成arrray<string>的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!