Puneet created PHOENIX-1063:
-------------------------------
Summary: 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)
