Try: "address.city".attr
On Tue, Oct 28, 2014 at 8:30 AM, Brett Antonides <banto...@gmail.com> wrote:
> 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
>
>
>
