hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hari Sankar Sivarama Subramaniyan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-12640) Allow StatsOptimizer to optimize the query for Constant GroupBy keys
Date Wed, 09 Dec 2015 22:13:11 GMT
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)

Mime
View raw message