Spark SQL query for List

[Ramkumar V]

Hi,

I had loaded JSON file in parquet format into SparkSQL. I can't able to
read List which is inside JSON.

Sample JSON

{
"TOUR" : {
     "CITIES" : ["Paris","Berlin","Prague"]
},
"BUDJET" : 1000000
}

I want to read value of CITIES.

*Thanks*,
<https://in.linkedin.com/in/ramkumarcs31>