Kibana Terms panel showing date fields as longs?


(Chris Neal) #1

Hello :slight_smile:

I have some log data indexed in ES and trying to visualize in Kibana and
getting strange behavior related to dates. I have Terms panel with the
following settings:

Terms mode: terms
Field: date
Length 10
Order: count

For some reason, the "date" column in the panel is showing up as a long,
not a date:

COUNTBYDATE

TermCountAction146629440000096597 146638080000060063 146620800000059480
The Table panel showing all my log entries knows that field is a date, and
it displays as a date correctly.
If I curl the request to ES, it appears ES is returning it as a long, not a
date:

curl -XGET 'http://localhost:9200/test/_search?pretty' -d '{
"facets": {
"terms": {
"terms": {
"field": "date",
"size": 10,
"order": "count",
"exclude": []
},
"facet_filter": {
"fquery": {
"query": {
"filtered": {
"query": {
"bool": {
"should": [
{
"query_string": {
"query": "_type:test_type"
}
}
]
}
},
"filter": {
"bool": {
"must": [
{
"range": {
"date": {
"from": 1465925902106,
"to": 1466769177326
}
}
}
]
}
}
}
}
}
}
}
},
"size": 0
}'

returns:

{
"took" : 387,
"timed_out" : false,
"_shards" : {
"total" : 10,
"successful" : 10,
"failed" : 0
},
"hits" : {
"total" : 48173413,
"max_score" : 0.0,
"hits" : [ ]
},
"facets" : {
"terms" : {
"_type" : "terms",
"missing" : 0,
"total" : 365090,
"other" : 0,
"terms" : [ {
"term" : 1466294400000,
"count" : 96697
}, {
"term" : 1466380800000,
"count" : 60343
}, {
"term" : 1466208000000,
"count" : 59579
}, {
"term" : 1466121600000,
"count" : 51592
}, {
"term" : 1466035200000,
"count" : 48859
}, {
"term" : 1465948800000,
"count" : 48020
} ]
}
}
}

Is there something I can do to have Kibana recognize the term is a date and
display it as "2014-06-17" like the Table panel does?

Thanks so much!

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAND3DpjWrZD8xiKCEDzXmcvydoQzztN-4q1%2BVr3rhaH4H0HEUQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(system) #2