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

Rajesh Balamohan commented on HIVE-10551:
-----------------------------------------

hive.auto.convert.join.noconditionaltask.size=128000000.  I will attach the 
plan as an attachment.

> OOM when running query_89 with vectorization on & hybridgrace=false
> -------------------------------------------------------------------
>
>                 Key: HIVE-10551
>                 URL: https://issues.apache.org/jira/browse/HIVE-10551
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Rajesh Balamohan
>         Attachments: HIVE-10551-explain-plan.log, hive_10551.png
>
>
> - TPC-DS Query_89 @ 10 TB scale
> - Trunk version of Hive + Tez 0.7.0-SNAPSHOT
> - Additional settings ( "hive.vectorized.groupby.maxentries=1024 , 
> tez.runtime.io.sort.factor=200  tez.runtime.io.sort.mb=1800 
> hive.tez.container.size=4096 ,hive.mapjoin.hybridgrace.hashtable=false" )
> Will attach the profiler snapshot asap.



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

Reply via email to