CODEWITHSUNDEEP
elasticsearchkibanakibana-4
feicipet
feicipet

Reputation: 954

Error parsing date histogram filter in Kibana visualization

I'm using Kibana version 4.4.1 with ES 2.2.0 from the Debian repos.

I have a field with the following type defined:

        "InvitationTime" : {
            "type" : "date",
            "format" : "dd/MM/yyyy HH:mm:ss Z"
        }

I created a data table visualization with a date histogram aggregation on this field:

Data table

When I click on one of the dates to filter though, I get an error where it tries to parse the millis-since-epoch value of the field in my field format:

Filter parse error

Is this a bug or am I doing something wrong?

Thanks Wong

Upvotes: 1

Views: 274

Answers (1)

Val
Val

Reputation: 217304

You need to modify your mapping with the following format instead: 

"format" : "dd/MM/yyyy HH:mm:ss Z||epoch_millis"

You also need to recreate your index and re-index your data. It should work fine.

Upvotes: 1

Related Questions