phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From puneet <puneet.ku...@pubmatic.com>
Subject Need to specify IS NOT NULL explicitly even when specifying filter value
Date Fri, 04 Jul 2014 12:24:06 GMT
Hi Team,

Please see the query below :-

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          | 1          | null       | 
48         | 5.494624800000002 |
| 6846       | 6847       | 1          | 11104      | null       | 
8          | 2.523784   |
| 6846       | 6847       | 1          | 1170       | null       | 
4          | 0.068464   |
| 6846       | 6847       | 1          | 11742      | null       | 
44         | 17.987671999999968 |
| 6846       | 6847       | 1          | 13131      | null       | 
24         | 0.36       |
| 6846       | 6847       | 1          | 14302      | null       | 
4          | 0.06197559999999999 |
| 6846       | 6847       | 1          | 15423      | null       | 
8          | 0.8070079999999998 |
| 6846       | 6847       | 1          | 1835       | null       | 
40         | 5.304000000000001 |
| 6846       | 6847       | 1          | 19840      | null       | 
0          | 0.13607999999999998 |
| 6846       | 6847       | 1          | 1995       | null       | 
4          | 0.06       |
| 6846       | 6847       | 1          | 20865      | null       | 
0          | 0.044000000000000004 |
| 6846       | 6847       | 1          | 22621      | null       | 
8          | 0.6575271999999999 |
| 6846       | 6847       | 1          | 25267      | null       | 
48         | 1.671988   |
| 6846       | 6847       | 1          | 3307       | null       | 
456        | 42.85293920000001 |
| 6846       | 6847       | 1          | 34158      | null       | 
8          | 0.12       |
| 6846       | 6847       | 1          | 37090      | null       | 
188        | 5.264767200000002 |
| 6846       | 6847       | 1          | 7262       | null       | 
40         | 1.0799055999999998 |
| 6846       | 6847       | 1          | 8544       | null       | 
640        | 346.3737784000001 |
| 6846       | 6847       | 1          | 1          | 232        | 
12         | 1.5472752000000002 |
| 6846       | 6847       | 1          | 13682      | 232        | 
4          | 0.108      |
| 6846       | 6847       | 1          | 15033      | 232        | 
16         | 0.24       |
| 6846       | 6847       | 1          | 21033      | 232        | 
0          | 0.13223520000000002 |
| 6846       | 6847       | 1          | 2431       | 232        | 
8          | 0.8227711999999998 |
| 6846       | 6847       | 1          | 2670       | 232        | 
24         | 0.5745912000000001 |
| 6846       | 6847       | 1          | 2856       | 232        | 
0          | 0.7346728  |
| 6846       | 6847       | 1          | 3349       | 232        | 
4          | 0.63191    |
| 6846       | 6847       | 1          | 3837       | 232        | 
0          | 0.47881680000000004 |
| 6846       | 6847       | 1          | 390        | 232        | 
8          | 1.0987328  |
| 6846       | 6847       | 1          | 5805       | 232        | 
0          | 0.32800000000000003 |
| 6846       | 6847       | 1          | 69         | 232        | 
0          | 0.008      |
| 6846       | 6847       | 1          | 6953       | 232        | 
0          | 0.11691760000000001 |
| 6846       | 6847       | 1          | 7921       | 232        | 
1488       | 114.79178239999995 |
| 6846       | 6847       | 1          | 8710       | 232        | 
8          | 0.2285896  |

Let me know if it needs to be explicitly specified (It's not the case 
with SQL) OR there is something I am missing OR it is a bug.

-- 
------------------------------------------------------------------------

*Puneet Ojha* | Tech Lead: Data Analytics



Mime
View raw message