Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1063

Filtering by a value doesn't filter the NULL values in Phoenix 4.0.0

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 4.0.0
    • Fix Version/s: 3.0.0
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              puneetkumar.0306 Puneet
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: