hello why my date filter dosen't work, i've seen a lot of question here and they helped me to optimise my configuration, but date filter still dosen't work :
my column1 still of type String and i still got a @timestamp seapratly with today is time
what i want is the columne1 ("which represent the time in my case"), convert from string to date.
I'have read some posts here , may be i didn't understood them well, mentioning that i should create a date filter then add a target to timestamp so the timestamp would be the time of column1.
what i want is the columne1 ("which represent the time in my case"), convert from string to date.
You can use the date filter to parse the original date and store it back to the same field (use the target) option. Then ES will auto-detect that field as a timestamp, but that will only happen when you recreate the index since the mapping of an index's field can't be changed.
You can also set the mapping explicitly to have ES accept the original field value as a timestamp.
timezones are important, especially if you have logs where the dates are stored in different time zones.
In our application, which we are monitoring with elastic stack, some logs have times stored in utc, other logs are using local time.
When I set the exact timezone for each log, then the date filter is converting correctly to utc.
When querying a time interval in kibana, then all log entries / documents are shown correctly referring to my browsers timezone. So I don't need to remember which log is stored in which time zone as kibana user, because all documents are 'moved' to utc.
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.