Setting timed-based does not working


#1

Hello everyone !

I just started to work with ElasticSearch and Kibana since couple of time, and I still cannot set a date field as time-based when I configure my index pattern. When I choose my date field (named timestamp) on the timefield name, I cannot Visualize any data on the Discover part.

However, when I uncheck the box named Index contains time-based events, all data is available on Discover :

Is there something wrong I've made or something I forgot ? There is the mapping I've made:

"index_test" : {
    "mappings": {
    "tr": {
        "_source": {
            "enabled":true
        },
        "properties" : {
            "id" : { "type" : "integer" },
            "volume" : { "type" : "integer" },
            "high" : { "type" : "float" },
            "low" : { "type" : "float" },
            "timestamp" : { "type" : "date", "format" : "yyyy-MM-dd HH:mm:ss" }
        }
    }
    }'
}

And there is the Python script I used to insert data into ES:

from elasticsearch import Elasticsearch

jsondata(json.dumps("{
    "low": "5.9400",
    "high": "5.9600",
    "id": "555",
    "volume": 1171,
    "timestamp": "2016-08-15 19:01:03"
    }"
)
ES_HOST = {"host" : "localhost", "port" : 9200}
es = Elasticsearch(hosts = [ES_HOST])

    es.create(index="index_test",
              doc_type="tr",
              body=jsondata
          )

Any tips about ?


(Mark Walkom) #2

Did you set the timepicker accordingly?


#3

Oh... This was so simple ^^" I forgot to set the timestamp on right-top of Kibana interface...

Thank you anyway, I will try to find an harder question next time !


(system) #4