How to query empty values of number type and date type fields

Hi all.....
we have a index having number type field which holds some empty values as well
but when we try to filter empty(null) event from kibana discovery we are getting error

Discover: [parsing_exception] [match] unknown token [VALUE_NULL] after [query], with { line=1 & col=177 }
Error: [parsing_exception] [match] unknown token [VALUE_NULL] after [query], with { line=1 & col=177 }
   at respond (
   at checkRespForFailure (
   at processQueue (
   at Scope.$eval (
   at Scope.$digest (
   at Scope.$apply (
   at done (
   at completeRequest (

here is index details

PUT number
  "mappings": {
    "my_type": {
      "properties": {
        "ExpireTime": {
          "type":       "long"
PUT number/my_type/1
  "ExpireTime": 1
PUT number/my_type/2
  "ExpireTime": 1.1
PUT number/my_type/3
  "ExpireTime": null

How can i over come with this problem?

Thank You

Hi kabali12345,

What version of kibana are you using? And what is the query you are using in the discovery searchbox?

Can you try exists:ExpireTime and see if it works?


Yes it's worked
Thank you @luiz.santos

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.