Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-3298

select 1+1 from dual; if dual is an empty table this statement will return no result

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 0.8.1
    • Fix Version/s: None
    • Component/s: Query Processor
    • Labels:
      None
    • 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

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              caofangkun caofangkun
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: