hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5830) SubQuery: Not In subqueries should check if subquery contains nulls in matching column
Date Mon, 09 Dec 2013 01:54:08 GMT

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

Harish Butani commented on HIVE-5830:
-------------------------------------

added comments to SubQueryUtils.
Will add a new jira for optimization.

> SubQuery: Not In subqueries should check if subquery contains nulls in matching column
> --------------------------------------------------------------------------------------
>
>                 Key: HIVE-5830
>                 URL: https://issues.apache.org/jira/browse/HIVE-5830
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Harish Butani
>            Assignee: Harish Butani
>             Fix For: 0.13.0
>
>         Attachments: HIVE-5830.2.patch, HIVE-5830.3.patch
>
>
> As pointed out by [~snarayanan]  in HIVE-784 for not in when there are nulls in the SubQuery's
matching column the Outer Query should return no rows.



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)

Mime
View raw message