[
https://issues.apache.org/jira/browse/CARBONDATA-242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15496181#comment-15496181
]
ASF GitHub Bot commented on CARBONDATA-242:
---
GitHub user sujith71955 opened a pull request:
https://github.com/apache/incubator-carbondata/pull/159
[Issue Number] CARBONDATA-242
[Problem] Filter result was not compatible with hive result when a null
filter member is present in not in
filter model, as per hive no result shall be return if a NOT IN filter
model has null object for comparison.
eg: select country from t3 where country not in (null,'china','france')
group by country
[Description] When user provides Null member inside NOT IN filter condition
the resultset is not compatible with hive result.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sujith71955/incubator-carbondata
master_StartsWithIssue
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-carbondata/pull/159.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #159
commit 8709af0cebc07e8ac25f40f4a31dfdc95b4eb5e6
Author: sujith71955
Date: 2016-09-15T09:23:04Z
[Issue Number] CARBONDATA-242
[Description] When user provides Null member inside NOT IN filter condition
the resultset is not compatible with hive result
> NOT IN with Null filter results are not compatible With Hive
>
>
> Key: CARBONDATA-242
> URL: https://issues.apache.org/jira/browse/CARBONDATA-242
> Project: CarbonData
> Issue Type: Bug
>Reporter: Sujith
>Assignee: Sujith
>Priority: Minor
>
> When user provides Null member inside NOT IN filter condition the resultset
> is not compatible with hive result.
> Eg:
> select country from t3 where country not in ('china','france',null) group by
> country
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)