With logstash I am trying to Extract some tables, Transform them locally on the logstash mashine, and then Load the result to Elasticsearch. The reason for this solution is due to very limited computing power on the source server, a MariaDB. I have tested the input{} separately, it works, so the c…

I got to change the setting on our own mariaDB database to sql_mode = 'ANSI_QUOTES' and then the jdbc_static script works on our own setup

Discuss the Elastic Stack

Jdbc_static: Getting a sql syntax error I did'nt write

Elastic Stack Logstash

ErikWarming (Erik Warming) July 4, 2019, 12:26pm 4

Its looks very related, but I am not sure how to use "The answer"

The Answer is: SET GLOBAL sql_mode = 'ANSI_QUOTES';

ELK logstash config statement error for mongodb input-jdbc plugin

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.