BigAN/Spark split a column value into multiple rows

## Spark split a column value into multiple rows

3
down vote
accepted
This is what you could do, split the string with pipe and explode the data using spark function

import org.apache.spark.sql.functions._
import spark.implicits._

val df = Seq(("a1", "b1", "c1|c2|c3|c4")).toDF("A", "B", "C")

df.withColumn("C", explode(split($"C", "\\|"))).show

	3
	down vote
	accepted
	This is what you could do, split the string with pipe and explode the data using spark function

	import org.apache.spark.sql.functions._
	import spark.implicits._

	val df = Seq(("a1", "b1", "c1\|c2\|c3\|c4")).toDF("A", "B", "C")

	df.withColumn("C", explode(split($"C", "\\\|"))).show