You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/07/08 19:02:05 UTC
[jira] [Resolved] (PHOENIX-1063) Filtering by a value doesn't
filter the NULL values in Phoenix 4.0.0
[ 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)