You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Gang Tim Liu (JIRA)" <ji...@apache.org> on 2012/12/06 19:37:10 UTC
[jira] [Assigned] (HIVE-3773) Share input scan by unions across
multiple queries
[ https://issues.apache.org/jira/browse/HIVE-3773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gang Tim Liu reassigned HIVE-3773:
----------------------------------
Assignee: Gang Tim Liu (was: Namit Jain)
> Share input scan by unions across multiple queries
> --------------------------------------------------
>
> Key: HIVE-3773
> URL: https://issues.apache.org/jira/browse/HIVE-3773
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Gang Tim Liu
>
> Consider a query like:
> select * from
> (
> select key, 1 as value, count(1) from src group by key
> union all
> select 1 as key, value, count(1) from src group by value
> union all
> select key, value, count(1) from src group by key, value
> ) s;
> src is scanned multiple times currently (one per sub-query).
> This should be treated like a multi-table insert by the optimizer.
--
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