SPARK SQL – READING AND WRITING THE DATA IN DIFF FORMATS scala> val path = "/home/gopalkrishna/PRAC/SparkSQL/InputData.json" path: String = /home/gopalkrishna/PRAC/SparkSQL/InputData.json scala> val jsonFile = spark.read.json(path) jsonFile: org.apache.spark.sql.DataFrame = [Address: string, Age: bigint .. 4 more fields] scala> jsonFile.show scala> jsonFile.printSchema root |-- Address: string (nullable = true) |-- Age: long (nullable = true) |-- Desg: string (nullable = true) |-- State: string (nullable = true) |-- YrsOfExp: double (nullable = true) |-- name: string (nullable = true) scala> jsonFile.select("name","Age","Address","State").show scala> jsonFile.selectExpr("name","Desg").show scala> jsonFile.select($"name",$"Desg").show scala> jsonFile.select(jsonFile("name"),jsonFil...