I am new to Hadoop/PIG. I have two data sets in my HDFS. One set is the Persons and the second set is the Addresses (CSV files). Both data sets have the unique id called personid. I want to be able to load both sets in my Apache PIG script and produce JSON with higher-level Peson object and inner level address objects. I couldn't find an easy way to do this. I appreciate any help. Thank you.
Ex JSON:
{
"person": {
"personid": "1",
"address": [
{ "city": "A" },
{ "city": "B" }
]
}
}
