You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "caofangkun (JIRA)" <ji...@apache.org> on 2012/07/25 11:02:34 UTC
[jira] [Created] (HIVE-3298) select 1+1 from dual; if dual is an
empty table this statement will return no result
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
[jira] [Resolved] (HIVE-3298) select 1+1 from dual; if dual is an
empty table this statement will return no result
Posted by "Edward Capriolo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Capriolo resolved HIVE-3298.
-----------------------------------
Resolution: Won't Fix
> 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
[jira] [Commented] (HIVE-3298) select 1+1 from dual; if dual is an
empty table this statement will return no result
Posted by "Edward Capriolo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13422325#comment-13422325 ]
Edward Capriolo commented on HIVE-3298:
---------------------------------------
That is what it is supposed to do. If you are selecting a table with no rows you are going to get no rows. Consider looking at the duelinputformat I created. It always returns a single row regardless of the data.
https://github.com/edwardcapriolo/DualInputFormat
> 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