[ 
https://issues.apache.org/jira/browse/HIVE-18445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16325504#comment-16325504
 ] 

Laszlo Bodor commented on HIVE-18445:
-------------------------------------

Or we can completely turn of auto join for statements out of scope, the test 
case will test conditonal task and exhaustion anyway. The current problem is, 
sometimes there are repeated errors messages in q.out. Further investigation is 
in progress.

q file
{code}
set hive.auto.convert.join = true;
FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key 
+ src2.key = src3.key)
INSERT OVERWRITE TABLE dest_j2 SELECT src1.key, src3.value;
set hive.auto.convert.join = false;
{code}

q.out file
{code}
PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src 
src3 ON (src1.key + src2.key = src3.key)
INSERT OVERWRITE TABLE dest_j2 SELECT src1.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest_j2
*Hive Runtime Error: Map local work exhausted memory
FAILED: Execution Error, return code 3 from 
org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.mr.MapRedTask
Hive Runtime Error: Map local work exhausted memory
FAILED: Execution Error, return code 3 from 
org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.mr.MapRedTask*
POSTHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src 
src3 ON (src1.key + src2.key = src3.key)
INSERT OVERWRITE TABLE dest_j2 SELECT src1.key, src3.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest_j2
{code}

> qtests: auto_join25.q fails permanently
> ---------------------------------------
>
>                 Key: HIVE-18445
>                 URL: https://issues.apache.org/jira/browse/HIVE-18445
>             Project: Hive
>          Issue Type: Bug
>          Components: Tests
>            Reporter: Laszlo Bodor
>            Assignee: Laszlo Bodor
>
> org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_join25] 
> (batchId=72)



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to