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

[Aihua Xu (JIRA)]

Aihua Xu created HIVE-11446:
-------------------------------

             Summary: "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
            Assignee: 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)