Re: how to read object field within json file

2017-03-25 Thread Selvam Raman
ou want. >> >> Yong >> >> ------------------ >> *From:* Selvam Raman >> *Sent:* Thursday, March 23, 2017 5:03 PM >> *To:* user >> *Subject:* how to read object field within json file >> >> Hi, >> >> { >> "

Re: how to read object field within json file

2017-03-24 Thread Yong Zhang
I missed the part to pass in a schema to force the "struct" to a Map, then use explode. Good option. Yong From: Michael Armbrust Sent: Friday, March 24, 2017 3:02 PM To: Yong Zhang Cc: Selvam Raman; user Subject: Re: how to read object field within

Re: how to read object field within json file

2017-03-24 Thread Michael Armbrust
ined length , so you can > explode it and get the description easily. > > Now you need write your own UDF, maybe can do what you want. > > Yong > > -- > *From:* Selvam Raman > *Sent:* Thursday, March 23, 2017 5:03 PM > *To:* user > *

Re: how to read object field within json file

2017-03-23 Thread Yong Zhang
__ From: Selvam Raman Sent: Thursday, March 23, 2017 5:03 PM To: user Subject: how to read object field within json file Hi, { "id": "test1", "source": { "F1": { "id": "4970", "eId": "

how to read object field within json file

2017-03-23 Thread Selvam Raman
Hi, { "id": "test1", "source": { "F1": { "id": "4970", "eId": "F1", "description": "test1", }, "F2": { "id": "5070", "eId": "F2", "description": "test2", }, "F3": { "id": "5170", "eId": "F3", "description": "test3", },