[jira] [Resolved] (HIVE-11446) "Select distinct" always gives OOM error in the local run

["Aihua Xu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-11446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aihua Xu resolved HIVE-11446.
-----------------------------
    Resolution: Cannot Reproduce
      Assignee:     (was: Aihua Xu)

I saw this issue and then tried to debug. But it works during the debug, then after that, it also works without debug. Probably it's due to my own hadoop setup. 

> "Select distinct" always gives OOM error in the local run
> ---------------------------------------------------------
>
>                 Key: HIVE-11446
>                 URL: https://issues.apache.org/jira/browse/HIVE-11446
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 2.0.0
>            Reporter: Aihua Xu
>
> {noformat}
> create table src (key string);
> select distinct t1.key from src t1, src t2 where t1.key=t2.key;
> {noformat}
> The command fails with OOM error.
> {noformat}
> java.lang.Exception: java.lang.OutOfMemoryError: Java heap space
>         at org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:406)
> Caused by: java.lang.OutOfMemoryError: Java heap space
>         at org.apache.hadoop.mapred.MapTask$MapOutputBuffer.init(MapTask.java:826)
>         at org.apache.hadoop.mapred.MapTask.createSortingCollector(MapTask.java:376)
>         at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:406)
>         at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332)
>         at org.apache.hadoop.mapred.LocalJobRunner$Job$MapTaskRunnable.run(LocalJobRunner.java:268)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>         at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>         at java.lang.Thread.run(Thread.java:745)
> {noformat}



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