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
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 )
> On Fri, Sep 16, 2011 at 8:04 AM, Eli Finkelshteyn<[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>
>> 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