Load custom delimited file in Spark

Question

I have a DAT file, which is pipe(|) delimited. How can I load the custom delimited file into the dataframe?

Answer 1

Refer to the following code:

val sqlContext = sqlContext.read.format("csv").option("delimiter","|").load("emp_pipeline.DAT)