Hello,
Given the following example customers.json file:
{
"name": "Sherlock Holmes",
"customerNumber": 12345,
"address": {
"street": "221b Baker Street",
"city": "London",
"zipcode": "NW1 6XE",
"country": "United Kingdom"
}
},
{
"name": "Big Bird",
"customerNumber": 10001,
"address": {
"street": "123 Sesame Street",
"city": "Hensonville",
"zipcode": "56789",
"country": "United States"
}
}
And loading it with the following Scala code:
val sqlCtx = new org.apache.spark.sql.SQLContext(sc)
val customers = sqlCtx.jsonFile("hdfs:///customers.json")
How would I perform a select on the elements under the address? I tried
the following and a number of variations without success:
customers.select('address.city).collect()
I know I can do this using the SQL syntax, but I'm interested in how to do
this using the LINQ syntax.
Thank you for your help.
Cheers,
Brett