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.