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