You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "binlijin (Created) (JIRA)" <ji...@apache.org> on 2012/02/08 05:46:59 UTC

[jira] [Created] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
--------------------------------------------------------------------------

                 Key: HIVE-2791
                 URL: https://issues.apache.org/jira/browse/HIVE-2791
             Project: Hive
          Issue Type: Bug
            Reporter: binlijin




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

Posted by "Ashutosh Chauhan (Updated) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashutosh Chauhan updated HIVE-2791:
-----------------------------------

    Fix Version/s: 0.9.0

+1. Will commit if tests pass.
                
> filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
> --------------------------------------------------------------------------
>
>                 Key: HIVE-2791
>                 URL: https://issues.apache.org/jira/browse/HIVE-2791
>             Project: Hive
>          Issue Type: Bug
>            Reporter: binlijin
>            Assignee: binlijin
>             Fix For: 0.9.0
>
>         Attachments: HIVE-2791.2.patch, HIVE-2791.patch
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

Posted by "Ankit Kamboj (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13506756#comment-13506756 ] 

Ankit Kamboj commented on HIVE-2791:
------------------------------------

Hi guys,

There is a use case I have attached: ppd-dropped-filter.q. The last 2 insert queries in the file contain following 'in' predicates:
where t3.crit5 in ('a' , 'b' ) and where t3.crit5 in ('c' , 'd' , 'e' )

The explain output doesn't contain Filter Operators for these 'in' predicates. This results in execution of incorrect query (without in clauses). 

The workaround is set hive.ppd.remove.duplicatefilters=false;

Is this use case related to this patch?
                
> filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
> --------------------------------------------------------------------------
>
>                 Key: HIVE-2791
>                 URL: https://issues.apache.org/jira/browse/HIVE-2791
>             Project: Hive
>          Issue Type: Bug
>            Reporter: binlijin
>            Assignee: binlijin
>             Fix For: 0.9.0
>
>         Attachments: HIVE-2791.2.patch, HIVE-2791.patch, ppd-dropped-filter.q
>
>


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

[jira] [Updated] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

Posted by "binlijin (Updated) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

binlijin updated HIVE-2791:
---------------------------

    Status: Patch Available  (was: In Progress)
    
> filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
> --------------------------------------------------------------------------
>
>                 Key: HIVE-2791
>                 URL: https://issues.apache.org/jira/browse/HIVE-2791
>             Project: Hive
>          Issue Type: Bug
>            Reporter: binlijin
>            Assignee: binlijin
>         Attachments: HIVE-2791.2.patch, HIVE-2791.patch
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Work started] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

Posted by "binlijin (Work started) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on HIVE-2791 started by binlijin.

> filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
> --------------------------------------------------------------------------
>
>                 Key: HIVE-2791
>                 URL: https://issues.apache.org/jira/browse/HIVE-2791
>             Project: Hive
>          Issue Type: Bug
>            Reporter: binlijin
>            Assignee: binlijin
>         Attachments: HIVE-2791.2.patch, HIVE-2791.patch
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

Posted by "Ankit Kamboj (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ankit Kamboj updated HIVE-2791:
-------------------------------

    Attachment: ppd-dropped-filter.q
    
> filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
> --------------------------------------------------------------------------
>
>                 Key: HIVE-2791
>                 URL: https://issues.apache.org/jira/browse/HIVE-2791
>             Project: Hive
>          Issue Type: Bug
>            Reporter: binlijin
>            Assignee: binlijin
>             Fix For: 0.9.0
>
>         Attachments: HIVE-2791.2.patch, HIVE-2791.patch, ppd-dropped-filter.q
>
>


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

[jira] [Assigned] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

Posted by "Ashutosh Chauhan (Assigned) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashutosh Chauhan reassigned HIVE-2791:
--------------------------------------

    Assignee: binlijin

Binlijin,
Is it ready for review? Mark Patch Available in that case. Also, reupload the patch granting the ASF perms.
                
> filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
> --------------------------------------------------------------------------
>
>                 Key: HIVE-2791
>                 URL: https://issues.apache.org/jira/browse/HIVE-2791
>             Project: Hive
>          Issue Type: Bug
>            Reporter: binlijin
>            Assignee: binlijin
>         Attachments: HIVE-2791.patch
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

Posted by "Ashutosh Chauhan (Updated) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashutosh Chauhan updated HIVE-2791:
-----------------------------------

    Resolution: Fixed
        Status: Resolved  (was: Patch Available)

Committed to trunk. Thanks, binlijin!
                
> filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
> --------------------------------------------------------------------------
>
>                 Key: HIVE-2791
>                 URL: https://issues.apache.org/jira/browse/HIVE-2791
>             Project: Hive
>          Issue Type: Bug
>            Reporter: binlijin
>            Assignee: binlijin
>             Fix For: 0.9.0
>
>         Attachments: HIVE-2791.2.patch, HIVE-2791.patch
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

Posted by "binlijin (Updated) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

binlijin updated HIVE-2791:
---------------------------

    Attachment: HIVE-2791.patch
    
> filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
> --------------------------------------------------------------------------
>
>                 Key: HIVE-2791
>                 URL: https://issues.apache.org/jira/browse/HIVE-2791
>             Project: Hive
>          Issue Type: Bug
>            Reporter: binlijin
>         Attachments: HIVE-2791.patch
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

Posted by "Hudson (Commented) (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13212984#comment-13212984 ] 

Hudson commented on HIVE-2791:
------------------------------

Integrated in Hive-trunk-h0.21 #1268 (See [https://builds.apache.org/job/Hive-trunk-h0.21/1268/])
    HIVE-2791: filter is still removed due to regression of HIVE-1538 althougth HIVE-2344 (binlijin via hashutosh) (Revision 1291916)

     Result = SUCCESS
hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1291916
Files : 
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/ppd/OpProcFactory.java
* /hive/trunk/ql/src/test/queries/clientpositive/ppd2.q
* /hive/trunk/ql/src/test/results/clientpositive/ppd2.q.out

                
> filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
> --------------------------------------------------------------------------
>
>                 Key: HIVE-2791
>                 URL: https://issues.apache.org/jira/browse/HIVE-2791
>             Project: Hive
>          Issue Type: Bug
>            Reporter: binlijin
>            Assignee: binlijin
>             Fix For: 0.9.0
>
>         Attachments: HIVE-2791.2.patch, HIVE-2791.patch
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

Posted by "binlijin (Updated) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

binlijin updated HIVE-2791:
---------------------------

    Attachment: HIVE-2791.2.patch
    
> filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
> --------------------------------------------------------------------------
>
>                 Key: HIVE-2791
>                 URL: https://issues.apache.org/jira/browse/HIVE-2791
>             Project: Hive
>          Issue Type: Bug
>            Reporter: binlijin
>            Assignee: binlijin
>         Attachments: HIVE-2791.2.patch, HIVE-2791.patch
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira