[jira] [Created] (PHOENIX-1063) Filtering by a value doesn't filter the NULL values in Phoenix 4.0.0

["Puneet (JIRA)" <ji...@apache.org>]

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)