[jira] [Commented] (HIVE-10773) MapJoinOperator times out on loading HashTable

["VARIDH BHARGAVA (JIRA)" <ji...@apache.org>]

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

VARIDH BHARGAVA commented on HIVE-10773:
----------------------------------------

Is this an expected behavior ?
We are running into similar issue where in using "hive.auto.convert.join=true"  and using tables in join clause whose size is not more than 100 MB, we are seeing execution time of almost 5-6 hours !

We are using following settings :
set HADOOP_HEAPSIZE=5120;
set hive.auto.convert.join=true;
set hive.auto.convert.join.noconditionaltask=true;
set hive.auto.convert.join.noconditionaltask.size=1000000000;
set mapred.task.timeout=600000;

OR is there is a work around for the same


> MapJoinOperator times out on loading HashTable
> ----------------------------------------------
>
>                 Key: HIVE-10773
>                 URL: https://issues.apache.org/jira/browse/HIVE-10773
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.14.0
>            Reporter: frank luo
>
> When running a map join, depends on data, it might timeout with last two lines in the log as below. And when I do "set mapreduce.task.timeout=600000;", which is defaulted to 300000, the query can go through fine. The size of hashtable file is roughly 400M. 
> 2015-05-20 13:27:03,237 INFO [main] org.apache.hadoop.hive.ql.exec.MapJoinOperator: ******* Load from HashTable for input file: hdfs://nameservice1/tmp/hive/jluo/2ee8914d-1cef-4af4-aac6-51f64d630346/hive_2015-05-20_13-13-35_335_1565066409090716856-1/-mr-10007/000000_0
> 2015-05-20 13:27:03,237 INFO [main] org.apache.hadoop.hive.ql.exec.MapJoinOperator: 	Load back 1 hashtable file 
> from tmp file uri:file:/data/12/hadoop/yarn/local/usercache/xxy/appcache/application_1430337284339_2087
> /container_1430337284339_2087_01_000003/Stage-3.tar.gz/MapJoin-mapfile31--.hashtable 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)