Kibana Terms panel showing date fields as longs?

[Chris Neal]

Hello :)

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+unsubscr...@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.