Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
>>>
>>>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB