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

Switch to Threaded View
Pig >> mail # user >> JOIN fails with Index Out Of Bounds Error


Copy link to this message
-
Re: JOIN fails with Index Out Of Bounds Error
Your script or a simple script that shows the problem would help.

On Tue, Sep 20, 2011 at 7:29 AM, Eli Finkelshteyn <[EMAIL PROTECTED]> wrote:

> Nope, just a simple inner join.
>
>
> On 9/19/11 7:48 PM, Raghu Angadi wrote:
>
>> Do you have a FLATTEN() involved? FLATTEN(null) can cause IndexOutOfBounds
>> exception. ( if that is the case,  see
>> http://www.mail-archive.com/**[EMAIL PROTECTED]/msg02275.**html<http://www.mail-archive.com/[EMAIL PROTECTED]/msg02275.html>)
>>
>> On Fri, Sep 16, 2011 at 8:04 AM, Eli Finkelshteyn<iefinkel@gmail.**com<[EMAIL PROTECTED]>
>> >wrote:
>>
>>  Hi,
>>> When doing an inner join on a column where some values are NULL, I get
>>> the
>>> following error:
>>> java.lang.****IndexOutOfBoundsException: Index: 1, Size: 1
>>>
>>> I can fix this by simply filtering out the NULL values in a separate step
>>> before joining, but the current behavior doesn't sound right to me, so I
>>> wanted to ask here before I do that. What's happening now sounds a lot
>>> like
>>> this:
>>> https://issues.apache.org/****jira/browse/PIG-1131<https://issues.apache.org/**jira/browse/PIG-1131>
>>> <https://**issues.apache.org/jira/browse/**PIG-1131<https://issues.apache.org/jira/browse/PIG-1131>
>>> >
>>>
>>> That bug was fixed on PIG 0.7, and I'm using PIG 0.8.1, so I'm trying to
>>> decide whether I should reopen it, or whether this is something else.
>>> Ideas?
>>>
>>> Eli
>>>
>>>
>