hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "caofangkun (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-3298) select 1+1 from dual; if dual is an empty table this statement will return no result
Date Wed, 25 Jul 2012 09:02:34 GMT
caofangkun created HIVE-3298:
--------------------------------

             Summary: select 1+1 from dual; if dual is an empty table this statement will
return no result 
                 Key: HIVE-3298
                 URL: https://issues.apache.org/jira/browse/HIVE-3298
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 0.8.1
         Environment: Linux  3.0.0-14-generic #23-Ubuntu SMP Mon Nov 21 20:34:47 UTC 2011
i686 i686 i386 GNU/Linux
java version "1.6.0_25"
hadoop-0.20.2-cdh3u0
hive-0.8.1
            Reporter: caofangkun
            Priority: Minor


hive>drop table if exists dual;
hive>create table dual (dummy string);
hive>select 1+1 from dual;

Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201206081154_0458, Tracking URL = http://dwtest-93-61:50030/jobdetails.jsp?jobid=job_201206081154_0458
Kill Command = /home/hive/hadoop-0.20.2-cdh3u0/bin/hadoop job  -Dmapred.job.tracker=dwtest-93-61:9001
-kill job_201206081154_0458
Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0
2012-07-25 16:58:15,793 Stage-1 map = 0%,  reduce = 0%
2012-07-25 16:58:17,817 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201206081154_0458
MapReduce Jobs Launched: 
Job 0:  HDFS Read: 0 HDFS Write: 0 SUCESS
Total MapReduce CPU Time Spent: 0 msec
OK
Time taken: 6.607 seconds


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message