Spark udf合并两个Array / List / Seq为一个Array / List / Seq,将所有元素放到一个Array / List / Seq中

在写Spark代码时, 发现有个场景需要合并两个List / Array / Seq为一个:
即: 合并两个Array[String]
在这里插入图片描述

输入: Array("1","2","3","4") Array("5","6","7","8")
输出: Array("1","2","3","4","5","6","7","8")

或者:

输入: ["1","2","3","4"] ["5","6","7","8"]
输出: ["1","2","3","4","5","6","7","8"]

但是Spark中没有实现类似功能的算子, 于是自己写了一个UDF去实现, 话不多说, 贴代码供大家参考.

UDF代码:

object UdfUtils {
  def udfUnionString(): UserDefinedFunction = {
    def unionString(arrayOne: Seq[String], arrayTwo: Seq[String]): Array[String] = {
      if ((arrayOne == null || arrayOne.isEmpty) && (arrayTwo == null || arrayTwo.isEmpty)) {
        Array[String]()
      } else if (arrayOne == null || arrayOne.isEmpty) {
        arrayTwo.toArray
      } else if (arrayTwo == null || arrayTwo.isEmpty) {
        arrayOne.toArray
      } else {
        (arrayOne ++ arrayTwo).toArray
      }
    }

    udf((arrayOne: Seq[String], arrayTwo: Seq[String]) =>
      unionString(arrayOne, arrayTwo),
      ArrayType(StringType)
    )
  }
}

调用UDF代码:

testDF.select(
    UdfUtils.udfUnionString()(testDf1("array1"),testDf2("array2"))
)

示例:

testDf1("array1"):
    ["1","2","3","4"] 
    ["a1","b1","c1","d1"]
    ...

testDf2("array2"):
    ["5","6","7","8"] 
    ["a2","b2","c2","d2"]
    ...
    
结果:
    ["1","2","3","4","5","6","7","8"]
    ["a1","b1","c1","d1","a2","b2","c2","d2"]
  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值