What behavior are you seeing when the NOT is present?
On Fri, Nov 30, 2018, 9:27 AM Serdar Sakin <ser...@reklamstore.com wrote:
> Hi guys,
>
> We need help with "Not" filter on Druid. Somehow, "Not" filter is not
> working when it is used with other filters. The same query is working when
> we remove the "Not" filter. You can see the query we make below:
>
> {
> "aggregations":[
> {
> "type":"longSum",
> "fieldName":"requests",
> "name":"requests"
> },
> {
> "type":"longSum",
> "fieldName":"impressions",
> "name":"impressions"
> }
> ],
> "granularity":"all",
> "intervals":[
> "2018-11-29T00:00:00+00:00/2018-11-30T00:00:00+00:00"
> ],
> "dimensions":[
> "ssp"
> ],
> "having":{
> "type":"greaterThan",
> "aggregation":"impressions",
> "value":0
> },
> "dataSource":"adx_reports",
> "queryType":"groupBy",
> "filter":{
> "type":"and",
> "fields":[
> {
> "type":"or",
> "fields":[
> {
> "dimension":"traffic_channel",
> "type":"selector",
> "value":"RTB_BANNER"
> }
> ]
> },
> {
> "type":"not",
> "fields":[
> {
> "dimension":"device",
> "type":"selector",
> "value":"Computer"
> }
> ]
> },
> {
> "type":"or",
> "fields":[
> {
> "dimension":"inventory_type",
> "type":"selector",
> "value":"SITE"
> }
> ]
> }
> ]
> }
> }
>
> Thanks,
> Serdar
>
> *Serdar Sakin, PMP* | *Project Manager*
>
> [image: logo.png] <http://reklamstore.com/>
>
> A: Yeşilce Mh. Diken Sk. No:4 K:4, 4. Levent / İstanbul
> T: +90 212 284 4449 <+90%20212%20284%204449> Ext: 682
> M: +90 532 133 0741 <+90%20532%20133%200741>
> E: ser...@reklamstore.com
> Skype: serdar-rs
> W: reklamstore.com
>
