I get data from an sql server database and i have a date on a string format like this : "2017-04-25 00:00:00 +0200" and I want to use grok filter to transform this to a similar format to @timestamp
I have this code grok { match => ["message","(?<log_date>%{YEAR}-%{MONTHNUM}-%{MONTHDAY} %{HOUR}:%{MINUTE}:%{SECOND},[0-9]{3}) %{GREEDYDATA:jsonfield}"] }
In Kibana i got this error message : Expected numeric type on field [txechecczhier_date], but got [string]
So i suppose that the problem come from my filter, any idea guys to help to solve this?
Thank you for replying me as quickly. When i delete the filter i have this result in a file : {"txechecczhier_date":"2017-04-25 00:00:00 +0200","txechecczhier_tx":2.08,"@version":"1","@timestamp":"2017-04-28T12:51:01.476Z"}
I want to display my txechecczhier_date in kibana, the date is different from the timestamp. With date filter we can transform a string to a timestamp?
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.