Re: Hive 0.12 Mapjoin and MapJoinMemoryExhaustionException

2014-06-23 Thread Nagarjuna Vissarapu
send it with a different and informative > subjects on a separate mail. > > > > *From:* Matouk IFTISSEN [mailto:matouk.iftis...@ysance.com] > *Sent:* Monday, June 23, 2014 11:49 AM > *To:* user@hive.apache.org > *Subject:* Re: Hive 0.12 Mapjoin and MapJoinMemoryExhaustio

Hive 0.12 Mapjoin and MapJoinMemoryExhaustionException

2014-06-23 Thread Dima Machlin
Hello, We are running Hive 0.12 and using the hive.auto.convert.join feature when : hive.auto.convert.join.noconditionaltask.size = 5000 hive.mapjoin.followby.gby.localtask.max.memory.usage = 0.7 The query is a mapjoin with a group by afterwards like so : select id,x,max(y) from ( select t1.i