Does the index to which that mapping is applied to matches the index generated in Elasticsearch?
Do you get mapping_parser_exception in Elasticsearch ?
How are you polling the data from your database and indexing into Elasticsearch? If you are using Logstash then you can do a date type conversion using the date filter to match the datatype of your log_date field in your mapping. I am suspecting you have some records in your database that does not match that format and which causes the Error.
Your derived field in your SQL query in JDBC plugin is logged_date which matches your field name in the mapping but you are matching on logdate in the match statement in date filter. Change that to logged_date.
elasticsearch always stores times as UTC. kibana will adjust them to the browser's timeone by default. If your log entries are not in UTC use the timezone option on the date filter to tell logstash what timezone they are in.
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.