hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Namit Jain (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1034) Predicate pushdown should work with single insert in the form of FROM TABLE INSERT ... SELECT ... WHERE. ..pred
Date Thu, 07 Jan 2010 23:04:54 GMT

    [ https://issues.apache.org/jira/browse/HIVE-1034?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12797826#action_12797826
] 

Namit Jain commented on HIVE-1034:
----------------------------------

This is the expected behavior - the filters are not removed currently.

> Predicate pushdown should work with single insert in the form of FROM TABLE INSERT ...
SELECT ... WHERE. ..pred
> ---------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-1034
>                 URL: https://issues.apache.org/jira/browse/HIVE-1034
>             Project: Hadoop Hive
>          Issue Type: Improvement
>            Reporter: Ning Zhang
>
> One sample query is 
> FROM a JOIN b ON a.eid = b.eid AND a.ds>='2009-10-01' AND a.ds<='2009-12-01' AND
b.ds>='2009-10-01' AND b.ds<='2009-12-01'
> INSERT OVERWRITE TABLE t SELECT a.user, b.user, a.eid, a.time
> WHERE (a.time < 1259625600) and a.user <> b.user;
> Here a.time<1259625600 should be pushed down before the join since there is only 1
insert. This optimization should NOT be done if there are multiple inserts. 

-- 
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