Hari Sankar Sivarama Subramaniyan created HIVE-12640: --------------------------------------------------------
Summary: Allow StatsOptimizer to optimize the query for Constant GroupBy keys Key: HIVE-12640 URL: https://issues.apache.org/jira/browse/HIVE-12640 Project: Hive Issue Type: Bug Reporter: Hari Sankar Sivarama Subramaniyan Assignee: Hari Sankar Sivarama Subramaniyan {code} hive> select count('1') from src group by '1'; {code} In the above query, while performing StatsOptimizer optimization we can safely ignore the group by on the constant key '1' since the above query will return the same result as "select count('1') from src". -- This message was sent by Atlassian JIRA (v6.3.4#6332)