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