Scala join comma delimited file as tables

Question

I have two data set both are csv format and I want to join both the tables using comma delimited. Can u give any examples for the above scenario?

Answer 1

Dataframe creation commands:​

Now we will register them as tempTables and will do sparksql:

For loading file in comma delimited csv to a dataframe, please refer to the below command:

val df1 = sqlContext.read.format("csv").option("header", "true").option("delimiter", ",").option("inferschema", "false").load("stud.csv");