Is there a way to get column names using hiveContext?

Question

I have "iplRDD", which is json, and I do the below steps and request through hivecontext. I get results, but without column headers. Is there a way to get column names along with values?

val teamRDD = hiveContext.jsonRDD(iplRDD) 
teamRDD.registerTempTable("teams") 
hiveContext.cacheTable("teams") 

val result = hiveContext.sql("select * from teams where  team_name = "KKR" ) 
result.collect.foreach(println) 

Any thoughts please?

Answer 1

teamRDD.schema.fieldNames must contain the names of the headers.

Answer 2

You can save your “result” in a data frame with a header as a CSV file:

result.write().format("com.databricks.spark.csv").option("header", "true").save(outputPath);

Answer 3

, :

result.schema().fields();