[
https://issues.apache.org/jira/browse/PHOENIX-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor resolved PHOENIX-1063.
-----------------------------------
Resolution: Duplicate
Duplicate of PHOENIX-1057. Please let us know if you can repro this on HBase
0.98.1 or above.
> Filtering by a value doesn't filter the NULL values in Phoenix 4.0.0
> --------------------------------------------------------------------
>
> Key: PHOENIX-1063
> URL: https://issues.apache.org/jira/browse/PHOENIX-1063
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.0.0
> Reporter: Puneet
> Fix For: 3.0-Release
>
>
> I have specified specific filter value as 232 for geo column but it returns
> NULL values also for geo column. In order to restrict it I need to specify
> "is not NULL" for GEO column to restrict the NULL values.
> select Pub,Site,channel,Advertiser,GeoId,sum(TI),sum(Rev) from
> PUB_PARTIAL_CUBE where date>=19700116 and date<=19700116 and GeoId='232' and
> Pub=6846 and Site is not Null and Advertiser is not Null and ATD is Null and
> Section is Null and Ad_Tag is Null and Deal is Null and DSP is Null group by
> Pub,Site,channel,Advertiser,GeoId;
> | PUB | SITE | CHANNEL | ADVERTISER | GEOID | SUM(A.TI)
> | SUM(A.REV) |
> +------------+------------+------------+------------+------------+------------+------------+
> | 6846 | 6847 | 1 | 22621 | null | 8
> | 0.6575271999999999 |
> | 6846 | 6847 | 1 | 25267 | null | 48
> | 1.671988 |
> | 6846 | 6847 | 1 | 7921 | 232 | 1488
> | 114.79178239999995 |
> | 6846 | 6847 | 1 | 8710 | 232 | 8
> | 0.2285896 |
> It works for 3.0 but is not working for 4.0.
> Please provide a fix.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
