phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From puneet <puneet.ku...@pubmatic.com>
Subject Re: Need to specify IS NOT NULL explicitly even when specifying filter value
Date Fri, 04 Jul 2014 12:50:17 GMT
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>


Mime
View raw message