Scala&Spark&sql合并行生成HTML[重复]

Question

我正在学习Scala和Spark，我有一个带有IDS的“tablatemporal”。在Scala中，我希望一行一行地合并一个文本，如下所示：

SELECT '<a href=https://www.myPage.com/visitID_' || _id  || '>VisitID</a>'
    FROM tablaTemporal

<a href=https://www.myWebPage.com/visitThisID_1>Visit ID tutorial</a>
<a href=https://www.myWebPage.com/visitThisID_2>Visit ID tutorial</a>
<a href=https://www.myWebPage.com/visitThisID_3>Visit ID tutorial</a>
<a href=https://www.myWebPage.com/visitThisID_4>Visit ID tutorial</a>
<a href=https://www.myWebPage.com/visitThisID_5>Visit ID tutorial</a>

val fixPartBefore = " <a href="https://www.myWebPage.com/visitThisID_> ";

val fixPartAfter = ">Visit ID tutorial</a>";

result = fixPartBefore + id + fixPartafter 

scala> val intento1 = sql("SELECT  _id  FROM tablaTemporal where _id < 6" )
intento1: org.apache.spark.sql.DataFrame = [_id: bigint]

scala> intento1.show(20, false)
+---+
|_id|
+---+
|1  |
|2  |
|3  |
|4  |
|5  |
+---+


scala>

Answer 1

您可以像这样使用UserDefinedFunction

val fixPartBefore = " <a href="https://www.myWebPage.com/visitThisID_> "

val fixPartAfter = ">Visit ID tutorial</a>"

val ownConcat = udf((id: String) => {
  fixPartBefore + id + fixPartafter
})

data.withColumn("html", ownConcat('id)).show

或者使用内置的concatconcat_ws函数