Date and DateTime fields Problem ?

[wistala]

I installed elasticsearch 2.1.1 version and i added go-mysql-elasticsearch then when i executed code everything worked fine. go-mysql-elasticsearch started to listening log file , there is no error or warning but when i update a row in mysql or insert a new row date and datetime fields are synchronizing empty to elasticsearch what can be the problem ?

[siddontang]

Hi @wistala
We don't support time now, you can see go-mysql-org/go-mysql#45 but this PR has not been merged.

[pinepain]

Hi, any progress on supporting datetime? I see that PR was merged.

[siddontang]

Hi @pinepain
No progress now. But I think it may be easy to support it.
Can you tell me how to insert datetime/timestamp/time type to ES, using a string like "2016-01-01 00:00:00" is ok?

[pinepain]

@siddontang I guess in order to insert in such format it needs to have date field format specified (https://www.elastic.co/guide/en/elasticsearch/reference/2.1/date.html), so sth, like this:

        "date": {
          "type":   "date",
          "format": "yyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis"
        }

[hzruandd]

@siddontang
ES support the UTC time format，such as "2016-11-16T08:53:56.359Z"

[siddontang]

Thanks @pinepain @hzruandd

I have no time to handle time now. I have to fix some bugs in go-mysql, then I will update the vendor and try to support it later.

[pinepain]

@siddontang thank, if I will have some time and finally get to this awesome tool, I'll try to add it myself. However, my requirements goes slightly out of scope of what this tool do as I need to do some transformations and combine more data on the fly, so I would probably stick to raw go-mysql and then communication with elastica by my own.

But anyway, thanks for looking in and for this great tool!