Seems , it is only happening for Phoenix 4.0.0 and not for Phoenix 3.0.0
On Friday 04 July 2014 05:54 PM, puneet wrote:
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.
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
--
------------------------------------------------------------------------
*Puneet Ojha* | Tech Lead: Data Analytics
6th Floor, Amar Paradigm | Baner Road, Pune 411045
o: +91-20-67285700 | m: +91-8605359898 | Skype: puneetkr.ojha
PubMatic
<http://www.pubmatic.com/index-eng.php?utm_source=Footer&utm_medium=Email&utm_content=PuneLogo&utm_campaign=Corporate>
Every ad. Every sales channel. Every screen. *One platform*
On the Web: Facebook
<http://www.pubmatic.com/social/facebook.php?utm_source=Footer&utm_medium=Email&utm_content=PuneFacebook&utm_campaign=Corporate>
Twitter
<http://www.pubmatic.com/social/twitter.php?utm_source=Footer&utm_medium=Email&utm_content=PuneTwitter&utm_campaign=Corporate>
LinkedIn
<http://www.pubmatic.com/social/linkedin.php?utm_source=Footer&utm_medium=Email&utm_content=PuneLinkedIn&utm_campaign=Corporate>
Find out more about our services: PubConnect
<http://www.pubmatic.com/pubconnect.php?utm_source=Footer&utm_medium=Email&utm_content=PunePubConnect&utm_campaign=Corporate>
| PubDirect
<http://www.pubmatic.com/pubdirect.php?utm_source=Footer&utm_medium=Email&utm_content=PunePubDirect&utm_campaign=Corporate>
| Solutions for Media Buyers
<http://www.pubmatic.com/media-buyers-overview.php?utm_source=Footer&utm_medium=Email&utm_content=PuneMediaBuyers&utm_campaign=Corporate>
What's New: PubMatic Launches Mobile SDK for app developers.
<http://www.pubmatic.com/press/2013/PubMatic-Launches-Self-Service-Open-SDK.php?utm_source=Footer&utm_medium=Email&utm_content=PuneSDKLink&utm_campaign=Corporate>
Latest Research: Real-Time Bidding in the United States and Worldwide,
2010-2017 (Q4 2013)
<http://www.pubmatic.com/reports-and-whitepapers.php?utm_source=Footer&utm_medium=Email&utm_content=PuneReportsLink&utm_campaign=Corporate>
Recent Videos: Ad Revenue 6
<http://www.pubmatic.com/ar6_videos.php?utm_source=Footer&utm_medium=Email&utm_content=NYCAR6Link&utm_campaign=Corporate>
| Ad Revenue Europe
<http://www.pubmatic.com/arE_videos.php?utm_source=Footer&utm_medium=Email&utm_content=NYCAR6Link&utm_campaign=Corporate>
