Hi ,
We are using the logstash jdbc input. i also specified the date format to custom format. but still in elastic stored as dd-mm-yyThh:mm:ss this format. and also i mentioned the date field mapping in elasticsearch as
field : trn_date
format : dd:mm:yy
this format will not used to convert the incoming date data?
The format is used to parse what you sent as a String to a Date object.
Then what is "stored" in the _source is what you sent in the original format.
Elasticsearch does not modify the _source field (unless you are using node ingest feature).
We are using the logstash jdbc input.
That's a new information.
So probably that's how logstash is reading the data from the database. But I'd ask this in #logstash forum instead.
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.