hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-1586) prune operators for empty inputs
Date Tue, 24 Aug 2010 00:02:16 GMT
prune operators for empty inputs
--------------------------------

                 Key: HIVE-1586
                 URL: https://issues.apache.org/jira/browse/HIVE-1586
             Project: Hadoop Hive
          Issue Type: Improvement
          Components: Query Processor
    Affects Versions: 0.6.0
            Reporter: John Sichi
            Assignee: John Sichi
             Fix For: 0.7.0


Given this:

create view v as
select * from (
select *,'T1' as m from pokes
union all
select *,'T2' as m from pokes2) u;

select * from v
where m='T2';

When we optimize the query, we can prune away all inputs to the union other than the one which
references pokes2.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message