hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-124) aggregation on empty table should still return 1 row
Date Fri, 05 Dec 2008 10:19:44 GMT
aggregation on empty table should still return 1 row
----------------------------------------------------

                 Key: HIVE-124
                 URL: https://issues.apache.org/jira/browse/HIVE-124
             Project: Hadoop Hive
          Issue Type: Bug
            Reporter: Zheng Shao


The query  "SELECT COUNT(1) FROM f_status_update fsu WHERE FALSE" should return a single row
with value 0.

Our code treat that query as "SELECT 1, COUNT(1) FROM f_status_update fsu WHERE FALSE GROUP
BY 1", but these 2 queries are not equivalent because the second query will return empty result
if the input is empty.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message