Re: NegativeArraySizeException in table join

2015-01-15 Thread Ashutosh Chauhan
Interesting. You mean to say there is no bug in Hive, but in some other component (yarn / MR). Stack trace seems to indicate there is something going on in Hive side as well. Granted stack trace of 9324 is not identical to yours, but both points problem in similar area. On Thu, Jan 15, 2015 at 7:5

Re: NegativeArraySizeException in table join

2015-01-15 Thread Guodong Wang
Hi Ashutosh, Thanks for your reply. Not sure if HIVE-9324 is the same issue we met. We found it is a bug in CDH when using MR1 with hive 0.13.1. This bug does not exist when using yarn with 0.13.1. Guodong On Fri, Jan 16, 2015 at 1:21 AM, Ashutosh Chauhan wrote: > Seems like you are hitting

Re: NegativeArraySizeException in table join

2015-01-15 Thread Ashutosh Chauhan
Seems like you are hitting into : https://issues.apache.org/jira/browse/HIVE-9324 On Thu, Jan 15, 2015 at 1:53 AM, Guodong Wang wrote: > Hi, > > I am using hive 0.13.1 and currently I am blocked by a bug when joining 2 > tables. Here is the sample query. > > INSERT OVERWRITE TABLE test_archive P

NegativeArraySizeException in table join

2015-01-15 Thread Guodong Wang
Hi, I am using hive 0.13.1 and currently I am blocked by a bug when joining 2 tables. Here is the sample query. INSERT OVERWRITE TABLE test_archive PARTITION(data='2015-01-17', name, type) SELECT COALESCE(b.resource_id, a.id) AS id, a.timstamp, a.payload, a.name, a.typ