How would i retrieve data JSON data with namespaces using spark SQL?

[rammy]

File.json from the below code contains huge JSON data with each key containing namespace prefix(This JSON file converted from the XML file).

I could able to retrieve if JSON does not contain namespaces but what could be the approach to retrieve records/values if each key is with a namespace prefix?

jsondf = spark.read.json("<path>/file.json")
 
#jsondf.printSchema()
jsondf.createOrReplaceTempView("ramp")
 
elements = spark.sql("SELECT * FROM ramp")
elements.show()
 

Here,I wanted to retrieve records of w: document/w.body/w:p. I tried different ways but nothing is working. Any suggestions really helpful

[Pat]

HI @Ramesh Bathini​ ,

not sure what you have tried, but maybe you can try this way:

 select `w:document`.`w.body`.`w:p` from ramp

[rammy]

Thanks alot @Pat Sienkiewicz​  for your response. It works for me

[SS2]

I case of struct you can use (.) For extracting the value