Hi every one. My local table has 3000 rows. When I config logstash output with document_id => "%{countyId}". Just only lastest row is inserted to ElasticSearch. But when I not use document_id => "%{countyId}" so it work fine. Please any one help me. Thank you.

Try to add this parameter lowercase_column_names => false as follow input { jdbc { jdbc_driver_library => "C:\ELK\elasticsearch-7.12.0-windows-x86_64\elasticsearch-7.12.0\lib\sqljdbc_9.2\enu\mssql-jdbc-9.2.1.jre8.jar" jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver" jdbc_…

ylasri (Yassine LASRI) May 19, 2021, 9:49am 6

May be this ?

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

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.

Load data from SQL server to Elasticsearch with document_id on local