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)
