How to read json column with dot in it in scala?

  Kiến thức lập trình

I want to read json a column which has dot(.) in it. Below code works fine it there is no dot.

val data = """{
"abc.id": [{
    "id": "123",
    "name": "UNKNOWN"
}]}""";
println("schemajson", data);

   
val inputdata = spark.sparkContext.parallelize(data :: Nil);
val inputDF = spark.read.json(inputdata);
inputDF.show();
inputDF.select(inputDF.columns.map(c => col(c)(0).as(c)): _*).show()

LEAVE A COMMENT