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

Switch to Threaded View
Pig, mail # user - Accessing Nested Json


Copy link to this message
-
Re: Accessing Nested Json
hc busy 2010-09-30, 03:09
hooray!

On Wed, Sep 29, 2010 at 4:24 PM, Alan Gates <[EMAIL PROTECTED]> wrote:

>
> On Sep 29, 2010, at 3:46 PM, hc busy wrote:
>
>  I thought map can only take bytearray as value type?
>>
>
> No, it can take any type as a value.  There are just a number of places
> where Pig assumes it is a byte array and then does the wrong thing (like if
> you try to order by it).  If the user just dereferences the object as if it
> were a tuple or a map then Pig should implicitly cast it and do the right
> thing.
>
> As a side note, we plan to fix the bad byte array assumptions issues in Pig
> 0.9.  See in particular https://issues.apache.org/jira/browse/PIG-1281,
> https://issues.apache.org/jira/browse/PIG-1065, and
> https://issues.apache.org/jira/browse/PIG-999.
>
> Alan.
>
>
>
>> On Wed, Sep 29, 2010 at 1:53 PM, Alan Gates <[EMAIL PROTECTED]> wrote:
>>
>>  Are you loading them as tuples or maps?  If you're loading them as tuples
>>> than you should be able to say x.keyA.pA (which should return "vA").  If
>>> you're loading them as maps than it would be x#'keyA'#'pA'
>>>
>>> Alan.
>>>
>>>
>>> On Sep 28, 2010, at 12:45 PM, rakesh kothari wrote:
>>>
>>>
>>>  Hi,
>>>>
>>>> Is there a good way to access nested properties that are multilevel deep
>>>> from Json objects loaded in Pig ?
>>>>
>>>> For example, if my json is like:
>>>>
>>>> {"keyA":{"pA":"vA"}} and I need to access "pA".
>>>>
>>>> Thanks,
>>>> -Rakesh
>>>>
>>>>
>>>>
>>>
>>>
>