hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Wilfong (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-2812) Hive multi group by single reducer optimization fails when aggregation with no keys followed by query with no aggregations
Date Tue, 18 Dec 2012 00:20:27 GMT

     [ https://issues.apache.org/jira/browse/HIVE-2812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kevin Wilfong updated HIVE-2812:
--------------------------------

    Status: Patch Available  (was: Open)
    
> Hive multi group by single reducer optimization fails when aggregation with no keys followed
by query with no aggregations
> --------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2812
>                 URL: https://issues.apache.org/jira/browse/HIVE-2812
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Kevin Wilfong
>            Assignee: Kevin Wilfong
>         Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2812.D1821.1.patch, HIVE-2812.2.patch.txt,
HIVE-2812.D1821.2.patch
>
>
> In multi insert queries where one subquery involves an aggregation with no distinct or
group by keys and is followed by a query without any aggregations, like the following, Hive
will attempt to add a group by operator for the query without aggregations, causing semantic
analysis to fail.
> FROM src
> INSERT OVERWRITE TABLE table1 SELECT count(*)
> INSERT OVERWRITE TABLE table2 SELECT key;

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message