Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> Nested JSON.

Copy link to this message
Re: Nested JSON.
Hi Satish,
     from what I understand you are trying to convert your csv files into json objects. Can you try joining your two data sets based on personid , more on join here http://pig.apache.org/docs/r0.10.0/basic.html#JOIN. Once you have the data in one relation pass that to a UDF which can construct a json object (http://pig.apache.org/docs/r0.10.0/udf.html#udf-java).

On Tuesday, February 12, 2013 at 10:30 AM, Satish Kolli wrote:

> 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" }
> ]
> }
> }