vishal.rajan created HIVE-15197:
-----------------------------------
Summary: count sum query on empty table, returning empty output
Key: HIVE-15197
URL: https://issues.apache.org/jira/browse/HIVE-15197
Project: Hive
Issue Type: Bug
Affects Versions: 2.1.0
Reporter: vishal.rajan
When the below query is run in hive 1.2 it returns 'NULL NULL 0' but
when the same query is run on hive 2.1.0, nothing is returned.
----------------hive 1.2.0 -------------------------
hive> SELECT sum(destination_pincode),sum(length(source_city)),count(*) from
test_stage.geo_zone;
MapReduce Jobs Launched:
Stage-Stage-1: Map: 1 Cumulative CPU: 4.79 sec HDFS Read: 7354 HDFS Write:
114 SUCCESS
Total MapReduce CPU Time Spent: 4 seconds 790 msec
OK
NULL NULL 0
Time taken: 38.168 seconds, Fetched: 1 row(s)
---------------------hive 2.1.0-------------------------------------
hive> SELECT sum(destination_pincode),sum(length(source_city)),count(*) from
test_stage.geo_zone
WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the
future versions. Consider using a different execution engine (i.e. spark, tez)
or using Hive 1.X releases.
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
2016-11-14 19:06:15,421 WARN [Thread-215] mapreduce.JobResourceUploader
(JobResourceUploader.java:uploadFiles(64)) - Hadoop command-line option parsing
not performed. Implement the Tool interface and execute your application with
ToolRunner to remedy this.
2016-11-14 19:06:19,222 INFO [Thread-215] input.FileInputFormat
(FileInputFormat.java:listStatus(283)) - Total input paths to process : 1
2016-11-14 19:06:20,000 INFO [Thread-215] mapreduce.JobSubmitter
(JobSubmitter.java:submitJobInternal(198)) - number of splits:0
Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0
2016-11-14 19:06:39,405 Stage-1 map = 0%, reduce = 0%
Stage-Stage-1: HDFS Read: 0 HDFS Write: 0 SUCCESS
Total MapReduce CPU Time Spent: 0 msec
OK
Time taken: 28.302 seconds
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
