[ https://issues.apache.org/jira/browse/HIVE-124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jeff Hammerbacher updated HIVE-124: ----------------------------------- Component/s: Query Processor Adding to "Query Processor" component. > 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 > Components: Query Processor > 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.