I tried to use logstash to deliver the data from mysql to elasticsearch. but when i run the jdbc.conf, i found that all the fields in mysql were converted to lowsecase which exactly was not my hope. Can someone help me to fix it? below is part of the file:
jdbc_driver_library => "E:/ELK/sqltoes/mysql-connector-java-5.1.42.jar"
the name of the driver class for mysql
jdbc_driver_class => "com.mysql.jdbc.Driver"
#jdbc_paging_enabled => "true"
#jdbc_page_size => "50000"
statement_filepath => "/usr/local/logstash-5.6.3/test_mysql/jdbc.sql"
statement => "SELECT * from test_collection "
schedule => "* * * * *"
connection_retry_attempts => 3
connection_retry_attempts_wait_time => 1