要根据第一次出现的空格将forenames列拆分为first_name和last_name，可以在Spark SQL中使用SPLIT和SUBSTRING_INDEX函数。下面是如何实现的。

scala> val dfa = spark.sql("SELECT  forenames, SUBSTRING_INDEX(forenames, ' ', 1) AS first_name, SUBSTRING(forenames, LENGTH(SUBSTRING_INDEX(forenames, ' ', 1)) + 2) AS last_name FROM df")
dfa: org.apache.spark.sql.DataFrame = [forenames: string, first_name: string ... 1 more field]
scala> dfa.show(false)
+-----------------+----------+-----------+
|forenames        |first_name|last_name  |
+-----------------+----------+-----------+
|IVO-KAI ROGERS   |IVO-KAI   |ROGERS     |
|DYLAN STUART JOHN|DYLAN     |STUART JOHN|
|JOSH JACK        |JOSH      |JACK       |
|MONALISA ELIEN   |MONALISA  |ELIEN      |
+-----------------+----------+-----------+

字符串

你可以使用下面的pyspark代码来拆分第一列，并创建两个新闻列：

df.withColumn('first_name', split(df['forenames'], ' ').getItem(0))\
  .withColumn('last_name', concat_ws(" ",split(df['forenames'], ' ').getItem(1), split(df['forenames'], ' ').getItem(2) ))

字符串
最好的问候，侯赛因