how to filter for not null dimensions?

[Prashant Deva]

I want to filter out dimensions that have null value in my query.

I dont see a 'not null' filter. How do i achieve this?

[Nishant Bangarwa]

Hi Prashant, 

you can filter by specifying an empty value for filtering null values. 

e.g. - 

{ 

   "type" : "not", 

    "field" :  { 

                   "type" : "selector", 

                   "dimension" : "dimension_name", 

                   "value" : ""

                  } 

} 

On Tue, Sep 2, 2014 at 3:34 AM, Prashant Deva <prasha...@gmail.com> wrote:

I want to filter out dimensions that have null value in my query.

I dont see a 'not null' filter. How do i achieve this?

--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/9819f4a0-cf02-4452-83da-cc3bdcc3eae0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Nishant Software Engineer | METAMARKETS m  +91-9729200044 nishant....@metamarkets.com

[Prashant Deva]

Looking around on this group, it seems checking for null dimentions values is extremely buggy in druid:

https://groups.google.com/d/msg/druid-development/o4ue-qKRxjI/7RxRTHsl48oJ

That post is from a while back.

Are things much more stable now in this regard?

Or are those posts talking of something else entirely and this (your answer query) was always stable to begin with?

[Prashant Deva]

can someone please respond to this

[Nishant Bangarwa]

Hi Prashant, 

Druid internally treats null values and empty strings as same, 

There has been some inconsistency in handling of null values at some places, fixing that is in roadmap for 0.7.x. 

For more info on the fixes you can follow - https://github.com/metamx/druid/issues/665

To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/982dee6f-6b2c-44fc-b212-d5da6d7b4a30%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.